Posted to microsoft.public.excel.misc

wx4usa

external usenet poster

Posts: 122

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SumProduct too slow	diaare	Excel Worksheet Functions	6	October 29th 07 08:20 PM
Slow Sumproduct	wx4usa	Excel Discussion (Misc queries)	1	August 26th 07 11:23 PM
Sumproduct Slow	wx4usa	New Users to Excel	4	January 27th 07 07:05 PM
Sumproduct formulas & slow response	Darby	Excel Worksheet Functions	1	November 21st 05 09:21 PM
sumproduct formula to slow	Todd	Excel Worksheet Functions	4	December 21st 04 11:25 PM

All times are GMT +1. The time now is 10:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us