roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,062
- Office Version
- 365
- Platform
- Windows
- MacOS
I have a workbook that is normally about 3000KB in size. This weekend I was tinkering with it and it suddenly became 20,000KB is size (these are Windows explorer compressed sizes...One can only guess how much memory it's filling up). Pretty sure what sheet got corrupted because when on that sheet even simple arrow commands to move the selection takes dozens of seconds to react. Of course, that's the sheet to which I reference a ton of formulas and named ranges. To fix it, I copied the column headers to a new sheet, deleted every row on the sheet, then copied the headers back (the headers were the most critical part...the code filled in the data below it). That fixed the size problem, but destroyed all my formulas and named ranges (inserting ref! where the sheet was referenced). I lost hours repairing everything.
Happened again today...I'm at a loss as to what caused it and if there's an easier way to fix it
Other than the questions I alluded to above (1) how do I prevent this from happening in the future and (2) fastest way to fix it...
...Can I export my named ranges such that I can simply cut/paste them back in once I blast away the worksheet contnents?
Thanks!
Happened again today...I'm at a loss as to what caused it and if there's an easier way to fix it
Other than the questions I alluded to above (1) how do I prevent this from happening in the future and (2) fastest way to fix it...
...Can I export my named ranges such that I can simply cut/paste them back in once I blast away the worksheet contnents?
Thanks!