Forum Discussion
Excel connected to SQL - auto update without having the file open?
So I have this Excel file in sharepoint library with a table set to update every 10 min or so to its data source, SQL. I don't have the SQL credentials so I just set up the Excel for a colleague who ...
lbendlin hey ty for your reply!
I'm using this Excel file in many PowerApps app, and it is a key factor in all of them.
You may want to start thinking about moving your data to a more robust platform, like SQL Server.