ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reducing Excel File Size (https://www.excelbanter.com/excel-programming/383057-reducing-excel-file-size.html)

vee

Reducing Excel File Size
 
I already looked up all the advice on this on the web - and the only thing I
found is how to make sure the last cell used is not a billion lines below my
actual data. Fixing this only reduced my workbook by a few kb's. My workbook
is almost 10 mega so I have to do something drastic.

I also cleaned up all my temp files - especially Excel - and changed my
calculation to "manual."

Does anyone have new advice that works?


Jim Thomlinson

Reducing Excel File Size
 
How much data do you have in your workbook. If there is 10mb of data in it
then that is the size it is going to be... Secondly what is the issue with it
being 10mb. Is it running slow or is it to big to email or???
--
HTH...

Jim Thomlinson


"Vee" wrote:

I already looked up all the advice on this on the web - and the only thing I
found is how to make sure the last cell used is not a billion lines below my
actual data. Fixing this only reduced my workbook by a few kb's. My workbook
is almost 10 mega so I have to do something drastic.

I also cleaned up all my temp files - especially Excel - and changed my
calculation to "manual."

Does anyone have new advice that works?



All times are GMT +1. The time now is 03:06 PM.

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