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

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

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

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
|
|
|