Fix Excel’s Worksheet Move Error Between XLSX and XLS Workbooks
Question details
The user needs to move or copy a worksheet from an XLSX or XLSM workbook into a workbook saved in the older XLS format.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Moving a worksheet from a modern Excel workbook to an Excel 97–2003 workbook.
- Observed behavior
- Excel reports that the destination workbook has fewer rows and columns than the source workbook.
Open both workbooks in Excel and check the destination file’s extension. An XLS worksheet supports 65,536 rows and 256 columns, compared with 1,048,576 rows and 16,384 columns in XLSX and XLSM.
Convert the destination workbook to XLSX or XLSM before moving the sheet
Use a modern destination format to give the worksheet the same row and column capacity as the source workbook.
In the destination workbook, select File > Save As and choose Excel Workbook (*.xlsx). If the destination contains macros you need to keep, choose Excel Macro-Enabled Workbook (*.xlsm) instead.
Make sure the newly saved XLSX or XLSM destination and the source workbook are both open in Excel.
In the source workbook, right-click the worksheet tab and select Move or Copy. Choose the converted destination under To book, select a position, and click OK. Select Create a copy if you want to keep the source sheet.
If an XLS file is required, check that data and formatting fit within rows 1–65,536 and columns A–IV. Then use File > Save As and choose Excel 97–2003 Workbook (*.xls); review any compatibility warnings before saving.

Turn off legacy workbook sharing if another move error appears
Use this when the destination format is compatible but Excel still reports an error related to the legacy shared-workbook feature.
Work with Excel-compatible spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for working with Excel files. Open compatible workbooks in WPS Spreadsheets to transition your spreadsheet work, though it does not fix an error in Microsoft Excel itself.

Frequently Asked Questions
Why can’t Excel move my worksheet into an XLS workbook?
The XLS format supports only 65,536 rows and 256 columns per sheet, while XLSX and XLSM support larger worksheets. Save the destination as XLSX or XLSM through File > Save As, then try Move or Copy again.
Can I save the workbook as XLS after moving the sheet?
Yes, if the content fits the XLS limits. Use File > Save As and select Excel 97–2003 Workbook (*.xls), then review the compatibility warnings and the saved file for changes.
Should I choose XLSX or XLSM for the destination?
Choose XLSX for a standard workbook. Choose XLSM if the destination contains macros that you need to retain; select the format under File > Save As.
What if Excel still reports an error after I convert the destination?
If the workbook uses legacy sharing, open Review > Share Workbook (Legacy) and turn off sharing after other users have saved and closed the file. Then try the worksheet move again.




