We found a problem with some content in (file name.XLSM). Do you want to try to recover

[muzammilabbas]

Hello Professionals,
I have a task for you i have one excel file with vba code. when i try to open my file i face subject problem. Please let know how i can fix it?
here are some screen shorts may be those are helpful for you!
Thanks in advance

first image after opening file,
problem0.PNG

when i click "yes"
problem1.png

after clicking to view log file listing repairs:
problem2.PNG

[BanginMyHeadOnMyDesk]

Does the file work as expected after the 'recovery'?

Beth.

[muzammilabbas]

yes its work fine after recovery.

[BanginMyHeadOnMyDesk]

And if you save the file as a new copy, close it and open it again do you get the same message saying there's a problem with the content?

Beth.

[Richard Buttrey]

What do you mean by fix it. Excel is telling you that you can open the workbook, albeit with missing information - apparently hyperlinks. If Excel were able to recover the informtion it would have done so. Sometimes these things happen but why is rarely known.

Do you have a recent backup of the file? i.e. have you got the autorecover and autosave options set in the Excel app?

I doubt you can fix this in the way you - certainly I'm not aware of anything.

[muzammilabbas]

its appear repeatedly even after recovering file. whenever i made any changes and try to save the file and open it again. same error come
i will share project file. please check and let me know where is the problem.

[BanginMyHeadOnMyDesk]

I saved a copy of your attachment, opened it, let it repair, saved it again and got no error/warning message when opening it after that.

Beth.

[muzammilabbas]

Hello beth,

do some changes in "All Data (Draft) sheet" change some dates and than save the file.
and run macro before saving the file.

[BanginMyHeadOnMyDesk]

It still opens without issue for me.

Beth.

[muzammilabbas]

but im getting same error each time when i open file.
its strange...

[BanginMyHeadOnMyDesk]

Does this version work for you?

Beth.

[muzammilabbas]

Beth im getting same error after running macro, there is problem with macro code.
Do you have a solution for macro code?
I have description for each code on separate sheet and i want to show description as per unique code value.
each unique code has its own description and i want to show it when i go to unique code and description will popup as comments or note.
is it possible?