• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculations Options

rdavis11

New Member
Thanks to this website, I was able to figure out that my Excel problem was due to the fact that my Calculations Options was set to Manual. I now know how to fix it now but, in the past, I would use Text to Columns to fix and it seemed to work but, every once in a while, this issue would come back. Is there something that I may accidently be hitting that causes the Calculations Options to switch from automatic to manual?
 
Hi Davis ,


Do you think this can help ?

[pre]
Code:
Even if you never change your calculation mode, it can be changed without your knowledge.
The calculation mode setting is affected by the first workbook that's opened during an Excel session.

So, if a co-worker sends you a workbook that was saved in Manual calculation mode,
and you open that workbook first thing in the morning, it could affect the rest of your Excel files.
[/pre]
Taken from here :


http://blog.contextures.com/archives/2010/07/19/is-your-excel-on-automatic-or-manual/


Narayan
 
Back
Top