Huge Empty Spreadsheet

[Guest]

Excel 2002

I have a rogue cell which if copied into any new or blank spreadsheet makes
it huge in size - once the cell is in a spreadsheet deleting it, changing it
or formatting it doesn't help. Anyone want to solve this puzzle?? I can't
find any reference to a known bug in Excel.

Email me at (e-mail address removed) and I'll send you a file with the cell in
it....

 

[Ron de Bruin]

If you use the shortcut Ctrl h you jump to the cell in the sheet that excel think it is the last
See
http://www.contextures.com/xlfaqApp.html#Unused

 

[Ron de Bruin]

Oops, not ctrl h

Ctrl End

 

[Guest]

Yep - Cell A1 - sheet is empty (as far as I'm concerned) - still 448k in
size????

 

[Gord Dibben]

Send it to me.

Change the DOT and AT to appropriate punctuation to get my email address.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Maybe you have objects on the sheet

F5
Special
Check Objects
OK
Delete

Save the file

 

[Harlan Grove]

Maybe you have objects on the sheet

....

OP had send me a copy of the file as a follow-up to a response I had made in
an earlier thread on this same topic. I hadn't had a chance to look at it
until now. You're spot on - it contains 17571 picture objects, most of them
linked to one cell. When the OP copies the cell and pastes (i.e., not Paste
Special), all the wonderful pictures are pasted along with the cell.

 

[Guest]

Thanks - that did it - they looked like three little round circles on the
left of the sheet - no idea what they were or how they got there!!

 

[Ron de Bruin]

Thanks Harlan

 

[Ron de Bruin]

Thanks for the feedback