View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Why did auto calculate suddenly change to manual calcu...

This can also cause headaches going the other way when you *want* XL to open
the file in manual mode. We deal with several complex worksheets that
normally take 5+ minutes to calc, and so se save them in manual mode.

However, whenever someone forgets and opens a regular workbook up first and
then open the BIG one, they get a nice surprise...
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gary''s Student" wrote:

Be careful of what you open.

If you open a file that was saved in Manual calculation mode, that is the
mode Excel will assume that you want.
--
Gary''s Student - gsnu201001


"pfelton" wrote:

Excel 2007 - Yesterday I had 2 users call with the same spreadsheet problem.
After creating a formula, they copied it down with the right click copy and
paste commands. Excel put the same number that was in the original cell in
the cells that were pasted to. The formula for each cell was correct when we
checked them but the results were not. i.e. The formulas updated correctly.
They remained the same as the original. When we changed the data cells that
the formulas referred to, nothing happened. The formula was for a basic
subtraction between 2 cells. I went to Excel Options, Formulas and Workbook
calculations was set to Manual. When I changed it to Automatic everything was
fine.
Why would this suddenly change? Both users said they didn't change it. Is
there a keystroke combination that would have changed it?