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

David77

Board Regular
Joined
Jun 24, 2020
Messages
93
Office Version
  1. 365
Platform
  1. Windows
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!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

David77

Board Regular
Joined
Jun 24, 2020
Messages
93
Office Version
  1. 365
Platform
  1. Windows
Update:

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

1597145228918.png
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,576
Try changing this :

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

to this:

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,335
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Jun 24, 2020
Messages
93
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Aug 31, 2016
Messages
3,576
.
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,006
Messages
5,526,243
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top