+ Reply to Thread
Results 1 to 7 of 7

Excel found unreadable content in filename.xlsm'. do you want to recover.....

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Excel found unreadable content in filename.xlsm'. do you want to recover.....

    Hi,
    I've got a problem when opening the excel. I've been searching around this problem, however, it's not exactly what I'm encounter.
    I have an excel 2007 file which contain a lot of macros. File size is 100MB. This file is not developed by myself, it's post in the webpage and let the members of the page to download on daily basis..
    I've been downloading and using this file for over a year with no problem until this week.

    Problem:
    During opening the file. There is a message box popped up, saying "Excel found unreadable content in filename.xlsm'. do you want to recover the contents of this workbook ? If you trust the source of this workbook, click Yes." When I click "yes", excel is trying to repair the file. Once it's done, I could see only the contents, however, all the macros are gone. When I copied this very same file and open in other notebooks, everything is working fine...

    Assumption:
    Couple days ago, I was writing/testing macros in other workbooks and also opened this particular file. I might did something stupid which cause this problem...
    During the same time, I used to have the same problem with another file. I solved it by copy and open with another PC then copy macros and paste it to the file on my notebook. I could not apply the same fix with the current problematic file as there are tons of macros.

    Could anyone help me on this problem ??
    Thank you for your help in advance...
    Cedia2545..

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel found unreadable content in filename.xlsm'. do you want to recover.....

    Hi Cedia,

    welcome to the forum.

    When I copied this very same file and open in other notebooks, everything is working fine...
    May be system resource issue.. check if other notebooks have higher configuration



    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    01-18-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Excel found unreadable content in filename.xlsm'. do you want to recover.....

    Hi DILIPandey,
    Thank you for your response..
    Actually, my notebook is more powerful than another. I feel that there is something wrong with excel in my notebook.. Do you have any other clues ?
    rgds,
    Cedia

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel found unreadable content in filename.xlsm'. do you want to recover.....

    Hi Cedia, try repairing (else re-installing) office once again to correct any possible issue. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    01-18-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Excel found unreadable content in filename.xlsm'. do you want to recover.....

    ็Hi, I solved the problem by open the file in another PC and export all codes and forms, then copy them back on my notebook .. Sounds like tedious and stupid tasks but it is now back to normal on my notebook.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel found unreadable content in filename.xlsm'. do you want to recover.....

    Thanks for sharing the resolution that worked for you

    Please mark this thread as [SOLVED].


    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Re: Excel found unreadable content in filename.xlsm'. do you want to recover.....

    Hi, The best and easy solution is to upgrade Office 2007 - Service Pack 3 (SP3). (free)
    Finally it worked for me. It helps!!!

+ 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