![]() |
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