• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Refresh with Sheet Protection

fareedexcel

Member
I have 11 excel files in One Drive.

Combined all those 11 excel file and made a master file with pivot table. On Every refresh, pivot table will get updated as per the change made in the 11 excel file.

I want to protect the master file sheet with a password but I'm getting error. Now the refresh is happening properly,

Code:
Sub Rectangle4_Click()
Sheets("Occupancy").Select
ActiveSheet.PivotTables("PivotTable1").RefreshTable
MsgBox ("Data Refreshed!!")
End Sub
While trying to protect the file I'm getting error as per attachment. Even in the password protection properties I have clicked "Edit Pivot Tables".

May be when I'm trying to refresh the pivot table the error occurs because the pivot table is connected to Power Query and those 11 files in the power query were from One drive ??
 

Attachments

Top