Excel file error

Question

I made a file using Excel 2010 using several check box.

after preparing file when I open it it shows me message that:

Excel Found unreadable content in pankaj.xlsx Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

When I click Yes it recover the file it shows me this message:

Removed Records: Object from /xl/printerSettings/printerSettings1.bin part (Print options)

And when I work further on this sheet it trigger me to save. After saving it trigger me again to save it with another file name.

Every time I work further Excel trigger me to save workbook with different name and if I save the workbook and if I again reopen it again same error message triggered .

Answer 1

Refer to the following Microsoft Article and check if this helps:

http://support.microsoft.com/kb/929766

Note: this article also applies to Excel 2010.

Answer 2

Here are the steps  I did to remove this message:

After opening a selected file and viewing the error message you click on SaveAs button than click on tools (bottom right with arrow on the right) and it will show you several options, when you see them click on Web options... then click on ENCODING tab and it will show you Save this document as...you have to choose UNICODE (UTF-8) and check Always save webpages in the default encoding. Click OK. Than Save and ofcourse, do not rename your original fie name but overwrite it with this one.

This procedure work fine for my files and I never saw error Rem **oved Records: Object from /xl/printerSettings/printerSettings1.bin part (Print options)**again !

I hope that I helped you resolve the problem.

Sorry for my English it is not my mother tounge. :)

I work all this in Excel 2010 :)

Answer 3

Here are the steps  I did to remove this message:

After opening a selected file and viewing the error message you click on SaveAs button than click on tools (bottom right with arrow on the right) and it will show you several options, when you see them click on Web options... then click on ENCODING tab and it will show you Save this document as...you have to choose UNICODE (UTF-8) and check Always save webpages in the default encoding. Click OK. Than Save and ofcourse, do not rename your original fie name but overwrite it with this one.

This procedure work fine for my files and I never saw error Rem **oved Records: Object from /xl/printerSettings/printerSettings1.bin part (Print options)**again !

I hope that I helped you resolve the problem.

Sorry for my English it is not my mother tounge. :)

I work all this in Excel 2010 :)

I tried this and it worked for most of my excel files (some files still with the same errors) but i still feel its a great way

Answer 4

Try to save the file xlsx into xls (compatibity mode)