Forum Discussion

WorkingRicardo's avatar
WorkingRicardo
New Member
1 year ago

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 ...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
mermanahan's avatar
mermanahan
Frequent Visitor
1 year ago

How do they use this excel file with the connection to SQL Server? Need a better understanding of the overall issue

 

Are YOU using the this excel file as work around for not having the credentials to the SQL Server?

 

  • WorkingRicardo's avatar
    WorkingRicardo
    New Member
    1 year ago

    mermanahan hey ty for your reply!
    1) I'm using an Excel table to populate various comboboxes throughout different Apps. So, it is a file that everybody has to have acces to it. 
    This excel file is sourcing its data from the SQL, set to auto-update every 3 mins. I have my colleague with credentials open the file everyday and leaving it open and it does auto-update for them, however this changes are not being uploaded to the collective Excel file (I can't see them). 
    Therefore, all my users are missing data in their comboboxes. 

    2), Yes, its a workaround. I guess if I had credentials I could make a PowerAutomate flow to update changes automatically to the Excel file. Considering I need everyone having access to the source, I'd still need that Excel file.