| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What produces empty rows at the bottom of a spreadsheet? | Excel Discussion (Misc queries) | |||
| deleting rows in a huge spreadsheet with subtotals | Excel Discussion (Misc queries) | |||
| Removing empty cells from spreadsheet data | Excel Discussion (Misc queries) | |||
| if you've accidentally saved a huge spreadsheet as a web doc... | Excel Discussion (Misc queries) | |||
| huge huge excel file... why? | Excel Discussion (Misc queries) | |||
Linear Mode
