Protected Pivot Table Error on Open

I have a workbook with the following macros:

The First macro password protects every sheet when the workbook is closed.

Please Login or Register  to view this content.

The second macro allows a user to unprotect all sheets at once.

Please Login or Register  to view this content.

I'm in Excel 2007. For every worksheet that has a pivot table, I receive a messagebox that says "Cannot edit PivotTable on protected sheet." when I open the workbook.

What's the best way to deal with this error?

I understand this has to do with the refresh on open feature of pivot tables.

Is there a way to unprotect, refresh, then reprotect?

The only way I can think of is to turn off the refresh on open feature and then call each pivot table to refresh, which would be fine except that there will likely be new pivot tables created and they'll default in with the refresh on open checked.