slow moving calculations between pages

  • Thread starter Thread starter ajr11
  • Start date Start date
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:
 
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
 
You must log in or register to reply here.

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

Calculation time - can't find the bottleneck 1
Pages going very slow to the print spooler 1
Named Ranges & Calculation Times Query 5
Problem with Calculated item in Pivot Table 1
Inserting rows slow on large report 6
Calculate message 1
Lessons from optimizing a slow spreadsheet 2
Making a spreadsheet calculate faster 4

Back
Top