If you hit ctrl-end (on each worksheet), do you go way past where you know the
data ends?

If yes...

Visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

And if you have pictures/objects/comments embedded on those worksheets, they
could be
causing trouble.


Oglu wrote:

I have an excel file with several Sheets that was causing me troubles when
emailing it because it was too big.
I separated each an every Sheet of it into different files to identifiy the
biggest one. So i did, and after getting rid of colors, fancy fonts, lines,
etc., the size was about the same. So, i started deleting the data of that
sheet to find out what was the main problem. But i found out that even when i
deleted the whole information and there was nothing on the screen the archive
was still a ONE Megabyte file.
What causes this? What does the file has that i cant see anything on the
screen but there is still a lot of data recorded?

--

Dave Peterson