Returning Excel Cells to Default Settings 1

[rafot]

Is there anyway to return Excel cells to the default blank state?

I have a spreadsheet which has been given to me and should only be a few KB in size, however it totals several MB. All rows from 5000 onwards appear to have contained values within them at some point but are now empty, yet Excel still treats them as if they have values of some description. I think this is resulting in the large file size.

Many thanks for any assistance,

Richard

 

[Molby]

Copy any cells with data in them to another sheet. Delete the old sheet and save, the file should be a lot smaller.

 

[koresnordic]

Or highlight the blank lines, right click and select delete, then you MUST save the sheet. After the save the blank lines at the bottom will have gone.



Graham

 

[MJPPaba]

Does the Sheet have any VB code?
if so,
1 open the module,
2 copy all the text into notepad or other word processor,
3 note the name of the module,
4 remove without saving the copied module,
5 create a new blank module
6 copy the vba from the wordprocessor into the new blank module.
7 rename the module with the original name

What this does is it strips out all unnecessary VBA code not visable when programming. The VBA still works perfectly and should reduce the file size.

Cheers

Matthew

Who remembers the Natwest Piggies?

 

[rafot]

Thanks for the really prompt replies! The problem is now sorted out.

Many thanks,

Richard