Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Optimize RAM Utilization
http://www.decisionmodels.com/memlimits.htm
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Paul M." wrote in message ... We commonly create large workbooks for client solutions that are used within our ScarDec System but are challenged by the use of RAM by these workbooks and the RAM freed up by the Save operation. Example - A 40mb Excel file opens to 130mb of RAM, but will drop to 89mb once a save command is executed. Another 80mb Excel file opens to 220mb but will drop to 140mb once saved (this one originally had some Scenario Manager work which was later removed). We assume that the save procedure is either dropping some background data or compressing data. - Already tried reducing the # of Undo's in the registry - no results - Workbooks do not include extensive VBA code in the workbook, they access proprietary DLL's but that should have not impact on RAM Any ideas on programming solutions to achieve the lower RAM utilization without having to execute a "time consuming" save operation. Can additional parameters be added to the file opening procedure? Any ideas would be greatly appreciated. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.692 / Virus Database: 453 - Release Date: 28/05/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warehouse utilization Template | Excel Discussion (Misc queries) | |||
I want to track tool utilization, tracking by hour and day. | Excel Discussion (Misc queries) | |||
Low CPU Utilization | Excel Discussion (Misc queries) | |||
Increased CPU utilization in Excel 2003 | Excel Discussion (Misc queries) | |||
How can I optimize this code? | Excel Programming |