Need a Corrupt Workbook Fix

gravanoc

Board Regular
Joined
Oct 20, 2015
Messages
213
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: 1

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,148,147
Messages
5,745,055
Members
423,917
Latest member
Frank1931

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
Top