Huge Empty Spreadsheet
 

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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

Oops, not ctrl h

Ctrl End

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

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

"Ron de Bruin" wrote:

Oops, not ctrl h

Ctrl End

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

Send it to me.

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


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 13:08:01 -0700, fp944s2
wrote:

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

"Ron de Bruin" wrote:

Oops, not ctrl h

Ctrl End

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

Maybe you have objects on the sheet

F5
Special
Check Objects
OK
Delete

Save the file

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

"Ron de Bruin" wrote:

Oops, not ctrl h

Ctrl End

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

"Ron de Bruin" wrote...
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.

Huge Empty Spreadsheet
 

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" wrote:

Maybe you have objects on the sheet

F5
Special
Check Objects
OK
Delete

Save the file

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

"Ron de Bruin" wrote:

Oops, not ctrl h

Ctrl End

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....

Huge Empty Spreadsheet
 

Thanks Harlan

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Harlan Grove" wrote in message ...
"Ron de Bruin" wrote...
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.

Huge Empty Spreadsheet
 

Thanks for the feedback

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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" wrote:

Maybe you have objects on the sheet

F5
Special
Check Objects
OK
Delete

Save the file

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

"Ron de Bruin" wrote:

Oops, not ctrl h

Ctrl End

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fp944s2" wrote in message ...
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 and I'll send you a file with the cell in
it....