To troubleshoot this issue, try the following steps:

1. Check if you have the latest version of Excel.
2. Make sure macros are enabled (File → Options → Trust Center → Trust Center Settings → Macro security → Security Level → Enable all macros)
3. Verify that the macro you are trying to run isn’t blocked by Excel.
4. Download and install the Microsoft Macro Runtime.
5. Run Excel as an administrator and try again.
6. Onward is to uninstall and reinstall Office again.