Fix Excel Shared Workbook Row Height and Column Width Changes Not Saving
Question details
The user needs row height and column width changes to remain in a shared Excel workbook when other users save it.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users edit a protected legacy shared workbook stored on a business server.
- Observed behavior
- One user's row height or column width changes can be lost when another user saves. A macro that recalculates row heights works but makes saving slow.
Check whether the workbook uses Excel's legacy Shared Workbook feature and whether your organization provides OneDrive for Business or SharePoint. Ask an authorized owner to check the workbook's protection settings before changing the sharing method.
Test modern Excel co-authoring with a copy of the workbook
Use a test copy on OneDrive for Business or SharePoint to find out whether legacy sharing is causing the formatting changes to be lost.
Legacy shared workbooks may not reliably merge row height and column width changes. Modern co-authoring provides a different sharing method, but the test should include the workbook's protection and macro requirements.
In Excel, use File > Save As to create a separate copy of the workbook. If it contains macros, keep the copy in a macro-enabled format such as .xlsm.
With other users out of the test copy, open Review > Share Workbook (Legacy) and clear the option to allow changes by more than one user. If the command is unavailable, add it through File > Options > Quick Access Toolbar. An authorized owner may need to change protection settings first.
Use File > Save As to save the test copy to OneDrive for Business or a SharePoint document library. Open it from that location in a version of Excel that supports co-authoring.
Select Share and invite another user with edit access. Change a row height or column width, then have the other user make and save an edit. Close and reopen the file to check whether both changes remain.

Edit Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and move everyday editing workflows to WPS; test protected workbooks and macros before migrating. WPS does not repair Excel's legacy sharing behavior.

Frequently Asked Questions
Why do row height changes disappear in a shared Excel workbook?
Excel's legacy Shared Workbook feature may not reliably merge formatting changes made by different users. Test a copy using co-authoring on OneDrive for Business or SharePoint to see whether the sharing method is responsible.
Where can I find the legacy Share Workbook command?
Look under Review for Share Workbook (Legacy). If it is not shown, use File > Options > Quick Access Toolbar to add the command.
Can I test a macro-enabled workbook with co-authoring?
Save a test copy as an .xlsm file to retain its macros, then upload it to OneDrive for Business or SharePoint. Test the macros and protection settings in the Excel versions your users will use before switching workflows.
Why does saving take so long when the row-height macro runs?
Recalculating every row on each save can add significant processing time. Review the macro to see whether it can run only when needed or target affected rows rather than the entire worksheet.




