ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reducing file size (for archiving, not active files) (https://www.excelbanter.com/excel-programming/326476-reducing-file-size-archiving-not-active-files.html)

Shadhi

Reducing file size (for archiving, not active files)
 
I have found that one way to quickly and easily reduce file size for a
Workbook that contains macros is this: Open the file; disable macros; save
the file. In some cases, I've seen around 20% file size reduction on 250k
files. Sadly, next time the file is opened and macros are enabled, the file
size jumps up again. Still, this could be a useful step before emailing or
archiving a document.

If interested in another way to reduce file size, please read my related
question in this newsgroup.

-Shadhi


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com