Hey everyone,

I am attempting to open a workbook (Workbook A) that is linked to a source workbook (Workbook B) with extension .xlsm. Workbook A is new and this is a new link.

There are two other workbooks (Workbook C and Workbook D) acting as sources to Workbook A. Both of those sources behave appropriately and their data is retrieved properly.

However, there appears to be an issue with Workbook B and it's formatting. When attempting to open Workbook A, I receive the following error:

"We found a problem with some content in 'Workbook A.xlsx'. Do you want to try and recover as much as we can? If you trust the source of this workbook, click Yes."

If you click "No", then it does not open the document. If you click "Yes", then you get the following message:

"Removed Records: Formula from /xl/worksheets/sheet4.xml part"; and
"Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)"

When you click "Close" to this second dialogue, I find that Excel has removed the formula associated to Workbook B, but has left the formulas in tact for Workbooks C & D.

I did some exploring online and found a possible problem being Data Validation containing more than 255 characters. I then proceeded to remove all Data Validation from Workbook B (the only workbook with Data Validation), and this did nothing.

Some more differences for Workbook B include:
  • Extension is .xlsm (contains macros)
  • Contains a UserForm which launches automatically when the workbook is opened

At this point, I have no clue what the issue could be. I doubt that it is a matter of a corrupt database in Workbook B, because it is 100% functional in every other aspect: Macros run, formulas are successful, etc.

Can anyone give me any other tidbits of advice/ avenues to explore?

Thanks!