Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumProduct too slow | Excel Worksheet Functions | |||
Slow Sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct Slow | New Users to Excel | |||
Sumproduct formulas & slow response | Excel Worksheet Functions | |||
sumproduct formula to slow | Excel Worksheet Functions |