#1   Report Post  
Old September 12th 06, 03:43 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,389
Default Making a file smaller

I have a spreadsheet that is 35mb in size and given the number of sheets and
calculations it should not be this big. It used to have a large number of
links in it that someone had put in, which I think contributed to the large
size. I broke those links but the size still will not come down.

Any suggestions or ideas of how I can easily compact or reduce the size of
this file?

Thanks in advance.

Dave

  #2   Report Post  
Old September 12th 06, 05:22 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default Making a file smaller

Excel is not very good at resetting itself if columns or rows are no
longer used. Click in any sheet and do CTRL-End - this will take you to
the cell which Excel thinks is the last-used cell, although you may
find there are several unused columns and/or rows beyond your data. If
this is the case, then highlight the offending rows/columns and Edit |
Delete to remove them. Save the file immediately and repeat with other
sheets.

Named ranges which are no longer needed can also take up a lot of
memory - Insert | Name | Define to see a list of what you have and
delete each one (in turn) that you no longer need, especially those
that refer to another workbook and the ones with #REF (sheets, rows or
columns may have been deleted).

Hope this helps.

Pete

Dave wrote:
I have a spreadsheet that is 35mb in size and given the number of sheets and
calculations it should not be this big. It used to have a large number of
links in it that someone had put in, which I think contributed to the large
size. I broke those links but the size still will not come down.

Any suggestions or ideas of how I can easily compact or reduce the size of
this file?

Thanks in advance.

Dave


  #3   Report Post  
Old September 13th 06, 04:21 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,389
Default Making a file smaller

Pete, this helped a lot. It went from 35mb to 784kb! Thanks.

"Pete_UK" wrote:

Excel is not very good at resetting itself if columns or rows are no
longer used. Click in any sheet and do CTRL-End - this will take you to
the cell which Excel thinks is the last-used cell, although you may
find there are several unused columns and/or rows beyond your data. If
this is the case, then highlight the offending rows/columns and Edit |
Delete to remove them. Save the file immediately and repeat with other
sheets.

Named ranges which are no longer needed can also take up a lot of
memory - Insert | Name | Define to see a list of what you have and
delete each one (in turn) that you no longer need, especially those
that refer to another workbook and the ones with #REF (sheets, rows or
columns may have been deleted).

Hope this helps.

Pete

Dave wrote:
I have a spreadsheet that is 35mb in size and given the number of sheets and
calculations it should not be this big. It used to have a large number of
links in it that someone had put in, which I think contributed to the large
size. I broke those links but the size still will not come down.

Any suggestions or ideas of how I can easily compact or reduce the size of
this file?

Thanks in advance.

Dave



  #4   Report Post  
Old September 13th 06, 09:27 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default Making a file smaller

Well, that's a big reduction!

Thanks for feeding back.

Pete

Dave wrote:
Pete, this helped a lot. It went from 35mb to 784kb! Thanks.

"Pete_UK" wrote:

Excel is not very good at resetting itself if columns or rows are no
longer used. Click in any sheet and do CTRL-End - this will take you to
the cell which Excel thinks is the last-used cell, although you may
find there are several unused columns and/or rows beyond your data. If
this is the case, then highlight the offending rows/columns and Edit |
Delete to remove them. Save the file immediately and repeat with other
sheets.

Named ranges which are no longer needed can also take up a lot of
memory - Insert | Name | Define to see a list of what you have and
delete each one (in turn) that you no longer need, especially those
that refer to another workbook and the ones with #REF (sheets, rows or
columns may have been deleted).

Hope this helps.

Pete

Dave wrote:
I have a spreadsheet that is 35mb in size and given the number of sheets and
calculations it should not be this big. It used to have a large number of
links in it that someone had put in, which I think contributed to the large
size. I broke those links but the size still will not come down.

Any suggestions or ideas of how I can easily compact or reduce the size of
this file?

Thanks in advance.

Dave






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
file will not open txskyhawk Excel Discussion (Misc queries) 4 April 19th 06 12:35 AM
Excel Outlook Attachments opening after several errors everytime cito_support Setting up and Configuration of Excel 2 March 13th 06 06:15 PM
default save as file type does not work gregf Excel Discussion (Misc queries) 5 February 10th 06 07:50 PM
How do I print several sheets in a workbook as one file, making t. aimeesue78 Excel Discussion (Misc queries) 2 April 7th 05 01:34 PM
is there a way to make an Excel file smaller than 296K? cardejaid Excel Discussion (Misc queries) 1 January 19th 05 09:38 PM


All times are GMT +1. The time now is 01:35 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017