View Single Post
  #4   Report Post  
b&s
 
Posts: n/a
Default

I think You must have hidden objects. Try this: F5/Special.../Objects/OK
than press Delete ...

--
pozdrav!/regards!
Berislav

Oglu wrote:
Thanks for the link but I tried again deleting all the arrows and
columns after page one and nothing happened.
If i were to print what's on the screen, only ONE BLANK sheet of
paper will come out of the printer.
I really mean that there is NOTHING on the screen (no pictures, no
objets, no comments, no visble data) to print. And page one is the
only one active and the only one that would be printed (blank) if i
wanted to do so. Still, the file is a 1MB file.
If there's a chance to upload the file somewhere (or send it) so i
can make myself clear please tell me so.

"Dave Peterson" wrote:

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