Fix Excel Files Copied from Another Laptop That Will Not Open
Question details
The user needs to open Excel workbooks copied from another laptop to an external hard drive.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Windows 10
- Scenario
- Opening Excel files transferred from another laptop using an external hard drive.
- Observed behavior
- Opening the copied files leads to a blank desktop without a workbook name.
Connect the external drive and locate the affected files in File Explorer. Note any error message or prompt that appears when you try to open one.
Open a local copy and check the workbook file
Use this first to rule out a problem accessing the workbook directly from the external drive.
In File Explorer, right-click the workbook on the external drive, select Copy, and paste it into a local folder such as Documents.
In File Explorer, select View and turn on File name extensions. Right-click the local copy, select Properties, and check that it has an expected extension such as .xlsx or .xls and a nonzero file size. Do not change the extension to try to repair it.
Open Excel, select File > Open > Browse, and choose the local copy. Note any error or password prompt that appears.

Check cloud availability and drive encryption
Use this if the original workbook was stored in OneDrive or SharePoint, or if the drive is encrypted.
Test and repair the copied Excel workbook
Use this if a local copy still does not open and you need to determine whether the workbook is damaged.
Try WPS Spreadsheet for Your Copied Excel Workbooks
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move between office suites. Try opening an accessible local workbook in WPS Spreadsheet; it cannot unlock a drive or guarantee repair of a damaged file.

Frequently Asked Questions
Why does Excel show a blank screen when I open a copied workbook?
The cause is not yet known. Try opening a local copy through Excel's File > Open > Browse, and check for an error message, an incomplete copy, or a cloud or drive access issue.
How do I check whether the workbook copied correctly?
In File Explorer, right-click the copied file and select Properties. Check its size and turn on View > File name extensions to confirm it has an expected Excel extension. If the file is zero bytes, copy it again from the source.
Can OneDrive or SharePoint affect a copied workbook?
Yes. If the original file was only available online, download it or make it available offline on the source laptop before copying it to the external drive.
What should I do if the external drive is BitLocker-protected?
If Windows prompts you to unlock the drive, enter its password or recovery key. Once it is accessible in File Explorer, copy the workbook to a local folder and try opening it again.
Where is Excel's workbook repair option?
In Excel, select File > Open > Browse, select the workbook, and click the arrow next to Open. Choose Open and Repair, then select Repair.




