File Corruption & Recovery

Fix Excel Repairs to File Errors Caused by Printer Settings in WPS Spreadsheets

Amos GikundaAmos Gikunda Nov 13, 2026 869 views

Question details

The user needs to understand and resolve an Excel repair message that reports a removed printerSettings part from an XLSM workbook.

Fix Excel Repairs to File Errors Caused by Printer Settings in WPS Spreadsheets
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 you start

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.

Solution 1Recommended

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.

1
Open the affected workbook in WPS Spreadsheets

Open WPS Office Spreadsheets, click Menu > Open, select the .xlsm file, and continue past any repair prompt if one appears.

2
Check each sheet's print area

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.

3
Reset page setup settings

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.

4
Save under a new file name

Click Menu > Save As, choose the .xlsm format, and save the workbook with a new file name to create a clean copy.

Clear and recreate print areas and page setup in WPS Spreadsheets
Repair message cleared: Saving under a new file name after resetting page setup normally prevents Excel from reporting the printerSettings part again.

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. 1. Download and install WPS Office: Get WPS Office from the official WPS website, install it, and open WPS Spreadsheets.
  2. 2. Open the affected .xlsm workbook: Click Menu > Open, choose the workbook, and continue past any repair prompt.
  3. 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. 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. 5. Test the new file in Excel: Open the saved copy in Microsoft Excel and confirm that the repair message no longer appears.
Removes corrupted printerSettings data while preserving worksheet valuesSupports .xlsm macro-enabled workbook formatProvides familiar spreadsheet tools with clear print area and page setup controlsFree, lightweight, and compatible with Microsoft Excel files
microsoft office alternative - wps office

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.