Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formatted whole page, file is now huge Ian Elliott Excel Discussion (Misc queries) 3 March 16th 09 03:46 PM
Excel Huge File. Dan Excel Discussion (Misc queries) 2 September 16th 08 07:42 AM
huge huge excel file... why? Josh Excel Discussion (Misc queries) 12 February 9th 06 09:55 PM
File got huge BW Excel Discussion (Misc queries) 2 January 11th 05 01:57 AM
The XLS file is huge! Ron de Bruin Excel Programming 0 October 6th 03 03:44 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"