12-31-2020 07:19 AM
12-31-2020 07:19 AM
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.
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."
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>"
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.