Pivot Table Refresh option not able to see

G

Guest

Hi,

I have a workbook where sheet1 contains data having various columns. Sheet2
contains the pivot table from the sheet1.

Iam able to refresh the data in the Pivot table for the first time, but
one's Iam done and open the workbook the next day, I do not see the refresh
option by right clicking the pivot table.

Please note Iam using 2003, also the sheet1 is protected while the sheet2
which has the pivot table is unprotected.

I want to make the sheet1 protected as it is used by many people.

Your timely help will be highly appreciated.

Thanks,
Prashanth KR.
 
R

Roger Govier

Hi

Having the source data on a protected sheet is fine, as long as the sheet
with the PT is unprotected, and provided that a copy of the PT does not
exist on a protected sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table reorganizes when it shouldnt! 3
Pivot Table Macro 1
Error Message when I open Workbook 1
Refresh order when refreshing all in a workbook 1
Pivot Table Refresh Not Updating Drop Down List 1
Create refresh button in worksheet to refresh Pivot Table Data 1
How to clear data in pivot table? 4
Creating pivot table to Existing worksheet 1

Top