Problem:

Question 1: How to refresh Pivot table on protected sheet?

Question 2: How does dynamic programming make an inefficient recursive algorithm more efficient?

A: By keeping track of previously computed recursive calls, and using the stored values when possible instead of initiating redundant recursive calls

B: By using arrays, which are inherently more efficient than recursion?

C: By dynamically changing the order in which multiple recursive calls are performed, thereby eliminating redundant recursive calls.

D: By replacing the recursion with iteration, which is inherently more efficient.

Please help me to know h How to refresh Pivot table on protected sheet.