Hi,i`m currently having an issue with an excel file

BremilX

New Member
Messages
1
Hi,

I m currently having an issue with an Excel file on Windows XP Laptop. A user was working on this file yesterday evening with no issues.File was being saved to a network drive and no file save errors were received.When the user came in this morning the file was coming up with a eror message"excel cannot open the file because the file format or file extension is not valid" And also the file is showing up as having 0kb. Tried an excel repair on the file and also opening up in another program like .doc or .txt. Is there any way of finding out what happened this file or fixing the issue. Another user has also reported that the exact same issue happened them last week!!File server is running windows 2003 server. Shadow copies are available and I can restore the file to previous version, however the user did alot of work after that time.

Thanks
 

My Computer

System One

  • OS
    Windows 8
I found this googling it, don't no if it works or even is possible or save to do in Excel.
I've found some success on this. Using Excel 2010, trying to open a file on a network drive, i was getting the "The file is corrupt and cannot be opened" error message. When I added the network drive as a trusted location, I was able to open the file with no problem.

To add a trusted location in 2010, go to FILE>OPTIONS>TRUST CENTER
hit "Trust Center Settings..." button
click on "Trusted Locations" Tab
ensure that you have a check next to "allow trusted locations on my network (not recommended)"
Click "Add new location..." button
In the field labeled "Path" type out the full path name to the network location (ie. \\Drive\directory($)\folder), dont use mapped drive letters
Optional: check "subfolder of this location are also trusted" box.
Now hit OK until you get back to the spreadsheet, and try to open the file again.

source Excel file gets corrupted
 

My Computer

System One

  • OS
    windows 8.1
    Computer type
    PC/Desktop
    System Manufacturer/Model
    self build
    CPU
    Intel(R) Core(TM) i5 CPU 750 @ 2.67GHz
    Motherboard
    Asrock P55 Pro
    Memory
    DDR3 Team--Elite-1333 8 gb
    Graphics Card(s)
    Sapphire R9 280x
    Sound Card
    Realtek Alc 855
    Monitor(s) Displays
    Acer V233H
    Screen Resolution
    1920 x 1020
    Hard Drives
    Samsung evo 850 SSd
    Seagate ST 320 gb
    Samsung HD 750 gb
    Seagate ST 3000gb
    PSU
    OCZ Stealth 600 watt
    Case
    Antec 300
    Mouse
    Speedlink Ledos and Nexus
I think your file is corrupted and it may be repaired using a software; I personally have not used the Excel version of this maker but I have used: https://social.technet.microsoft.co...25abc4babb9/i-need-to-xlsx-viewer?forum=excel

I have heard of that if the the file was first created in Excel 2003 and never converted to 2007; however, if the user was working for a long time Excel may have saved a copy in the users computer C:\Documents And Settings\UserName\Application Data\Microsoft\Excel\filename.xlsx.

Another thing, I use Undelete Server Edition and it has worked great for the last 5 years; every time a user saves a file it makes a copy and it stores it for the time you specify.
 

My Computer

System One

  • OS
    Windows 8.1
Back
Top