+ 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
    13

    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,484

    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
    13

    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
    43,981

    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 some-1 helped you

    Regards
    Ford

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

    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
    43,981

    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
    17,632

    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!
    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
    Old Country
    MS-Off Ver
    PC: Best
    Posts
    8,671

    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)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything
    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking

  9. #9
    Valued Forum Contributor
    Join Date
    08-13-2008
    Location
    Καθαρτήριο
    MS-Off Ver
    2010 primarily
    Posts
    557

    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
    17,632

    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
    13

    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