User has an issue with one particular excel file and it's stuck at loading, mouse is also a blue loading circle so they cannot engage with the file, only close via Task Manager.
It's a big file with macros, so I've been told it might be VBA related.
Troubleshooting steps completed:
- Cache cleared
- Temporary files cleared
- Enabled "Trust access to the VBA project object model"
The performance slightly improved, because at first data was also retrieving only partially. Now it's retrieving fine, some #/DIV errors. But blue circle is still there and file isn't clickable.
What other steps can be done to fix the issue?