error Removed Part: /xl/printerSettings/printerSettings1.bin part. (Print options)

[Martin1979]

All,

I have a problem which many people seem to have. This basically destroys my spreadsheet and I can't find a solution to avoid the problem from occuring. I have tried to find a solution on Internet already, but unfortunately was not able to find one. Can someone help me with to solve this by providing the reason and what I should do or not do to prevent the error from occuring. The spreadsheet (Excel 2016) contains VBA/macros and therefore is saved as *.xlsm.

The error itself is "Removed Part: /xl/printerSettings/printerSettings1.bin part. (Print options)" which renders the sheet useless.

Your reply is greatly appreciated!

Regards,
Martin

 

[Fluff]

Have a look here
https://answers.microsoft.com/en-us...r/6262e340-105f-e011-8dfc-68b599b31bf5?auth=1

 

[Martin1979]

Have a look here
https://answers.microsoft.com/en-us...r/6262e340-105f-e011-8dfc-68b599b31bf5?auth=1

Thanks, I have read this topic already. But since I do not use pivot tables, I can't see the reason why this would cause the error in my workbook.

 

[Martin1979]

Does nobody have an answer to this question? I can't believe that there isn't a person on this forum who can provide more information about how to solve or avoid this problem.