Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet won't calculate
I have a large spreadsheet that will not calculate the most simple of formulas.
- auto calculate is on. - it still won't calculate using F9. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet won't calculate
http://xldynamic.com/source/xld.xlFAQ0024.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "frankfine" wrote in message ... |I have a large spreadsheet that will not calculate the most simple of formulas. | - auto calculate is on. | - it still won't calculate using F9. | Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet won't calculate
Niek Otten wrote: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "frankfine" wrote in message ... |I have a large spreadsheet that will not calculate the most simple of formulas. | - auto calculate is on. | - it still won't calculate using F9. Any suggestions?| On the same menu as Calculatio/automatic be sure that Iterations is set to at least 100. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet won't calculate
Thank you. It was the cell formatting that caused the problem. I had to
reset all cells to "General", and later reformat cells as needed. "Niek Otten" wrote: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "frankfine" wrote in message ... |I have a large spreadsheet that will not calculate the most simple of formulas. | - auto calculate is on. | - it still won't calculate using F9. | Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Automatically Re-Categorize a Downloaded Internet Spreadsheet | Excel Discussion (Misc queries) | |||
Does anyone have a spreadsheet to calculate stableford points | Excel Discussion (Misc queries) | |||
Has anyone built an Excel spreadsheet to calculate churn? | Excel Discussion (Misc queries) | |||
Setting up a spreadsheet to calculate apportionment of service cha | Excel Worksheet Functions | |||
#REF error on linked spreadsheet | Links and Linking in Excel |