Refresh pivot table on a protected worksheet

**DougieL** · 08-08-2012, 03:30 AM

I have this code:

Please Login or Register  to view this content.

When I open the worksheet the code fails with the error "Cannot edit pivot table on protected sheet". However if I put a breakpoint on the first line of the code and execute the remainder with the F5 or F8 key, it works without error. What's happening?

**Cutter** · 08-08-2012, 10:00 AM

@ DougieL

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**DougieL** · 08-09-2012, 02:10 AM

I solved this by going into 'Data'..'Connections', selecting the connection, opening 'Properties' and unchecking 'Enable background refresh'. Although why that works I have no idea.