Home 
Search 
Today's Posts 
#1




Why did auto calculate suddenly change to manual calcu...
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? 
#2




Why did auto calculate suddenly change to manual calcu...
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? 
#3




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? 
#4




Why did auto calculate suddenly change to manual calcu...
"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? I have experienced the same thing for years, changes on it's own for some reason! I did not change it and it was never saved or changed to manual. Can drive you nuts when you make a change and the answer doesn't change, that is if you notice! I have never found an explanation. 
#5




Why did auto calculate suddenly change to manual calcu...
Excel picks up this setting from the first workbook it opens in that session.
So if you're in an environment where multiple people work on the same workbook (a common network drive or even an emailed workbook file), and you open a workbook that's been saved in manual calculation mode, you'll be in manual calculation mode. keith h wrote: "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? I have experienced the same thing for years, changes on it's own for some reason! I did not change it and it was never saved or changed to manual. Can drive you nuts when you make a change and the answer doesn't change, that is if you notice! I have never found an explanation.  Dave Peterson 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Help!Excel will not calculate formulas Not in manual calculation  Excel Worksheet Functions  
manual calculate  Excel Discussion (Misc queries)  
why would calculate change from automatic to manual on its own?  Excel Discussion (Misc queries)  
Suddenly cannot calculate functions or formulas in Excel  Excel Worksheet Functions  
Suddenly Excel can't calculate formula!!!  Excel Worksheet Functions 