Deleting rows to resize workspace
 

Hi. I'm using a workbook that someone else created from a download. It has
23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it
appear that it's only 10% from the top.
In the past I've deleted all of the rows - going down to the full million -
and then gone back to A1 and hit "save". Usually that refreshes the space.
It's not working. I can delete them. And go to A1 and save - even tried
resaving with another name.. but it (Excel) still thinks it's bigger than it
is. Any ideas?

Deleting rows to resize workspace
 

Usually that technique works.

Debra Dalgleish documents it he
http://contextures.com/xlfaqApp.html#Unused

But I've seen times where it doesn't work.

If it really bothers me, I'll create a new worksheet and copy|paste just the
data/formulas/headers/names/formatting (all that stuff) to a new sheet.

Then I'll check it by hitting ctrl-end (to get to what excel thinks is the last
used cell). Then I delete the original sheet.

Be careful if you have formulas that point to that sheet to be deleted. You may
have more work to do first!

beata wrote:

Hi. I'm using a workbook that someone else created from a download. It has
23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it
appear that it's only 10% from the top.
In the past I've deleted all of the rows - going down to the full million -
and then gone back to A1 and hit "save". Usually that refreshes the space.
It's not working. I can delete them. And go to A1 and save - even tried
resaving with another name.. but it (Excel) still thinks it's bigger than it
is. Any ideas?

--

Dave Peterson