+ Reply to Thread
Results 1 to 9 of 9

Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

  1. #1
    Registered User
    Join Date
    11-05-2015
    Location
    kiribati
    MS-Off Ver
    2010
    Posts
    2

    Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    Hello,
    I have a corrupted Microsoft Excel Macro-Enabled Workbook xlsm file. Does anyone know how i can restore or recover it please?

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    upload it here?

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    Too late now, but ALWAYS make a backup.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    11-11-2015
    Location
    Lithuania
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    Have you reviewed this page?
    Title: Repairing a corrupted workbook
    Link: http://office.microsoft.com/en-us/ex...010097017.aspx
    Try for easy recovery Excel Recovery Toolbox. http://www.oemailrecovery.com/excel_recovery.html
    It’s really a professional soft for recovery.

  5. #5
    Registered User
    Join Date
    11-11-2015
    Location
    Lithuania
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    Look also this source for more information
    https://social.technet.microsoft.com...st?forum=excel

  6. #6
    Registered User
    Join Date
    11-07-2015
    Location
    Zhejiang,China
    MS-Off Ver
    2003
    Posts
    2

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    When an Excel file is corrupted, then you can try several methods to recover it:

    1. First of all, you can try to repair the file manually in Excel, as follows:

    (1) On the File menu, click Open.
    (2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
    (3) Click Open and Repair, and then choose which method you want to use to recover your workbook.

    You may find more information about this at:

    http://office.microsoft.com/en-us/ex...001034656.aspx (for Excel 2003)
    http://office.microsoft.com/en-us/ex...017.aspx?CTT=1 (for Excel 2007)
    http://office.microsoft.com/en-us/ex...840.aspx?CTT=1 (for Excel 2010)
    http://office.microsoft.com/en-us/ex...554.aspx?CTT=1 (for Excel 2013)

    2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below

    http://office.microsoft.com/en-us/ex...#_Toc337637262

    3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,

    3.1 OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.

    3.2 KingSoft Spreadsheets at http://www.kingsoftstore.com/office/free-excel. This is a free Windows tool that can open Excel files.

    Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.

    4. For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as WinRAR at http://www.rarlab.com to repair the file, as follows:

    4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
    4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
    4.3 Rename a_fixed.zip back to a_fixed.xlsx
    4.4 Using Excel to open a_fixed.xlsx.


    There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.

    5. If all above methods do not work, then you may try third-party tools such as DataNumen Excel Repair at

    https://www.datanumen.com/excel-repair/

    It provides a free demo version so that you can try to see if the data you want can be recovered or not.

    Good luck!

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    Try right clicking on the file in Windows Explorer (File Explorer) depending upon the version of Windows being used and then choose Previous Versions. If a list is presented, start at the latest file and try to open it. If it opens and works properly save it under a new name. Continue going back in time on the list until you find a file that works properly. That will be the latest file not corrupted.

    You should be presented with something like this:
    Capture.JPG
    Last edited by newdoverman; 11-14-2015 at 11:35 AM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  8. #8
    Registered User
    Join Date
    11-05-2015
    Location
    kiribati
    MS-Off Ver
    2010
    Posts
    2

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!

  9. #9
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    Re: Corrupted Microsoft Excel Macro-Enabled Workbook xlsm file

    MR NEWDOVERMAN, I had corrupted xlsm, i tried the repair from excel, no succes, i tried export data, protected view settings, all options I found online, stellar profesional recovery... no success,

    when i finaly give up after hours, and see a lot of work ahead, I gave it a last try on this forum, and the I saw your VERY SIMPLE suggestion, and I GOT IT BACK SO EASY

    TTHHAAAANNNKK YYYOOUUUUUUUUUUU ssoooooo Much !

+ 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. Replies: 2
    Last Post: 05-20-2015, 06:37 AM
  2. [SOLVED] Open corrupted .xlsm file
    By LAVA2 in forum Excel General
    Replies: 21
    Last Post: 01-27-2015, 04:34 AM
  3. Replies: 1
    Last Post: 11-06-2014, 05:23 PM
  4. [SOLVED] Send via email macro enabled wrksheet (xlsm) as regular wrksheet (xlsx) using a macro code
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2013, 09:26 PM
  5. How to protect a file of Excel-Macro enabled workbook with password?
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2013, 02:16 PM
  6. File size reduction _ Macro-Enabled Worksheet (.xlsm)
    By berger01 in forum Excel General
    Replies: 3
    Last Post: 02-21-2013, 10:49 PM
  7. Save file xls file as xlsm - macro won't run in xlsm workbook
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2012, 11:39 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