ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel not calculating (https://www.excelbanter.com/excel-programming/355331-excel-not-calculating.html)

Rob

excel not calculating
 
I have a very large excel workbook (about 60MB) that I created with some
nested if statements, and sumproduct calculations, about 25 macros including
a macro that does an intense caluculation, and all types of other formulas.
I created this for the planning department of a large organization.

All of a sudden today, it will not calculate anything. When the data is
changed nothing happens. I can't even get it to calculate manually. I have
all the automatic calculations settings correct. Can anyone help?

Charles Williams

excel not calculating
 
Try Ctrl-Alt-F9 (calculate Full)

if that does not work try Ctrl-Alt-Shift-F9 (calculate full rebuild
dependency trees)


Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Rob" wrote in message
...
I have a very large excel workbook (about 60MB) that I created with some
nested if statements, and sumproduct calculations, about 25 macros
including
a macro that does an intense caluculation, and all types of other
formulas.
I created this for the planning department of a large organization.

All of a sudden today, it will not calculate anything. When the data is
changed nothing happens. I can't even get it to calculate manually. I
have
all the automatic calculations settings correct. Can anyone help?





All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com