Got a LARGE spreadsheet from a client. Main sheet has a used range of about A1:HQ69000, although the actual data only goes through column BJ. I need to delete some of the columns.
Sheet is NOT filtered. Columns I'm trying to delete are either empty, or contain fixed values that have no dependents.
If I try to delete even one single column, Excel goes into "Not Responding" immediately, and just hourglasses me forever (like 20+ minutes, until I give up and press -Esc-, at which point I get the "whiteout" effect and have to go to Task Manager to end Excel).
Is there any way around this?
I'm running Excel 2007 on a Windows 8 desktop with a Core i5 CPU.