So my wife's working on a spreadsheet in excel 2007 that her department at work totally worked over.
Someone selected all cells and formatted background and borders. All millions of cells. File is now 35mb and only has 900 rows of text.
On top of that it was a shared workbook so that's right, change tracking enabled.
I pulled the formatting off and turned off sharing but trying to delete even one of the empty rows gives out of memory errors. Copying any data, a row or even a cell fails with out of memory errors.
My only thought at this point is possibly downloading the trial of 64 bit excel and hope the extra memory room will let me delete the rows.
Any thoughts?