Excel Pivot Table Refresh Macro

Job ID: 40549138

Budget: $10 – $40 USD

I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected.

Requirements:
- Refresh the pivot table:
- Automatically when the workbook is opened.
- Whenever the data is updated.
- Compatible with Excel 365.
- Must work while the worksheet is protected.

Ideal Skills and Experience:
- Proficiency in Excel VBA.
- Experience with pivot tables and workbook protection.
- Familiarity with Excel 365 features.