I have a problem when using a named range from an Excel spreadsheet as the datasource in ReportPlus.
The Excel sheet is located on a webserver. ReportPlus can see the spreadsheet and load the data, but i have an issue.
When ReportPlus loads the sheet it only loads the first two columns. The named range in the sheet covers columns A to K. As the named range will change every time i update my sheet i cannot set the range manually. So basically i have to rely on the automatic range selection option, but as stated above it auto detects only the first two columns. Is this a known issue? Is there a solution?
I have verified that the named range is correctly configured. Excel sheet version is 2003.