Fix Excel File Not Found Errors When Moving Worksheets
Question details
The user needs to move or copy worksheets between Excel workbooks without a file not found error.

- 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.
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.
Save Both Workbooks Locally Before Moving the Worksheet
Use local copies to avoid working directly from temporary email attachment locations.
In your email application, use the attachment's Save or Download option to save both workbooks in a local folder.
In Excel, select File > Open and open each workbook from the folder where you saved it.
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.
Select File > Save in the destination workbook and check that the worksheet appears as expected.

Check the Workbooks and Repair Microsoft Office
Use these Windows checks if the error continues after both workbooks are saved locally.
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.

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.




