Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Why is MS Excel acting up?
At work, we use Microsoft Excel spreadsheets to track our price lists. We have three price lists connected to a main list. When something is modified in the main list, it does not always update the other lists, but sometimes it does. All of the formulas appear to be correct. Does anybody know what the problem may be?
2 Answers
- garbo7441Lv 71 decade agoFavorite Answer
Are these separate workbooks? Or, separate worksheets in the same workbook? If they are separate workbooks, Any dependent workbook not open when the main workbook is modified will not be updated. Do you have a macro to make sure they are all open when the main workbook is opened?
- Anonymous1 decade ago
would really need a bit more information, such as the formulas of the cells which arn't updating etc
there is a setting which prevent the sheet from automatically updating, requiring you to tell it when to update, but i doubt that is the answer as you say it works sometimes.
wish i could be more help, but i dont have enough info.
