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?