I have an Excel file on-prem with macros and connection to an on-prem SQL server. Every user has a copy of this file. When they open it or click on refresh then it fetched data from SQL data source.
I'm looking to upload this to SharePoint so that there is a central version of this excel file.
- How do I enable auto refresh on this excel file?
- How do I make it to connect to the on-prem SQL server?