| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's Not Calculating - HELP
I have a spreadsheet with a lot of worksheets included...it's about 13MB. My
formulas will NOT calculated on their own. The Automatic calculation is set but if I click in the cell as if I were to edit and hit enter, it will update. Can someone please help? Thanks -- Sandi Gardner |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula's Not Calculating - HELP
Hi Sandi,
Try this: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Sandi" wrote in message ... |I have a spreadsheet with a lot of worksheets included...it's about 13MB. My | formulas will NOT calculated on their own. The Automatic calculation is set | but if I click in the cell as if I were to edit and hit enter, it will | update. Can someone please help? | | Thanks | -- | Sandi Gardner |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula's Not Calculating - HELP
Most of those solutions we have checked and it's still not working. Could it
be that the workbook is too large for Excel to recognize where each of the formulas refer back to? -- Sandi Gardner "Niek Otten" wrote: Hi Sandi, Try this: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Sandi" wrote in message ... |I have a spreadsheet with a lot of worksheets included...it's about 13MB. My | formulas will NOT calculated on their own. The Automatic calculation is set | but if I click in the cell as if I were to edit and hit enter, it will | update. Can someone please help? | | Thanks | -- | Sandi Gardner |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula's Not Calculating - HELP
Yes, temporarily. That's why I suggested CTRL+ALT+SHIFT+F9
Did you try that? And did you read why you may be sure Calculation is set to Automatic but actually it's not? -- Kind regards, Niek Otten Microsoft MVP - Excel "Sandi" wrote in message ... | Most of those solutions we have checked and it's still not working. Could it | be that the workbook is too large for Excel to recognize where each of the | formulas refer back to? | -- | Sandi Gardner | | | "Niek Otten" wrote: | | Hi Sandi, | | Try this: | | http://xldynamic.com/source/xld.xlFAQ0024.html | | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Sandi" wrote in message ... | |I have a spreadsheet with a lot of worksheets included...it's about 13MB. My | | formulas will NOT calculated on their own. The Automatic calculation is set | | but if I click in the cell as if I were to edit and hit enter, it will | | update. Can someone please help? | | | | Thanks | | -- | | Sandi Gardner | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas stop calculating | Excel Discussion (Misc queries) | |||
| Printing formulas | Excel Discussion (Misc queries) | |||
| calculating results in formulas | Excel Discussion (Misc queries) | |||
| Turning off auto unhide when calculating formulas | Excel Worksheet Functions | |||
| Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
Hybrid Mode
