how to reduce Excel workbook size

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
 
R

Rodney POWELL

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
 
M

Mars

G

Guest

'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
message news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top