Excel freezes up and gives me the "Excel.exe has a serious problem and Windows shut it down. Creating error log. OK?" Not OK. 
this happens when I do a Ctrl [ -- (jump to precedent cell). Curiously it only happens when it is both a range, and on different worksheet, not on a single cell reference or to the same worksheet. IT guys tried to fix, but couldn't.
The speadsheet is a hodge-podge of past efforts, but its too time sensitive to rebuild from scratch. heard that before? It has a collection of stale range names, unused Styles, and plus some artifacts from ancient times that I can't find or get rid of. My first thought was to clean these up to prevent the corruption problems, and hang-ups (see below).
Here's what I've all tried and the results
1. Copy / Pasting individual sheets to new book - same crash problems and still had funky range names / styles.
2. Remove funky range names/styles - still had crashing problem, got rid of most items.
3. Run "delete external names" macro from Microsoft site (presumed reliable, and has worked in past) - it found some artifacts I didn't know existed, and it couldn't remove them. The names were something about "___123Chart9". It bombed when it attempted to delete them, and it triggered the VB debugger
Can anyone help me? Suggest something?
Thanks in advance for the help.
Darrell
this happens when I do a Ctrl [ -- (jump to precedent cell). Curiously it only happens when it is both a range, and on different worksheet, not on a single cell reference or to the same worksheet. IT guys tried to fix, but couldn't.
The speadsheet is a hodge-podge of past efforts, but its too time sensitive to rebuild from scratch. heard that before? It has a collection of stale range names, unused Styles, and plus some artifacts from ancient times that I can't find or get rid of. My first thought was to clean these up to prevent the corruption problems, and hang-ups (see below).
Here's what I've all tried and the results
1. Copy / Pasting individual sheets to new book - same crash problems and still had funky range names / styles.
2. Remove funky range names/styles - still had crashing problem, got rid of most items.
3. Run "delete external names" macro from Microsoft site (presumed reliable, and has worked in past) - it found some artifacts I didn't know existed, and it couldn't remove them. The names were something about "___123Chart9". It bombed when it attempted to delete them, and it triggered the VB debugger
Can anyone help me? Suggest something?
Thanks in advance for the help.
Darrell
