+ Reply to Thread
Results 1 to 8 of 8

*HELP NEEDED* Corrupt excel files on mac and how to fix it?

  1. #1
    Registered User
    Join Date
    11-17-2012
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    was doing some routine maintenance on my mac and tried to delete some redundant files to free up some space on my hard drive, however in the process it appears that when i emptied the trash i deleted some important excel files that i needed which i was unaware were in the trash.

    I think because there was a lot of files deleted at once this is why it was not picked up.

    I've managed to recover one of the xlsx excel files i needed with 3rd party data recovery software however the file will not open in excel and i get the following error message:

    "The file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"

    If i make a .zip version of the file i can see the contents of the file that was present when it was a working workbook but in .bin files, i.e. sheet numbers, media etc. I've tried to use stellar phoenix's excel file repair software but this didn't work. Not sure if it was because it's a trial version or the file cannot be reparied.

    Does anyone have any suggestions for how the excel file could be repaired back to it's original state. Can there be some form of programming or editing in order to uncorrupt the file?

    Many thanks

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    Is it a file you can upload to here?
    Or does it have information in it that is too sensitive?
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    11-17-2012
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    Scottiex,

    I can private message you the file. It's not highly confiential but would prefer not to share with everyone if possible.

    Do you have some ideas on how this could be fixed?

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    Well I could try some things.
    I might not be the best person to do this as others might have software for it.
    Most people will need the file to test and examine otherwise they will just wildly guessing.

  5. #5
    Registered User
    Join Date
    11-17-2012
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    The file size i have is 17.MB which is 0.7MB above the maximum file allowed for the website , therefore would have to send the file to your email to be able to look at this.

  6. #6
    Registered User
    Join Date
    11-17-2012
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    scottiex,

    I have managed to compress my file and attach to this thread (see attached).
    If you have any potential fixes to get this excel file back to it's original structure, please let me know.
    Last edited by AledgG87; 11-26-2017 at 07:48 AM.

  7. #7
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    11 sheets
    one module with vba
    4 pictures
    shapes
    charts
    data of course

    want more ? or simply you want recovered file ?

    btw. no special software. only brain and standard excel

    example:

    rec.jpg

    I didn't publish more because of, like you said, private data

    PM required
    Last edited by sandy666; 11-25-2017 at 03:32 PM. Reason: example printscreen added

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: *HELP NEEDED* Corrupt excel files on mac and how to fix it?

    I think I can say that:

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Corrupt files> workbooks.open> excel crash
    By ayush002 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2016, 03:00 PM
  2. Excel 2007 : Password causing corrupt files
    By JimBobBowie in forum Excel General
    Replies: 0
    Last Post: 10-12-2011, 07:03 AM
  3. Windows XP : Search for Corrupt Files
    By rockstar89 in forum Microsoft Windows Help
    Replies: 2
    Last Post: 06-23-2011, 11:59 AM
  4. Search for Corrupt Files
    By rockstar89 in forum Excel General
    Replies: 1
    Last Post: 02-24-2011, 01:17 PM
  5. Corrupt files open and freeze... help!
    By Hambone70 in forum Excel General
    Replies: 2
    Last Post: 02-09-2011, 09:58 AM
  6. Corrupt Spreadsheet and Temporary files
    By Jetl3on in forum Excel General
    Replies: 1
    Last Post: 12-04-2007, 06:40 PM
  7. corrupt Excel 2000/2002 files
    By Ohio Doug in forum Excel General
    Replies: 0
    Last Post: 11-21-2005, 11:40 AM

Tags for this Thread

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