Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formatted whole page, file is now huge | Excel Discussion (Misc queries) | |||
Excel Huge File. | Excel Discussion (Misc queries) | |||
huge huge excel file... why? | Excel Discussion (Misc queries) | |||
File got huge | Excel Discussion (Misc queries) | |||
The XLS file is huge! | Excel Programming |