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 ...
I had the same problem, but in any case I recomend you to add a new query to show the time of last update .