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?

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?