Fix Excel Repairs to File Errors Caused by Printer Settings in WPS Spreadsheets
Question details
The user needs to understand and resolve an Excel repair message that reports a removed printerSettings part from an XLSM workbook.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user opened an .xlsm workbook and received a repair log about a removed printerSettings part. They need to stop the repair prompt and prevent further file corruption.
- Observed behavior
- Excel reports that it repaired or removed a printer settings object, but worksheet data and formulas may remain unaffected.
Before editing, make a copy of the XLSM workbook and identify sheets that use custom print areas, page breaks, headers, footers, or specific printer selections. Make sure the file is not open in another Office application.
Clear and recreate print areas and page setup in WPS Spreadsheets
Use this first when the repair log mentions printerSettings. It removes the damaged print configuration and rebuilds it cleanly.
The printerSettings part stores page setup, print areas, margins, headers, footers, and printer selections. Corruption here usually does not affect cell data, so clearing and recreating these settings often stops the repair prompt.
Open WPS Office Spreadsheets, click Menu > Open, select the .xlsm file, and continue past any repair prompt if one appears.
Select the affected sheet, go to the Page Layout tab, click Print Area > Clear Print Area. If a print area is needed, select the desired cells, then click Print Area > Set Print Area.
Click Page Layout > Print Titles or Page Setup, then check Orientation, Scaling, Margins, Header/Footer, and Sheet settings. Remove invalid paper sizes or printer-specific settings.
Click Menu > Save As, choose the .xlsm format, and save the workbook with a new file name to create a clean copy.

Locate the damaged sheet by testing print settings sheet by sheet
Use this method when the repair message persists and you need to isolate the sheet that contains the corrupted printer settings.
Check for hidden objects and VBA-related corruption in the workbook
Use this when clearing print settings does not resolve the repair message and you suspect damaged objects or macro code.
Repair XLSM printer settings errors with WPS Spreadsheets
Open the damaged macro-enabled workbook in WPS Spreadsheets, clear the corrupted print areas and page setup, and save a clean .xlsm copy that Excel can open without the printerSettings repair message.
- 1. Download and install WPS Office: Get WPS Office from the official WPS website, install it, and open WPS Spreadsheets.
- 2. Open the affected .xlsm workbook: Click Menu > Open, choose the workbook, and continue past any repair prompt.
- 3. Clear the damaged print configuration: Go to the Page Layout tab, select Print Area > Clear Print Area, then open Page Setup and reset paper size, scaling, margins, header/footer, and print titles.
- 4. Recreate print settings and save as new: Set the correct print area if necessary, then click Menu > Save As, choose .xlsm format, and save under a new name.
- 5. Test the new file in Excel: Open the saved copy in Microsoft Excel and confirm that the repair message no longer appears.

Frequently Asked Questions
Does the removed printerSettings part message mean my data or formulas were removed?
No. The repair log refers to a printer settings object such as print areas, page setup, printer selections, or paper size. Cell values and formulas are usually not affected, but work on a backup copy before saving.
Can WPS Spreadsheets open and repair a macro-enabled .xlsm workbook with this error?
Yes. Open the workbook in WPS Spreadsheets, clear the print area from the Page Layout tab, reset Page Setup options, and save the file as a new .xlsm copy.
Why does Excel keep showing the repair message after I save the file?
The corrupted printerSettings part may still be present because the print setup was not fully cleared. Clear print areas, print titles, paper size, and printer-specific settings on all sheets, then save under a new file name.
Should I edit the XLSM file XML to remove the printerSettings part manually?
Manual XML editing is riskier and can damage the workbook. Use WPS Spreadsheets or Excel to clear and recreate page setup, which rewrites the settings cleanly.
What can I do if clearing print settings does not stop the repair error?
Check the workbook for hidden objects and VBA corruption. Use Find & Select > Go To Special > Objects to locate shapes, and review macros in the VBA editor. Test with a copy after removing confidential data.




