Need a Corrupt Workbook Fix

gravanoc

Active Member
Joined
Oct 20, 2015
Messages
346
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
A workbook of mine is producing the error "We found a problem with some content in 'Comparison Tool.xlsm'. Do you want us to try to recover as much as we can? Etc"

I tried out many of the solutions at this link: We Found Some Problems Error

Nothing has worked. It does succeed at repairing the workbook, so I can access my code. I'm probably just going to have to import the code into a new workbook or a lower version of the workbook, but that is not optimal.

The thing that struck me as odd was when I looked at my VBA Project tree, it had duplicates of the worksheets and the workbook. Maybe someone else has seen this happen before and can offer some advice. Thanks.


1585784770243.png
 

Attachments

  • 1585784781405.png
    1585784781405.png
    4.3 KB · Views: 2

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,214,847
Messages
6,121,911
Members
449,054
Latest member
luca142

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top