ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delay while entering data (https://www.excelbanter.com/excel-discussion-misc-queries/67006-delay-while-entering-data.html)

Aaron Saulisberry

Delay while entering data
 
I had a fairly clean workbook and all was well. Until, that is I started
adding formulas to perform calculations.

Most of my calculations are usiing the SUMPRODUCT function so I'm wondering
it that could be the problem. There is no VBA code in the worksheet, strickly
formulas.

System Specs are...

P4 3.2 GHz
1GB RAM
ATI x800 256MB video
60GB HDD

Kick ass laptop that can run any game out there but stumbles over data
calculations? Is this normal?

Bob Phillips

Delay while entering data
 
Depends upon how many, and the amount of data being evaluated, but yes, SP
can be quite resource hungry, but if you are doing that much calculating,
most functions will be resource hungry.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Aaron Saulisberry" wrote in
message ...
I had a fairly clean workbook and all was well. Until, that is I started
adding formulas to perform calculations.

Most of my calculations are usiing the SUMPRODUCT function so I'm

wondering
it that could be the problem. There is no VBA code in the worksheet,

strickly
formulas.

System Specs are...

P4 3.2 GHz
1GB RAM
ATI x800 256MB video
60GB HDD

Kick ass laptop that can run any game out there but stumbles over data
calculations? Is this normal?





All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com