File Sharing Problems

Fix Excel Shared Workbook Row Height and Column Width Changes Not Saving

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

The user needs row height and column width changes to remain in a shared Excel workbook when other users save it.

Fix Excel Shared Workbook Row Height and Column Width Changes Not Saving
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a test copy

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.

2
Turn off legacy sharing in the copy

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.

3
Save the copy to a cloud location

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.

4
Share and test the dimensions

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.

Test modern Excel co-authoring with a copy of the workbook
Check before replacing the original: Test the workbook's protection, macros, and normal editing workflow before switching users to the cloud copy. Avoid recalculating every row on every save unless the workflow requires it.
Free Microsoft Office alternative

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.

Adjust row heights and column widths in WPS SpreadsheetOpen and edit Microsoft Excel formats such as XLSX and XLSUse a familiar spreadsheet interface for everyday editingWork with a free, lightweight office suite
QA img-9

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.