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.