Forum Discussion
Cdstrev
Sep 26, 2023Copper Contributor
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...
SanthoshKunder
Sep 26, 2023Iron Contributor
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!
- CdstrevSep 28, 2023Copper ContributorSanthoshKunder thank you. Could you explain how to check you workbook connection string?
- SanthoshKunderSep 28, 2023Iron ContributorYou can see it under the 'data' tab. Click on the properties option to see the connection string properties
- CdstrevOct 12, 2023Copper Contributor