Hi,
I have a Workbook(1) link to another workbook(2) to retrieve and update names.
In the workbook(1)
I have 6 Pivot tables related to the same Data source
I have also GetPivotdata formula in another sheets.
I add buttons so the user just click to move from one page to another
updating the Pivot table and the getpivotdata at the same time.
Everything works fine.
The problem is when I try to open the file (What ever I select Update or
not) I have a message like this one:
"That command cannot be performed while a protected sheet contains another
PivotTable report bases on the same source data."

How can I remove this error message and update my names and Pivot table?
Thanks for your help