slow moving calculations between pages

A

ajr11

I am working on a file (13.2 MB) with about 20K lines per tab (4 tabs
and several vlookups. When I enter new data on my "inputs" page, th
related calculations on the next page take 30 sec + to update. Wha
can I do to to speed up the file? I've made some attempts to reduc
the size, but my efforts seem to be in vain.

PLEASE HELP...thanks!

Abby:
 
J

jeff

Hi,

go to Tools/Options/Calculations tab. change
from automatic to manual calculations. then Excel
will only calculate all those relationships when
you hit F9.

jeff
 
Top