| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Memory per Sheet
Hi all. Does anyone have a utility or know how to determine how much memory
each sheet in a workbook is responsible for? I have a workbook that is 21MB in size. I'd like to reduce the size, but it would be easier if i knew which sheets in particular were the memory hogs. Thanks! -Steph |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Memory per Sheet
Hi
don't think such an utility exists but you may check the used range for each sheet (and correct it). See: http://www.contextures.com/xlfaqApp.html#Unused -- Regards Frank Kabel Frankfurt, Germany Steph wrote: Hi all. Does anyone have a utility or know how to determine how much memory each sheet in a workbook is responsible for? I have a workbook that is 21MB in size. I'd like to reduce the size, but it would be easier if i knew which sheets in particular were the memory hogs. Thanks! -Steph |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Memory per Sheet
Utility does exist ...
"Frank Kabel" wrote in message ... Hi don't think such an utility exists but you may check the used range for each sheet (and correct it). See: http://www.contextures.com/xlfaqApp.html#Unused -- Regards Frank Kabel Frankfurt, Germany Steph wrote: Hi all. Does anyone have a utility or know how to determine how much memory each sheet in a workbook is responsible for? I have a workbook that is 21MB in size. I'd like to reduce the size, but it would be easier if i knew which sheets in particular were the memory hogs. Thanks! -Steph |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Memory per Sheet
Hi Charles
now I'm interested :-) An utility to check the memory usage of an individual sheet within a workbook (and without tricks like copying this sheet to a separate file and getting that memory usage). There is it <vbg -- Regards Frank Kabel Frankfurt, Germany Charles Williams wrote: Utility does exist ... "Frank Kabel" wrote in message ... Hi don't think such an utility exists but you may check the used range for each sheet (and correct it). See: http://www.contextures.com/xlfaqApp.html#Unused -- Regards Frank Kabel Frankfurt, Germany Steph wrote: Hi all. Does anyone have a utility or know how to determine how much memory each sheet in a workbook is responsible for? I have a workbook that is 21MB in size. I'd like to reduce the size, but it would be easier if i knew which sheets in particular were the memory hogs. Thanks! -Steph |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Memory per Sheet
Hi Steph,
This question must be almost identical to to one that someone posted in June., because right after I wrote it someone asked such a question. Save each worksheet separately to multiple workbooks (#MakeMultipleXLSfromWB) Saveas, Save each worksheet as a separate workbook http://www.mvps.org/dmcritchie/excel/saveas.htm and them look in the generated subdirectory of your c:\temp\D.... to see the file sizes. --- 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 don't think such an utility exists but you may check the used range for each sheet (and correct it). See: http://www.contextures.com/xlfaqApp.html#Unused -- Regards Frank Kabel Frankfurt, Germany Steph wrote: Hi all. Does anyone have a utility or know how to determine how much memory each sheet in a workbook is responsible for? I have a workbook that is 21MB in size. I'd like to reduce the size, but it would be easier if i knew which sheets in particular were the memory hogs. Thanks! -Steph |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Memory per Sheet
Charles & Frank,
I'm confused.....there is a utility that does that? Where? I didn't see a link or anything to your previous posts?! Thanks! -Steph "Frank Kabel" wrote in message ... Hi Charles now I'm interested :-) An utility to check the memory usage of an individual sheet within a workbook (and without tricks like copying this sheet to a separate file and getting that memory usage). There is it <vbg -- Regards Frank Kabel Frankfurt, Germany Charles Williams wrote: Utility does exist ... "Frank Kabel" wrote in message ... Hi don't think such an utility exists but you may check the used range for each sheet (and correct it). See: http://www.contextures.com/xlfaqApp.html#Unused -- Regards Frank Kabel Frankfurt, Germany Steph wrote: Hi all. Does anyone have a utility or know how to determine how much memory each sheet in a workbook is responsible for? I have a workbook that is 21MB in size. I'd like to reduce the size, but it would be easier if i knew which sheets in particular were the memory hogs. Thanks! -Steph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
| Out of memory? | Excel Discussion (Misc queries) | |||
| Vba Memory | Excel Discussion (Misc queries) | |||
| The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming | |||
| write marco to put data from sheet to memory | Excel Programming | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
