Excel file size too big although few rows

[wenxi]

My Excel file turns out to be too big although there are only few rows and there is of no formula in it. By deleting unwanted rows and columns will strink down.
However anyway to prevent it from happening?

 

[SMB Cooper]

Hidden and Invisible Objects
By Diego Oppenheimer, 30 Jan 2009

When gathering data in Excel it is common to start with information found in a variety of sources, frequently lists or tables located on the Internet. Customers often copy and paste this data into Excel from the original source, but unfortunately this can also unintentionally paste many additional objects into the spreadsheet besides the data. These objects (shapes, text boxes, controls, etc.) are often not noticeable to the user after the paste, but can result in slower performance and larger file sizes. One step customers can take to avoid unwanted, hidden, and invisible objects in their document is to find and remove the objects after the paste operation as part of their data cleansing process.

Complete article here:
http://blogs.office.com/b/microsoft-excel/archive/2009/01/30/hidden-and-invisible-objects.aspx

 

[wenxi]

Hidden and Invisible Objects
By Diego Oppenheimer, 30 Jan 2009

When gathering data in Excel it is common to start with information found in a variety of sources, frequently lists or tables located on the Internet. Customers often copy and paste this data into Excel from the original source, but unfortunately this can also unintentionally paste many additional objects into the spreadsheet besides the data. These objects (shapes, text boxes, controls, etc.) are often not noticeable to the user after the paste, but can result in slower performance and larger file sizes. One step customers can take to avoid unwanted, hidden, and invisible objects in their document is to find and remove the objects after the paste operation as part of their data cleansing process.

Complete article here:
http://blogs.office.com/b/microsoft-excel/archive/2009/01/30/hidden-and-invisible-objects.aspx

Thanks for your feedback.
I tried to open up the hidden and invisible objects in my excel file but there wasnt anything in it.

 

[wenxi]

Thanks for your feedback.
I tried to open up the hidden and invisible objects in my excel file but there wasnt anything in it.

Hi hi can anyone help.