ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   The XLS file is huge! (https://www.excelbanter.com/excel-programming/278863-re-xls-file-huge.html)

John Wilson

The XLS file is huge!
 
Miklas,

Are their any compress/shrink file methods like in Access?

Unfortunately, no.

Where Excel "thinks" your last row/column of data is and where
you "think" it is can be vastly different. Easy way to check is to
press Ctrl + End on each of the worksheets to see what Excel shows
as the last cell.

For ways to fix it, take a look he
http://www.contextures.com/xlfaqApp.html#Unused

John


Niklas wrote:

Hi
My XLS file consists of 20 sheets with between 10 and 150
rows and no more than 12 columns. On the sheets their are
some buttons, ckeckboxes and comboboxes. This file is 12
MB and it is to big. Are their any "Tips and tricks" to
make it smaller?
Are their any compress/shrink file methods like in Access?
Regards
/Niklas




All times are GMT +1. The time now is 05:25 PM.

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