excel not calculating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manual calculation to Automatic on close - BUT without recalculati 1
VBA to run all variable combinations in a calculation model and store result 6
Stop Auto Calculation Q 11
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Improving Nested Formula Calculation Efficiency 2
Is there a way to speed up Calculation !!!!!!!!!!!!!!! 4
Make VBA Enter Formula into cell rather than calculation 1
Code to calculate only visible cells 1

Back
Top