Refresh Query in Excel by Unauthorized Users 1

[lesleycampbell]

I am working in Excel 2010 with a SQL query. The spreadsheet will be shared with individuals that do not have permissions to SQL, but they will need to refresh the query. Is there anyway to work around this to allow them to refresh the query?

 

[kjv1611]

To my knowledge, that can only be done by storing a SQL Account that has permissions within the connection (not very safe) or granting permissions to those users to be able to refresh the sheet. Where I work, if the folks need access to the data, we generally get SQL permissions updated so they are able to refresh the data.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

YOU refresh the query in a publically accessible location. It can be done in a defined schedule, hands off.

Then change the users' application to query YOUR workbook/table.

 

[kjv1611]

Yeah, I didn't think about that method. That would work, but of course it'll require you (OP) to refresh the data every day. Not a big deal, necessarily, and could be automated on your end, but still not super ideal.

There are other options on the SQL side, but I'll not try to get into all that, b/c you may or may not have permissions to do so. I know our permissions are often pretty limited unless dbas and such.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[lesleycampbell]

Thank you! How do I do I schedule the refresh where I don't have to do it manually?

 

[SkipVought]

Set the Refresh on Open option and schedule the workbook to open via the Windows Scheduler.