When I run a report it always gets stuck at "Naming ranges" and half the time it will give me a few errors.

(From Sage) "An error occurred trying to refresh Excel's links to it's installed Add-Ins. The error was [Automation error The remote procedure call failed.] The report will continue to run but it may be incorrect."

(From Sage) "Error number [462] The remote server machine does not exist or is unavailable"

(From Excel) "Excel is running into problems with the report designer add-in 1.2.0. If this keeps happening, disable this add-in and check for available updates."

It's obviously an issue with the add-in but it was working about a week ago and nothing has changed, so I'm not entirely sure what happened.

I have tried to disable the add-in and see if there is an update but I don't know where I would even look for that update.

Has anyone else come into this issue before and knows how to fix it?

Thanks in advance.