'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel File Missing After Copying to a USB Drive
Question details
The user copied an Excel workbook to a USB drive, but the file does not appear when the drive is connected to another laptop.
- Product
- Microsoft Excel / USB Flash Drive
- Device & OS
- not provided
- Scenario
- Transferring an Excel file between two laptops using a physical USB flash drive.
- Observed behavior
- The Excel file is completely missing or invisible on the USB drive when viewed on the second laptop, despite a successful transfer via email proving the file itself is intact.
Ensure the USB drive is securely connected to a working USB port on your laptop and check if any other existing files on the drive are visible.
Verify Transfer Method and Show Hidden Files
Ensure the file was fully written to the drive, was not accidentally copied as a shortcut, and is not hidden by system settings.
Often, files fail to appear on a destination computer because the USB drive was ejected before the file transfer completed, or Windows settings are hiding specific file types. Additionally, dragging a file sometimes creates a shortcut link instead of copying the actual workbook data.
Open File Explorer on the second laptop, navigate to your USB drive, click the 'View' tab on the top ribbon, and check the box for 'Hidden items' to reveal any concealed files.
Check the USB drive on the original laptop. Make sure you copied the actual '.xlsx' spreadsheet and not a '.lnk' shortcut file.
On the original laptop, right-click the Excel file, select 'Copy', navigate to the USB drive folder, right-click an empty space, and select 'Paste'.
Before removing the USB drive, click the USB icon in the system tray at the bottom right of your screen and select 'Eject'. Wait for the 'Safe to Remove Hardware' prompt to ensure all data is fully written.
Perform Hardware Checks on USB Ports and Drives
Rule out physical hardware issues with the USB port or a corrupted flash drive preventing the file from displaying.
Open and Transfer Spreadsheets Effortlessly with WPS Office
Avoid USB drive corruption and missing files entirely by using WPS Office. You can easily open any Microsoft Excel workbook or use built-in cloud storage to securely sync files between your laptops without needing physical drives.
- 1. Install WPS Office: Download and install WPS Office on both of your laptops.
- 2. Upload to Cloud: Open WPS Office on the first laptop, sign in to your account, open your Excel workbook, and save it directly to WPS Cloud.
- 3. Access on the Second Laptop: Log in to the same WPS account on the second laptop to instantly access, view, and edit your spreadsheet without relying on a USB drive.
Frequently Asked Questions
Why do files disappear from my USB drive when I plug it into another computer?
This usually happens due to unsafely ejecting the drive before data finishes writing to it. It can also be caused by hidden file settings, file system corruption, or malware on either computer.
How do I ensure an Excel file is copied, not just linked?
Instead of dragging and dropping, right-click the actual Excel file, select 'Copy', go to your USB drive, right-click an empty space, and select 'Paste'. Ensure the file size is larger than a few kilobytes, as a very small size usually indicates a shortcut (.lnk) was copied instead of the file.
Can I transfer an Excel file without a USB drive?
Yes. You can attach the file to an email and send it to yourself, or use cloud storage solutions like WPS Cloud, Google Drive, or OneDrive to sync the file over the internet directly to your second laptop.
What happens if the second laptop doesn't have Excel installed?
If Microsoft Excel is not installed, the file will still physically exist on the USB drive, but it may display as a generic blank white icon and will prompt you to choose an application when double-clicked. You can install a free alternative like WPS Office to view and edit it.
