Excel workbook repair breaks my workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2024538%22%20slang%3D%22en-US%22%3EExcel%20workbook%20repair%20breaks%20my%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024538%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20am%20currently%20unable%20to%20open%20a%20macro%20enabled%20workbook%20without%20losing%20the%20functionality%20of%20the%20workbook.%20I%20am%20working%20from%20Excel%20version%202004%2C%20build%2012730.20250%20Click-to-Run.%20This%20is%20part%20of%20my%20company's%20Microsoft%20365%20for%20enterprise%20subscription.%20This%20is%20a%20workbook%20that%20I%20have%20not%20had%20to%20use%20for%20a%20few%20months%2C%20so%20I%20am%20not%20sure%20exactly%20when%20the%20issue%20started.%20I%20have%20worked%20with%20our%20IT%20and%20have%20had%20no%20luck%20in%20resolving%20the%20issue.%20We%20have%20done%20a%20clean%20install%20of%20Excel%20and%20of%20the%20Microsoft%20365%20suite%20with%20no%20success.%20I%20have%20several%20files%20that%20use%20this%20template%20and%20all%20of%20them%20show%20the%20same%20error.%20I%20have%20the%20original%20file%20on%20a%20usb%20and%20it%20has%20the%20same%20issue.%20I%20have%20sent%20it%20to%20other%20colleagues%20and%20they%20were%20able%20to%20open%20the%20file%20with%20no%20issue.%20I%20will%20provide%20some%20screenshots%20below%20of%20what%20I%20am%20seeing%20and%20provide%20the%20workbook%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Dlemon23_0-1609426563750.png%22%20style%3D%22width%3A%20433px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243564i300EB07A28836EE1%2Fimage-dimensions%2F433x236%3Fv%3D1.0%22%20width%3D%22433%22%20height%3D%22236%22%20role%3D%22button%22%20title%3D%22Dlemon23_0-1609426563750.png%22%20alt%3D%22Dlemon23_0-1609426563750.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20the%20screen%20I%20see%20when%20I%20try%20to%20open%20the%20file.%20Not%20sure%20if%20this%20is%20legible%2C%20but%20it%20says%20%22We%20found%20a%20problem%20with%20some%20content%20in%20'Estimating%20VMA%20and%20Voids%20Template%202018-02-26.xlsm'.%20Do%20you%20want%20us%20to%20try%20to%20recover%20as%20much%20as%20we%20can%3F%20If%20you%20trust%20the%20source%20of%20this%20workbook%2C%20click%20Yes.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Dlemon23_1-1609426740040.png%22%20style%3D%22width%3A%20367px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243565i4861FD431E603168%2Fimage-dimensions%2F367x201%3Fv%3D1.0%22%20width%3D%22367%22%20height%3D%22201%22%20role%3D%22button%22%20title%3D%22Dlemon23_1-1609426740040.png%22%20alt%3D%22Dlemon23_1-1609426740040.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAfter%20clicking%20yes%2C%20this%20is%20what%20I%20get.%20(I%20will%20have%20another%20screen%20shot%20of%20what%20this%20screen%20and%20workbook%20actually%20should%20look%20like.)%20I%20get%20a%20message%20letting%20me%20know%20that%20the%20sheet%20was%20%22repaired%22.%20Log%20file%20of%20repairs%20is%20in%20the%20quote%20below.%20I%20do%20not%20have%20the%20expertise%20to%20see%20if%20there%20is%20something%20in%20this%20error%20message%20that%20may%20point%20me%20in%20the%20direction%20of%20a%20solution.%20This%20%22repair%22%20breaks%20the%20workbook%20and%20its%20functionality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%22%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%3CRECOVERYLOG%20xmlns%3D%22%26quot%3B%26lt%3BA%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fschemas.openxmlformats.org%2Fspreadsheetml%2F2006%2Fmain%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fschemas.openxmlformats.org%2Fspreadsheetml%2F2006%2Fmain%3C%2FA%3E%22%26gt%3B%3CLOGFILENAME%3Eerror096880_01.xml%3C%2FLOGFILENAME%3E%3CSUMMARY%3EErrors%20were%20detected%20in%20file%20'C%3A%5CUsers%5Cdlemon%5CDesktop%5CEstimating%20VMA%20and%20Voids%20Template%202018-02-26.xlsm'%3C%2FSUMMARY%3E%3CREMOVEDPARTS%3E%3CREMOVEDPART%3ERemoved%20Part%3A%20%2Fxl%2Fcomments1.xml%20part.%20(Comments)%3C%2FREMOVEDPART%3E%3C%2FREMOVEDPARTS%3E%3C%2FRECOVERYLOG%3E%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Dlemon23_3-1609427236400.png%22%20style%3D%22width%3A%20395px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243567i59FC01C2403C10C4%2Fimage-dimensions%2F395x211%3Fv%3D1.0%22%20width%3D%22395%22%20height%3D%22211%22%20role%3D%22button%22%20title%3D%22Dlemon23_3-1609427236400.png%22%20alt%3D%22Dlemon23_3-1609427236400.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20am%20able%20to%20open%20the%20workbook%20in%20safe%20mode%20and%20it%20retains%20all%20functionality.%20I%20am%20looking%20to%20be%20able%20to%20open%20the%20sheet%20without%20having%20to%20open%20excel%20in%20safe%20mode%20every%20time.%20Any%20assistance%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EDoug%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2024538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2024641%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20repair%20breaks%20my%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914684%22%20target%3D%22_blank%22%3E%40Dlemon23%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20able%20to%20open%20your%20workbook%20without%20error%20messages.%20It%20looks%20like%20your%20last%20screenshot.%20I%20am%20using%20Excel%202019%2C%20fully%20updated.%3C%2FP%3E%0A%3CP%3EPerhaps%20someone%20else%20with%20Microsoft%20365%20can%20have%20a%20look...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2024667%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20repair%20breaks%20my%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024667%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BThanks%20for%20checking%20Hans.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026754%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20repair%20breaks%20my%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914684%22%20target%3D%22_blank%22%3E%40Dlemon23%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%20errors%20on%20365%20(beta%20channel)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2029461%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20repair%20breaks%20my%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20checking.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good Morning,

        I am currently unable to open a macro enabled workbook without losing the functionality of the workbook. I am working from Excel version 2004, build 12730.20250 Click-to-Run. This is part of my company's Microsoft 365 for enterprise subscription. This is a workbook that I have not had to use for a few months, so I am not sure exactly when the issue started. I have worked with our IT and have had no luck in resolving the issue. We have done a clean install of Excel and of the Microsoft 365 suite with no success. I have several files that use this template and all of them show the same error. I have the original file on a usb and it has the same issue. I have sent it to other colleagues and they were able to open the file with no issue. I will provide some screenshots below of what I am seeing and provide the workbook as well.

 

