Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
size of excel files
Hi is there anyway to find out exactly what in an excel
file is contributing to its size? I wish to optimize for size. The spreadheet has a significant number of charts, worksheets, some VBA (which originally had a huge number of code until I reedited). The file is currently 1Mb. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
size of excel files
Hi Thanks.....,
Nothing specific but a recent request to split a workbook up into separate files for each worksheet does provide the means to see which sheets are taking up the most space by browsing the directory created that holds the individual sheets. Saveas, Save each worksheet as a separate workbook http://www.mvps.org/dmcritchie/excel/saveas.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Frank Kabel" wrote in message ... Hi only some things to test: - used range of your sheets - number of formulas - inserted pictures - charts, etc. But AFAIK there's no method to determine which of these parts are causing which amount of memory usage wrote: Hi is there anyway to find out exactly what in an excel file is contributing to its size? I wish to optimize for size. The spreadheet has a significant number of charts, worksheets, some VBA (which originally had a huge number of code until I reedited). The file is currently 1Mb. Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
size of excel files
Thanks guys... I was hoping there is an easy way.. But
your advice has narrowed the problem down for me.. Thanks -----Original Message----- Hi is there anyway to find out exactly what in an excel file is contributing to its size? I wish to optimize for size. The spreadheet has a significant number of charts, worksheets, some VBA (which originally had a huge number of code until I reedited). The file is currently 1Mb. Thanks in advance . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files saved to H drive are 0 byte size on initial save | Setting up and Configuration of Excel | |||
Linked Excel files change size when updated | Excel Discussion (Misc queries) | |||
How reduce the file size of Excel 2007 files (wasted non value spa | Excel Discussion (Misc queries) | |||
Can excel files be opened in fixed screen size preset by user? | Excel Discussion (Misc queries) | |||
A4 size Excel 2000 files wont fit | Excel Discussion (Misc queries) |