Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Refresh option not able to see
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Refresh option not able to see
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. -- Regards Roger Govier "Prashanth KR" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
Refresh a Pivot Table | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Pivot Table Refresh | Excel Discussion (Misc queries) | |||
refresh option of pivot table not working | Excel Worksheet Functions |