LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default Poor Performance on LARGE Excel workbooks containing formulas

My Work Book contains:
Front sheet containing numerous 'SUMPRODUCT' & Limited 'COUNTIF' formulas.
Historic information is copied & pasted as 'VALUES'.
3 X Graphs
Filtered data reads from the front sheet with Value = Value.
Raw data contains some 50.000 lines & 38 columns. Range from 1.5 to 2
Million Cells of Data.

The WEB page gives some download options but 'our' business security
policies are stopping me from downloading the files due to "Possible Security
Threat".

Does this help?

regards

EricB

"Charles Williams" wrote:

22MB is not that large. Does not sound like a memory problem to me.

There is a lot of info about Excel memory and speeding up workbooks at
http://www.decisionModels.com


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"EricB" wrote in message
...
Is there a way to increase System Memory to handle large Work Books on
Excel2003? I get numerous "Not Responding" messages on large files. 22MB +
.... Numrous formular are contained in the workbooks and i can thus not
convert to .csv




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Very poor performance with Excel 2007 RossR Excel Discussion (Misc queries) 3 March 29th 07 12:12 AM
poor macro performance [email protected] Excel Programming 1 August 11th 06 07:52 PM
Performance in excel 97 is poor cctd Excel Discussion (Misc queries) 1 January 5th 06 03:12 PM
poor subroutine performance Alex East Excel Programming 1 February 27th 04 06:39 PM
Poor Worksheet Performance MD Excel Programming 6 August 5th 03 03:41 PM


All times are GMT +1. The time now is 06:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"