How do I troubleshoot one worksheet in a workbook that crashes Exc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large workbook with many sheets. Each month I copy the whole
workbook to another workbook. About 4 months ago, the application began
crashing when I tried to copy the workbook. Troubleshooting, copying one
worksheet at a time, I finally found one worksheet that will not copy. When
on the tab, select copy to new workbook and immediately the following error
occurs: EXCEL.EXE - Application Error: The instruction at "0x304bb4e6"
referenced memory at "0x00000014". The memory could not be "read". Click on
OK to terminate the program. Click on CANCEL to debug the program. When I
select the debug route and go the the Event log, I don't understand what I am
supposed to be seeing or do to correct the problem. Searching high and lo on
the internet has not offered any specific solutions. Please help.
 
gabby_hayes wrote...
I have a large workbook with many sheets. Each month I copy the whole
workbook to another workbook. About 4 months ago, the application began
crashing when I tried to copy the workbook. Troubleshooting, copying one
worksheet at a time, I finally found one worksheet that will not copy.
When
on the tab, select copy to new workbook and immediately the following
error
occurs: EXCEL.EXE - Application Error: The instruction at "0x304bb4e6"
referenced memory at "0x00000014". The memory could not be "read". Click
on
OK to terminate the program. Click on CANCEL to debug the program. When
I
select the debug route and go the the Event log, I don't understand what I
am
supposed to be seeing or do to correct the problem. Searching high and lo
on
the internet has not offered any specific solutions. Please help.
Click to expand...

Hi,

You likely have a corrupted workbook.

You can try this set of steps.

1. Open the file
2. Save-as filetype Webpage
3. Close the file
4. Open the html file
5. Save-as normal Excel workbook.

Try to copy the old worksheet and then go to the new worksheet Edit |
PasteSpecial | Formulas.

If you want to open a new workbook and have the new workbook copy the
contents (formulas) and formatting of the old workbook, you can look at this
vba code here: http://tinyurl.com/6w3rx

If you do use it, be careful with the line wrap in the newsgroup posting.
There are a couple lines, I believe, that have incorrectly wrapped. Or if
you have difficulty, let me know and I can e-mail the workbook.

Hope this helps.

Kevin
 
Back
Top