file size magically goes down after copy and pasting to new sheet

[daveyc18]

original sheet copied and pasted to a new sheet I just created...i deleted the old, original sheet and magically rhe file size reduce by 2 MB. it's not due to formatting cause the original sheet dint have any formatting (i did a select all, clear formats just in case)....

just trying to know why this might have happened??

 

[daveyc18]

Why is difficult to answer as there are a number of possibilities.
To remove them select the rows & right click> delete > save

cause i cleared the rows (and yes Ive tried the delete method) to no avail and was hoping for someone who might have a similar experience to provide a specific reason.

anyway, the workaround works (ie copy and paste just the data to a new sheet and delete the original) so no biggie.

the oddities of excel.

 

[Fluff]

The delete method isn't working for me either.
But that said a lot of the normal reasons are coming up nothing, so not sure.

 

[daveyc18]

The delete method isn't working for me either.
But that said a lot of the normal reasons are coming up nothing, so not sure.

Lol ya I just accepted the fact that excel is funky sometimes !

 

[JoeMo]

After the delete open the VBE and press ctrl + g to open the Immediate Window. There enter (w/o the quotes): "?Activesheet.usedrange.address" then press Enter. Make a note of the range that's returned. Now in the Immediate Window enter: "Activesheet.Usedrange" and press enter again. Sometimes this will reset the used range, hopefully to not include the deleted rows anymore. Repeat "?Activesheet.usedrange.address" to see if that's happened.

 

[daveyc18]

After the delete open the VBE and press ctrl + g to open the Immediate Window. There enter (w/o the quotes): "?Activesheet.usedrange.address" then press Enter. Make a note of the range that's returned. Now in the Immediate Window enter: "Activesheet.Usedrange" and press enter again. Sometimes this will reset the used range, hopefully to not include the deleted rows anymore. Repeat "?Activesheet.usedrange.address" to see if that's happened.

good point about using VBA...returned $A:$AE, but after typing "activesheet.usedrange" ....it still returned $A:$AE....messed up

there are no named ranges in the worksheet either

 

[Fluff]

No objects, data validation, named ranges, formulas. Or anything else that I can find.

 

[daveyc18]

No big deal guys ...thanks for all the help

A minute issue that was bugging me ...at least I found a workaround