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. |
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. |
All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com