I have seen many cases in my career where analysts have done just that…opened a workbook with calc set to manual, opened a whole bunch of others where calc was set to auto, and then done an entire day’s work without realizing that calculation was subsequently turned off for all of them. If the mode of calculation in a workbook changed and the file is saved, the current mode of calculation is saved. The Calculation Option keeps switching from Auto to Manual and since we dont see it, we have bogus data. What’s worse, when you open two workbooks, one saved in manual mode and one saved in automatic mode, they will both have the calculation mode of the first workbook opened. Hi All, One computer in our office is having an odd action. There’s just too much chance that someone someday will use output of such a model without remembering to set calculation to Auto. I’d never set calculation to manual if I could help it. The only option you have is to set calculation for the entire file to manual. Setting calculation to manual - or replacing formulas with values - is dangerous. Again I refer you to the draft blog post I provided a link for at You need to address the fundamental design problems in your file. Harry, further to what Luke said, this would merely address the symptoms, while effectively sweeping the root cause under the carpet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |