We found a problem with some content in "File name". Excel annoying message

[David77]

Hello everybody,

Whenever I open my excel sheet I get the following message:

"We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes"

It is super annoying. It started happening after I had my VBA coding open in another test sheet next to my main one (I still don't understand why you cant split VBA codes so it's only open in one excel file at a time.

Whenever I open my excel file this annoying message comes up. If I click yes it says the following:

"Excel was able to open the file by repairing or removing the unreadable content: Removed Records: Object from /xl/worksheets/sheet3.xml part"

My file functions completely fine, I don't see any problems with it.

But I would love to get this message removed (because other people have to use this file too), so they won't encounter this annoying message every time they try to open it.

Can somebody help me with this please? I would truly appreciate it! Please let me know if you want me to share some screenshots, my codes or anything else.

P.S. I think the "Sheet3" that is referenced is from the test file I made in Excel, which is not even a part of my main file!

 

[David77]

Update:

This is my actual sheet 3 (but I have named it "Order Form"):

 

[Logit]

Try changing this :

strPath = ActiveWorkbook.Path & Application.PathSeparator & "Order Form.pdf"

to this:

strPath = ActiveWorkbook.Path &"\" & "Order Form" & ".pdf"

 

[Fluff]

Pretty sure that sheet3.xml refers to the 3rd sheet in the workbook (counting from left to right & including hidden sheets), not the sheet with codename of sheet3.

 

[David77]

Try changing this :

strPath = ActiveWorkbook.Path & Application.PathSeparator & "Order Form.pdf"

to this:

strPath = ActiveWorkbook.Path &"\" & "Order Form" & ".pdf"

Hello Logit,

Thank you very much! Unfortunately, it did not work

I solved the issue however, by simply just taking every single cell and code and copying it onto another sheet. It was super annoying and took a long time, but it worked and my excel is not bugging now.

Goes to show that the program itself had an error, and not my worksheets. Super weird and annoying, but friendly reminder to everybody out there to always keep a backup

 

[Logit]

.
Maintaining an original backup is paramount. My experience has always been ... sooner or later Excel will corrupt itself for no good reason.
Apparently something in your workbook did that. And YES, having to manually re-create something is a total bore.