Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file Size
Hi
Can anyone tell me how to reduce the size of the excel file? which is having lot of data with formatting, formula and macros on it. As I daily need to send across the data to the team members which come in "2MB" as I want it to be reduce. help me on this. -- vijay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel file Size
First make sure your usedrange on each sheet is what you think it should be.
See Debra Dalgleish's site for how-tos on this. http://www.contextures.on.ca/xlfaqApp.html#Unused You could ZIP it..................I have a 2201KB file which when zipped, reduces to 204KB Gord Dibben MS Excel MVP On Tue, 27 Jan 2009 15:38:01 -0800, vijay wrote: Hi Can anyone tell me how to reduce the size of the excel file? which is having lot of data with formatting, formula and macros on it. As I daily need to send across the data to the team members which come in "2MB" as I want it to be reduce. help me on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Excel file Size | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) |