question

SumitBhargava-2898 avatar image
0 Votes"
SumitBhargava-2898 asked emilyhua-msft commented

Remove Part: /xl/printerSettings/printerSettings30.bin part (print options)

I am getting this error in Excel Office 365: -

Excel was able to open the file by repairing or removing the unreadable content
Remove Part: /xl/printerSettings/printerSettings30.bin part (print options)

The sheet is based on HFM formulas and Macros. Any help greatly appreciated.

Thanks

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

@SumitBhargava-2898

Does this issue occur with a new blank Excel file?
I would suggest you backup these problematic Excel files first. Then follow the suggestions below to have a check.

  • After double-click one problematic Excel workbook, please check whether you coul click Home > Save As.
    If yes, please continue to click "More Options" on left > Tools (Besides an arrow on the right) > Web options > Encoding tab, choose "UNICODE (UTF-8)" for "Save this document as" > OK > Save > Check this issue again.
    You may also save files as .xlsx for a test.

  • Open Excel application, go to Print check the default printer. Please change it to be a virtual printer, such as "Microsoft Print to PDF".

  • As you said there are some Macro on the Excel file, is there any code that add cell validation (drop down list) to specific cells. If the string of text for the validation list source was over 256 characters (including the comma separators) then may cause such error message.
    For more please refer to the last reply in "Excel corruption "Excel found unreadable content...", Removed Feature: View from /xl/worksheets/sheet1.xml part". In this similar thread, there are some sharing related to freeze panes and hide rows, you may also have a look.

    If the link above does not work, it's recommended to do following to try to find the something helpful.
    a. Make a .xlsm copy of your file that contains no Macro code modules.
    c. Introduce Macro Modules in turn and run the code. Save the file and close Excel.
    d. Open the file, and if there is no corruption, this is a new file replaces previous one.
    e. Repeat until the problem is found.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SumitBhargava-2898
Please check whether my information was helpful. If you have any question, you may post back.

0 Votes 0 ·