Forum Discussion
Other users can't refresh my Excel Workbook
Hi and thanks in advance for any assistance.
A colleague has a workbook which is in a document library in SharePoint. She has it protected due to the formulas in it. It is pulling data from another workbook that has client details in it.
Problem: Refresh all is working for her but other users are not able to refresh data.
Any assistance would be appreciated.
Cdstrev Please check you workbook connection string. You wont' be able to refresh if it is pulling client details data from local machine (say, desktop of your colleague).
I hope this helps, have a nice day!
- SanthoshKunder thank you. Could you explain how to check you workbook connection string?
- You can see it under the 'data' tab. Click on the properties option to see the connection string properties
