how to reduce Excel workbook size

  • Thread starter Thread starter Mars
  • Start date Start date
M

Mars

The size of my Excel workbook quickly increases (I store
each document as a separate sheet in a single workbook, so
the number of sheets quickly increase). How to try reduce
workbook size? Since I am nor sure is the big size due
spreadheets quantity or due another reason. Wokbook
contains no macro.

Thanks
 
Honey Can I Shrink the Spreadsheet ?

Refer to the following article ...


DEALING WITH SPREADSHEET BLOAT

www.beyondtechnology.com/tips019.shtml

How Excel workbooks become bloated and what can be done about it.


Hope it Helps,

- Rodney POWELL
Microsoft MVP - Excel

Beyond Technology
Spring, Texas USA
www.BeyondTechnology.com




The size of my Excel workbook quickly increases (I store
each document as a separate sheet in a single workbook, so
the number of sheets quickly increase). How to try reduce
workbook size? Since I am nor sure is the big size due
spreadheets quantity or due another reason. Wokbook
contains no macro.

Thanks
 
'Note: You can also go into the VBE (Visual Basic Editor)
and execute the command ActiveSheet.UsedRange in the
Immediate window to reset the UsedRange without having to
save.'
Where do located this 'Immediate window'? Will this
operation restore normal workbook size without manual
removing additional rows/columns?




-----Original Message-----
Honey Can I Shrink the Spreadsheet ?

Refer to the following article ...


DEALING WITH SPREADSHEET BLOAT

www.beyondtechnology.com/tips019.shtml

How Excel workbooks become bloated and what can be done about it.


Hope it Helps,

- Rodney POWELL
Microsoft MVP - Excel

Beyond Technology
Spring, Texas USA
www.BeyondTechnology.com




"Mars" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top