File Cannot Open

Fix Excel File Not Found Errors When Moving Worksheets

Phi Hung VoPhi Hung Vo Nov 20, 2026 869 views

Question details

The user needs to move or copy worksheets between Excel workbooks without a file not found error.

Fix Excel File Not Found Errors When Moving Worksheets
Product
Microsoft Excel
Device & OS
not provided
Scenario
Moving or copying worksheets between workbooks opened from email attachments.
Observed behavior
Excel reports a file not found error involving a temporary VBA file during the move or copy.
Before you start

Save both email attachments to a local folder and confirm that they open in Excel. If either workbook contains macros, preserve its macro-enabled file format when saving.

Solution 1Recommended

Save Both Workbooks Locally Before Moving the Worksheet

Use local copies to avoid working directly from temporary email attachment locations.

1
Save the attachments

In your email application, use the attachment's Save or Download option to save both workbooks in a local folder.

2
Open the local files

In Excel, select File > Open and open each workbook from the folder where you saved it.

3
Move or copy the sheet

Right-click the worksheet tab, select Move or Copy, and choose the destination workbook under To book. Select Create a copy if you want to keep the original sheet, then click OK.

4
Save the result

Select File > Save in the destination workbook and check that the worksheet appears as expected.

Save Both Workbooks Locally Before Moving the Worksheet
Keep macro-enabled formats: If a workbook contains VBA macros, use a macro-enabled format such as .xlsm when saving it. Review any macros and links after moving or copying the sheet.
Free Microsoft Office alternative

Work With Excel Workbooks in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday workbook tasks to WPS. It does not repair the Microsoft Excel installation or guarantee VBA compatibility.

Open and edit common Excel .xlsx and .xls workbooksOrganize worksheets in a familiar spreadsheet interfaceUse a free, lightweight office suite for everyday filesTransition common spreadsheet tasks without starting from scratch
QA img-9

Frequently Asked Questions

Why does the error occur with email attachments?

Attachments may open from temporary locations that Excel cannot reliably access during a worksheet move or copy. Save both files to a local folder, then reopen them using File > Open.

How do I copy a worksheet without removing the original?

Right-click the worksheet tab, select Move or Copy, choose the destination workbook, and check Create a copy before clicking OK.

How can I check whether a workbook is damaged?

In Excel for Windows, select File > Open > Browse, select the workbook, and choose Open and Repair from the arrow next to Open.

Should I save a workbook with macros as an .xlsx file?

No. An .xlsx file cannot retain VBA macros. Use File > Save As and select a macro-enabled format such as .xlsm if the workbook needs to keep its macros.

Will WPS Office repair this Microsoft Excel error?

No. WPS Office is an alternative for working with common Excel files; it does not repair Excel. Check VBA compatibility before relying on a macro-enabled workbook in WPS.