Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing Filesize of Workbooks
Hi there,
Is there any simple method of reducing the filesize of a workbook? Thx in advance Gerry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing Filesize of Workbooks
Maybe...
If you hit ctrl-end and the active cell is way past what you think it should be... Debra Dalgleish shows techniques to reset that last used cell: http://contextures.com/xlfaqApp.html#Unused gerhard nowak wrote: Hi there, Is there any simple method of reducing the filesize of a workbook? Thx in advance Gerry -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing Filesize of Workbooks
Delete unused VBA macros and modules.
I had a bunch of Excel worksheets, with the same macros, so I put all the macros in a special file, where they could be maintained more easily, and deleted the modules from the other files. I save at least 25K on each file. "gerhard nowak" wrote: Hi there, Is there any simple method of reducing the filesize of a workbook? Thx in advance Gerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Can anybody reproduce my EXPLODING filesize workbooks? 100kb - 30 | Excel Discussion (Misc queries) | |||
Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |