Forum Discussion
is there a way that we can refresh a pivot table or external data connections on a protected sheet?
is there a way that we can refresh a pivot table or external data connections on a protected sheet?
Yeah, I was just seeing if there is a solution without using VBA. Nevertheless, thank you and you answered my question. :)
Only by using a bit of VBA code I'm afraid.
Yeah, I was just seeing if there is a solution without using VBA. Nevertheless, thank you and you answered my question. :)
- I believe the solution is to create a macro that includes the code to refresh the Pivot Table. I have added "Developer" to my Excel ribbon which allows one to select VBA settings where you can insert pivot table code. I now looking for the pivot table code to use. If anyone has this code please let me know. I hope this helps,
