Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
80
Excel datasource from webserver
posted

Hi,

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.

Best Regards

Rasmus Hansen

Parents
No Data
Reply Children