Bloated Excel Workbook

[PoliSciGuy]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have an Excel Workbook that became extraordinarily bloated (file size) with a key stroke. I copied a word from a cell and mistakenly tried to do "insert> column" and it, of course, added another 60,000 rows (or so). But now I can't get rid of the rows. When I follow the directions people often give to delete the rows, I get a "Note Enough Memory" error. Is there a way to fix this? The workbook is just unusable as is because it runs far too slow.

 

[CyberTaz]

Well, if you inserted a *column* in a 2008 worksheet it actually amounts to
1,048,576 cells - a little more than "60,000 or so" But that in itself
is most likely not the cause of the error, nor should it bloat the file.
Inserting columns & rows merely "wraps" the peripheral part of the sheet
into the area where the insertion is being done - IOW, it doesn't *add* any
cells to the sheet or change the number of columns or rows.

Unfortunately, I don't understand your description. If you inserted a
*column* - accidentally or intentionally - why are you trying to delete
*rows* rather than simply Undo-ing the insertion or deleting the one column?

Before offering any suggestions which might cause more harm than help I
think it would be a good idea for you to provide an accurate, far more
detailed description of what your file contains, specifically what you did &
how you did it as well as exactly how you're going about attempting the
deletion - step-by-step.

Regards |:>)
Bob Jones
[MVP] Office:Mac