Error - run-time error '1004' CurrentRegion

When opening a report in Excel 2003 you may receive the following error message from Excel - Run-time error '1004': Unable to get the CurrentRegion property of the Range class.

This error is triggered when the number of row fields exceeds the allowable size in Excel 2003.

Solution 1

Rerun your report and go to the Row Fields tab. Remove unnecessary row fields. If they are all necessary, then note down the names of several that are of lower priority. Remove them and readd them on the Page Fields tab.

Solution 2

Our reporting engine is generates reports in Excel 2003 version for backwards compatibility reasons. If possible, use a newer version of Excel (2007+) and import the data through our report web services instead. These load the data through XML and bypass Excel 2003's limitations.