Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce file size
Hi,
I was wondering if there are any shortcuts to reduce the size of a file. I have a file that is 28MB and contains three macros, a tab with raw data (approx 50 x 500 rows), a tab to code the data using lookups, and two tabs with drop-downs to generate reports. I realize it may be difficult to give advice without viewing the file, but thought there may be some easy things that I may be missing. Any thoughts? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce file size
Matt,
Excel probably thinks that your worksheet(s) are larger than they should be. For a quick test, press Ctrl + End to see where Excel thinks your last row and column of data is on each worksheet. Take a look here for some help on correcting it: http://www.contextures.com/xlfaqApp.html#Unused John "Matt" wrote in message ... Hi, I was wondering if there are any shortcuts to reduce the size of a file. I have a file that is 28MB and contains three macros, a tab with raw data (approx 50 x 500 rows), a tab to code the data using lookups, and two tabs with drop-downs to generate reports. I realize it may be difficult to give advice without viewing the file, but thought there may be some easy things that I may be missing. Any thoughts? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce file size
That was it! My file size went from 28MB to 11MB. Thanks
for your help. Matt -----Original Message----- Matt, Excel probably thinks that your worksheet(s) are larger than they should be. For a quick test, press Ctrl + End to see where Excel thinks your last row and column of data is on each worksheet. Take a look here for some help on correcting it: http://www.contextures.com/xlfaqApp.html#Unused John "Matt" wrote in message ... Hi, I was wondering if there are any shortcuts to reduce the size of a file. I have a file that is 28MB and contains three macros, a tab with raw data (approx 50 x 500 rows), a tab to code the data using lookups, and two tabs with drop-downs to generate reports. I realize it may be difficult to give advice without viewing the file, but thought there may be some easy things that I may be missing. Any thoughts? Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help to reduce size of my file | Excel Discussion (Misc queries) | |||
Reduce File Size | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
reduce the size of a file | Excel Discussion (Misc queries) | |||
Need to Reduce the file size | Excel Discussion (Misc queries) |