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