Error: Named Ranges and Excel Formulae not working in raw data sheets where the sheet name includes a space character

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Symptoms

The following are examples of error messages that may occur:

  • Named Ranges and Excel Formulae not working in raw data sheets where the sheet name includes a space character

Causes

Not available

Resolution

Alchemex have confirmed this to be a problem in versions 3.6.0.0 and earlier. To fix the problem please update your software. To workaround the problem without updating your software make sure that all raw data sheets in your report are named with a single word (i.e. no space characters included)

Applies To

  • Report Template