Slow sumproduct Dbase
 

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?

Slow sumproduct Dbase
 

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

"wx4usa" wrote:

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?

Slow sumproduct Dbase
 

On Oct 24, 9:36*am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) &
"hotmail.com" wrote:
Excel does not update links in closed workbooks. It is done when the workbook
is opened next time.

"wx4usa" wrote:
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?

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

Thanks Sheeloo