Reports Stopping at Naming Ranges stage


When running any SI report at one of my clients, the report generation stops at the Naming Ranges stage, after starting Excel.

After some time the following message comes up:

“Data Out – naming range

An error occurred while attempting to add a named range.  The error was (object required:)  Range Name :”

How do I fix this?