I would like to be able to upload and run reports in the Jet Hub that contain the Excel DATEDIF function.

I would like to be able to upload and run reports in the Jet Hub that contain the Excel VALUE function.

I would like to be able to upload and run reports in the Jet Hub that contain the Excel MAXIF function, similarly MAXIFS, MINIF, MINIFS.

I would like to be able to upload and run reports in the Jet Hub that contain the Excel TRIM function.

Currently there is a feature in cube data sources to use "Windows Authentication (Other User)" but it was originally configured to only allow this with IIS data sources. You can see from the screenshot below that it is greyed out and not selectabl...

(email from Miha) I see this happening more and more. Our clients are using PivotTables only, and when asked to refresh, they go to Jet tab and click refresh. That takes waaaaaaaay longer (since Jet checks for any formulas, replicators, etc), not ...

SWITCH and IFS are very common programmatic Excel functions and should be supported in the Jet Hub.