File Format & Compatibility

Fix Excel’s Worksheet Move Error Between XLSX and XLS Workbooks

Huda QurayshiHuda Qurayshi Nov 20, 2026 869 views

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.

Fix the Excel Worksheet Move Error Between XLSX and XLS Workbooks
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.
Before you start

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.

Solution 1Recommended

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.

1
Save the destination in a modern format

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.

2
Open the converted workbook

Make sure the newly saved XLSX or XLSM destination and the source workbook are both open in Excel.

3
Move or copy the worksheet

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.

4
Check before saving as XLS

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.

Convert the destination workbook to XLSX or XLSM before moving the sheet
Older format limitations: Saving as XLS can remove or change content and features that the older format does not support. Review the saved XLS file before using it.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesWork with worksheets in a familiar spreadsheet interfaceMove spreadsheet work to a free, lightweight office suiteUse familiar file formats when transitioning existing workbooks
microsoft office alternative - wps office

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.