Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook got too large
I am creating a template with VBA code to run it. I also use cell names. I started out with 16 sheets and saved it and it was 53K. I added the formatting and named 6 columns that are used for totals and when I saved it the size was now 7,345K. I deleted all the names and it never got smaller. Is there a way to clean it up? Thanks… -- Wilbur ------------------------------------------------------------------------ Wilbur's Profile: http://www.excelforum.com/member.php...o&userid=31826 View this thread: http://www.excelforum.com/showthread...hreadid=521343 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook got too large
Hi Wilbur,
I have a similar project with a templates workbook consisting of 17 product sheets, and 2 hidden maintenance sheets (query lists). Each template has 2 picture objects, tons of Conditional Formatting and Data Validation cells, and a very long list of local defined names. There's no controls on any sheets because everything is handled by built-in functions or their associated add-in. There's also no VBA components (userforms, modules). The file size is 797kb. I don't think that's a "clean" size because I've been modifying it like crazy lately and haven't done any housekeeping yet. You might want to think about rebuilding it, but that would mean some major surgery like Robert indicated. One thing I've noticed about Excel files behavior is, you can open a file in another version, do nothing, and after you save it, it shrinks in size.<?? I think maybe the file is what some term as "corrupt", and probably should be rebuilt from scratch if it can't be sorted out. <IMO HTH Good luck! GS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a chart to large workbook brings workbook activity to a hal | Excel Discussion (Misc queries) | |||
Large Workbook - trouble opening | Excel Discussion (Misc queries) | |||
Macro for Large workbook | Excel Worksheet Functions | |||
Non-calculation in large workbook | Excel Discussion (Misc queries) | |||
make large worksheet from workbook | Excel Discussion (Misc queries) |