Excel file quit working.

Question

I have an excel file that I use on a regular basis and it stopped working. It has macros that retrieve data and populate the excel file. It worked for years and then it started giving me the debug window and I can only select END

When I looked it up it shows to select unblock in the properties window, but it does not show up there. It also said to go to internet options and tell it to trust the site that it came from but it does not come from a website. I am not sure what to try next.

Answer 1

I get the following when I do this:

C:\WINDOWS\system32>bcdedit -debug off

An error occurred while attempting to modify the debugger settings.

The value is protected by Secure Boot policy and cannot be modified or deleted.

Answer 2

Hi Brooks

Thank you for writing to Microsoft Community Forums.

I understand that you are facing issue with debug mode in excel, and I certainly appreciate your efforts in trying to resolve the issue.

We will certainly look into this for you.

One of the things that you can try is using the command line interface to disable debug mode in Windows. Kindly follow the steps mentioned below:

1. Press Windows + S key together to open Search.
2. Now type CMD and select Run as administrator.
3. Accept the UAC prompts. Type in the following command and hit Enter: bcdedit -debug off
4. Restart the PC

Lets see if that helps!

Regards,

Shannah