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
Super User
Super UserIs there a way for this file to autoupdate with no one having the file open?Why update it when nobody looks at the data?
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.- lbendlin
You may want to start thinking about moving your data to a more robust platform, like SQL Server.
lbendlin I don't have credentials to SQL and don't think that's changing anytime soon, I'm stuck the way it is. Need to use the Excel as source for my apps. Also, users of the app need to have acces to that Sql database as well, so don't think that would even work for me.
In other words, I'm forced to use this clunky excel file
