There are instances that we might encounter some errors in our EXCEL files like "EXCEL found unreadable content in ... " and said "Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes". And when you click Yes it will display an error: "Removed Records: Object From /xl/printersettings/printersettings9.bin Part (print Options)"
Solution: 1) Download 7-Zip application that suit to your operating system (32/64-bit) at 7-Zip 2) Once you download it, right-click the excel file under 7-Zip and click open archive 3) Select the folder that says xl then open the PrinterSettings folder delete all PrinterSettings .bin files and close the 7-Zip; 4) Next, double-click the excel file, in my case it was .xlsm file and again it will displayed some error. 5) At this point, you will fully open the excel file and Save As in an Excel Binary Workbook. 6) Open your binary excel workbook and you will no longer see any error popping up.
3 Comments
9/4/2018 10:28:15
Open your binary excel workbook and you will no longer see any error popping up.
Reply
dananjaya
4/2/2019 23:34:48
thank you very much it worked
Reply
6/11/2020 16:01:24
I’m happy I located this blog! From time to time, students want to cognitive the keys of productive literary essays composing. Your first-class knowledge about this good post can become a proper basis for such people
Reply
Leave a Reply. |