+ Reply to Thread
Results 1 to 11 of 11

Corrupted Excel file

  1. #1
    Registered User
    Join Date
    07-13-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    12

    Corrupted Excel file

    Hello I had an old excel file on my usb, and I tried to access it today, but i keep getting an error " The file is corrupt and cannot be opened", is there a way to fix this or have I lost the file and the data within it for good?

    Thank you

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    2,700

    Re: Corrupted Excel file

    This kind of thing often happens when USB drives are removed without going through the safe removal process. Files corrupted in this way are typically unrecoverable by any means.
    Cheers,
    Paul Edstein
    [MS MVP - Word]

  3. #3
    Registered User
    Join Date
    07-13-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    12

    Re: Corrupted Excel file

    Hmm, sigh. I think i will keep a cloud backup going into the future. Hopefully those are more safer from corrupting ? Thanks for your comment.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,387

    Re: Corrupted Excel file

    Have you tried a google search yet? There may be some free stuff out there that will help

    https://www.google.com/search?rlz=1C....0.hfPQqEedc_Q
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  5. #5
    Registered User
    Join Date
    07-13-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    12

    Re: Corrupted Excel file

    I have but one of the softwares didn't work, i'll check out others. Thank you for sharing the link and your post

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,387

    Re: Corrupted Excel file

    No problem

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,161

    Re: Corrupted Excel file

    You need to have a rigorous approach to backing up. I have my system set up to back up once a day to an external hard drive at home and to the cloud. Using something like DropBox or OneDrive is fantastic if you want access to your files from different machines, but you still need to think about making incremental copies of important files (e.g. by saving them under a new name each time you work on them - I tend to use a date and/or version number in my file names).

    Hope this helps!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    Re: Corrupted Excel file

    attach this file
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  9. #9
    Forum Expert
    Join Date
    08-13-2008
    Location
    behind you
    MS-Off Ver
    2010 primarily
    Posts
    1,243

    Re: Corrupted Excel file

    Dropbox and OneDrive also have a time limited version history for the files.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,161

    Re: Corrupted Excel file

    Yes, and so does LiveDrive, which is another option.

  11. #11
    Registered User
    Join Date
    07-13-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2013
    Posts
    12

    Re: Corrupted Excel file

    Thank you guys for these wonderful tips. i'll start using these practices.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1