Query? 

How to fix Excel Macros not working issue that started after a Windows Update?

How to:

Macros usually have problems executing when a windows update takes place. The solution is to export the macro and save it, remove the existing macro that's not working and reimport it.

1. Open the Excel sheet and navigate to the Developer tab in the menu bar and then click 'Visual Basic' 

2. Once clicked a separate Visual Basic window will open like below, click on the 'Modules' in the left panel.

3. A drop down will open with the available macros.

4. Right-click on the macro you are having a problem with and click on 'Remove'.

5. You will be prompted with the window as below, click 'Yes'.

6. Once you click Yes, Excel will give an option to save the macro. Make a folder on the desktop and save the macro in it.

7. Go back to the Visual basic window and navigate to 'File' in the main menu bar. In there click on 'Import File'.

8. Once you click on 'Import File' a file browser will open. Navigate to the folder you saved the macro in Step 6 and click open.

9. Verify that the macro is imported in the left panel under Modules and hit 'Save'.

THE END