Calculating

K

Keith

I have a large spreadsheet with a lot of complicated
formulas.

Whenever I update the data (It's external) the sheet
insists on re-calculating the whole sheet.

Is there any way for it to only calculate any new
information?
 
D

David McRitchie

Tools --> Options --> Calculation
try clearing the Save external link values
 

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

Turning off automatic calculation 0
Split form 0
Cell data entering slow! 0
Data consolidation 0
Calculation Time 2
Link Excel to word 2
Enable Iterative Calculations 0
Section and Page numbering 0

Top