Table Formula Error

[MHau5]

When I open my file it tells me there were some issues with some of the content in my file. I've found what I believe is the source of the issue but can't seem to figure out how to fix it.

Unfortunately when I try to run XL2BB to take a mini shot of it the file crashes so I can't post one.

Here is a screenshot of the error message once the file opens...

Any thoughts on how to fix this?

 

[MHau5]

When I open my file it tells me there were some issues with some of the content in my file. I've found what I believe is the source of the issue but can't seem to figure out how to fix it.

Unfortunately when I try to run XL2BB to take a mini shot of it the file crashes so I can't post one.

Here is a screenshot of the error message once the file opens...

View attachment 53132

Any thoughts on how to fix this?

I will also add that the table numbers up at the top there don't exist anywhere in the worksheet, or at least none of the tables in the worksheet so far have that table number. Unless they are referring to a table number regardless of what it's updated name may be...

 

[Alex Blakenburg]

I am not sure you will be able to recover the data lost but can you have a look at the link below to see if it gives you any ideas ?
List/Identify all queryTable numbers and their table names in a workbook (After the tables have already been renamed)