Dlemon23_0-1609426563750.png

This is the screen I see when I try to open the file. Not sure if this is legible, but it says "We found a problem with some content in 'Estimating VMA and Voids Template 2018-02-26.xlsm'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

 

Dlemon23_1-1609426740040.png

After clicking yes, this is what I get. (I will have another screen shot of what this screen and workbook actually should look like.) I get a message letting me know that the sheet was "repaired". Log file of repairs is in the quote below. I do not have the expertise to see if there is something in this error message that may point me in the direction of a solution. This "repair" breaks the workbook and its functionality.

 

"<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error096880_01.xml</logFileN... were detected in file 'C:\Users\dlemon\Desktop\Estimating VMA and Voids Template 2018-02-26.xlsm'</summary><removedParts><removedPart>Removed Part: /xl/comments1.xml part. (Comments)</removedPart></removedParts></recoveryLog>"

 

Dlemon23_3-1609427236400.png

I am able to open the workbook in safe mode and it retains all functionality. I am looking to be able to open the sheet without having to open excel in safe mode every time. Any assistance would be greatly appreciated.

 

Thank you,

Doug

 

 

 

 

4 Replies

@Dlemon23 

 

I am able to open your workbook without error messages. It looks like your last screenshot. I am using Excel 2019, fully updated.

Perhaps someone else with Microsoft 365 can have a look...

@Hans Vogelaar Thanks for checking Hans.

@Dlemon23 

No errors on 365 (beta channel)

@Sergei Baklan 

Thank you for checking.