| 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) | |||
Linear Mode
