Shall we refresh pivote table data in protected sheet
D Debra Dalgleish Jul 11, 2009 #2 No, you can't refresh the pivot table while the worksheet is protected. You could record a macro to unprotect the worksheet, refresh the pivot table, then protect the worksheet.
No, you can't refresh the pivot table while the worksheet is protected. You could record a macro to unprotect the worksheet, refresh the pivot table, then protect the worksheet.
S Sumanthkaka Jul 13, 2009 #3 Thanks a lot... Can i get the details how can we record the macro's what was the code for refresh the pivot table date.....!
Thanks a lot... Can i get the details how can we record the macro's what was the code for refresh the pivot table date.....!
D Debra Dalgleish Jul 16, 2009 #4 What version of Excel are you using? Thanks a lot... Can i get the details how can we record the macro's what was the code for refresh the pivot table date.....! : Click to expand...
What version of Excel are you using? Thanks a lot... Can i get the details how can we record the macro's what was the code for refresh the pivot table date.....! : Click to expand...
