05-07-2021 10:46 AM
Hi,
Working on a POC for a client. To get data in quickly, I uploaded an Excel document so I can run a pivot off of it. The Excel is in the public folder.
I'm using this syntax
09-13-2021 10:14 AM
The File Source Types are defined as:
1. Dashboard - This option displays a file stored in a Dashboard Maintenance Unit File section
2. Application - This option displays a file stored in the XF Application Database storage location
3. System - This option displays a file stored in the XF System Database storage location
4. File Share - This option displays a file from the XF File Share storage location
Without seeing the full error message, the possible solutions for the invalid error are:
1. Verify that the File Source Type is pointing to where the Excel file resides in the File Explorer
2. Verify that the Folder Path and File Name exactly match where the file is stored in the File Explorer
3. Verify that Excel Worksheet Tab is correct
4. Verify that the Named Range from the Excel file is defined correctly