Fix Excel Footer Changes That Revert After Saving a Workbook
Question details
The user needs to keep edited footer text in an Excel workbook after saving, closing, and reopening the file.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A footer is edited successfully in the workbook, then the workbook is saved and reopened.
- Observed behavior
- The footer returns to its previous text after the workbook is reopened.
Open the workbook from a local folder if possible, and confirm that you are editing the correct worksheet and footer section. Make a note of the original footer text so you can identify whether a macro, template, or saved version is restoring it.
Check workbook protection, shared workbook settings, and save permissions
Use this first when Excel appears to accept the footer edit but does not retain it after the file is saved.
Workbook or worksheet protection, legacy shared-workbook restrictions, and insufficient write permission can prevent footer changes from being saved permanently.
In Excel, open the Review tab. Select Unprotect Sheet or Protect Sheet to check worksheet protection, and select Protect Workbook to review workbook structure protection. Enter the password if one is required and you are authorized to remove protection.
On the Review tab, look for Share Workbook or the legacy sharing options. If the workbook is shared, ask the owner to stop sharing it or provide an editable copy, then edit the footer again through Insert > Header & Footer.
Select File > Save As, choose a local folder such as Documents, enter a new workbook name, and save the file. Close Excel, reopen the new copy, and check the footer.
In File Explorer, right-click the workbook, select Properties, and clear Read-only if it is selected. Also verify that your account has Modify permission for the folder where the workbook is stored.

Test for macros, templates, add-ins, and file corruption
Use this when the footer still resets in a local, editable copy of the workbook.
Remove template-based footer settings and rebuild the affected worksheet
Use this when the workbook opens with a standard footer that repeatedly returns, especially for files created from a company template.
Edit and Save Workbook Footers Reliably with WPS Spreadsheet
If Microsoft Excel continues to restore an old footer, try WPS Office as a free, lightweight alternative. WPS Spreadsheet provides familiar page setup controls for editing workbook headers and footers, with a familiar interface and straightforward migration for existing Excel files.
- 1. Open the Excel workbook in WPS Spreadsheet: Launch WPS Office, select Spreadsheet, then choose Open and select the affected .xlsx or .xls workbook.
- 2. Open page setup options: Select Page Layout on the ribbon, then use the Page Setup dialog launcher to access worksheet printing and layout settings.
- 3. Edit the footer text: In the Header/Footer tab, choose Custom Footer and enter the required text in the left, center, or right footer section.
- 4. Save an Excel-compatible copy: Select Menu > Save As, choose Excel Workbook (*.xlsx), select a local folder, and save the edited workbook under a new name.

Frequently Asked Questions
Why does my Excel footer look correct until I reopen the workbook?
The file may not be saving your changes because of worksheet or workbook protection, restricted folder permissions, cloud-sync conflicts, sharing restrictions, or code that resets the PageSetup footer when the workbook opens.
Where can I edit a footer in Excel?
Open the worksheet, select Insert > Header & Footer, then click the footer area and enter the text. You can also select Page Layout > Page Setup dialog launcher > Header/Footer > Custom Footer.
Can workbook protection prevent footer changes from being saved?
Yes. Check Review > Unprotect Sheet and Review > Protect Workbook. If protection is enabled, you need the authorized password or an unprotected copy before making persistent page setup changes.
How do I find out whether an Excel macro is resetting my footer?
Press Alt+F11 and inspect ThisWorkbook and worksheet modules for Workbook_Open, Auto_Open, or PageSetup code. You can also open Excel with excel /safe; if the issue stops, an add-in or startup item may be responsible.
Will saving the workbook as XLSX help with a footer that will not persist?
It can help if the original workbook is in an older, restricted, or damaged format. Use File > Save As to create an .xlsx copy in a local folder, then edit and test the footer in that copy.




