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 ano...
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
- You should have write access to the file stored on the SharePoint. Please check your level of access.
Thank you. This doesn't appear to be the issue.