Slow sumproduct Dbase

W

wx4usa

Hello all,

I have a Dbase in excel 2007. there are 30,000 rows and 15 columns of
numeric data. I am running several (6) reports from the Dbase in the
same workbook. My calc is set to manual.

It is getting slow. QUESTION: Would it speed up if my reports are
each in (6) different workbooks thus updating only 1 report a ta time
or will Excel update the links in the closed workbooks too?
 
S

Sheeloo

Excel does not update links in closed workbooks. It is done when the workbook
is opened next time.
 
W

wx4usa

Excel does not update links in closed workbooks. It is done when the workbook
is opened next time.
Click to expand...

Thank you so much! I didnt want to move all the reports only to find
it did not help!

Thanks Sheeloo
 

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

Excel Sumproduct Ref error when table is closed 0
Excel 2003 automatic calculation all worksheets except one 3
Slow Sumproduct 1
Import from workbook cells to access table 8
SUMPRODUCT Formula 4
Find - replace automatic 7
Uisng the Max and Index function to link to other workbooks 1
Named Ranges & Calculation Times Query 5

Top