Unable to Open or Copy Corrupted Excel Files on Network Drive

IT Researcher

New Member
Joined
May 17, 2013
Messages
8
Hello,

I have encountered an issue with few Excel files stored on a network path. Out of six files, three appear to be corrupted. When I try to open these files by double-clicking, Excel launches but displays the following error message: "Could not open '...xlsx'." Additionally, when I attempt to copy these corrupted files to another folder or even to another PC, I receive the error: "Invalid MS-DOS function." I am not able to copy these corrupted excel files out of the folder. I also tried to copy the folder, at that time only 3 files were copied other 3 files are giving the same error as "Invalid MS-DOS function".

Message when tried to open.
Untitled.png


Message when tried to copy.
PicasaPhotoViewer_2024-09-24_16-16-22.png



I have also tried using the "Open and Repair" function in Excel 2010 and 2019 and tried to open in safe mode, but the files still won't open. Interestingly, even corrupted files should still be copy able. To test this, I purposely corrupted an Excel file by changing its format type and received a specific error related to the format type, but I was still able to copy the file.

I also attempted to use the xcopy command to copy the corrupted files. However, the output of the command was:

"The target volume does not support symbolic links. 0 File(s) copied."

Additionally, when I try to open the Excel file using other means, such as Notepad or Notepad++, the file will not open.

We have examined the event logs, but there are no application or disk errors. The disk's state is reported as healthy.

I also tried Recuva and file recovery tools to recover the data, but these two applications are not allowing me to enter the network path, only available for local disks.

Details:

Files are stored on a network drive.

Error when opening in Excel: "Could not open '\network_path\folder\abc.xlsx'."

Error when copying: "Invalid MS-DOS function."

xcopy output: "The target volume does not support symbolic links. 0 File(s) copied."

Tried using "Open and Repair" in Excel, checked for drive health, and attempted to open the files in different Excel versions.

I can copy and open other files from the same network path without any issues.

Tried to open with libreOffice. Couldn't able to open, gave options like open Read-only. When clicked on Read-only gave error "Read Error. Data could not be read from the file"

Based on my testing, even corrupted files should be copyable, so this behavior seems unusual.

Could anyone suggest possible reasons for this issue and potential solutions to recover or copy these files?



Thank you in advance for your help!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,224,847
Messages
6,181,324
Members
453,032
Latest member
Pauh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top