| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Message when I open Workbook
I have a Workbook with many sheets. I create 5 Pivot Table for different
reports. All sheets are protected and the user click on buttons to refresh the Pivot table. No problem there. The problem occur each time I open the Workbook and I see this message: "That command cannot be performed while protected sheet contains another PivotTable report bases on the same source Data." How can I bypass this message? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message when I open Workbook
Tools Protection Unprotect Sheet or Unprotect Workbook.
You will need the password; hope you have it. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Mouimet" wrote: I have a Workbook with many sheets. I create 5 Pivot Table for different reports. All sheets are protected and the user click on buttons to refresh the Pivot table. No problem there. The problem occur each time I open the Workbook and I see this message: "That command cannot be performed while protected sheet contains another PivotTable report bases on the same source Data." How can I bypass this message? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message when I open Workbook
Hi
Sorry,this is not what I need I do not want to unprotect the sheets. The sheets need to be protected all time. This is why I add a button "REFRESH" in each Pivot table. I do not want the user to work on a unprotect sheet. What I need is how to bypass the error message when we open the Workbook. Thanks "ryguy7272" wrote: Tools Protection Unprotect Sheet or Unprotect Workbook. You will need the password; hope you have it. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Mouimet" wrote: I have a Workbook with many sheets. I create 5 Pivot Table for different reports. All sheets are protected and the user click on buttons to refresh the Pivot table. No problem there. The problem occur each time I open the Workbook and I see this message: "That command cannot be performed while protected sheet contains another PivotTable report bases on the same source Data." How can I bypass this message? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting error message when trying to open Excel | Excel Discussion (Misc queries) | |||
| Error message on open | Excel Discussion (Misc queries) | |||
| After File Open View Preview get error message | Excel Discussion (Misc queries) | |||
| can i have a pop up reminder message when i open a workbook? | New Users to Excel | |||
| File won't open. Error message "too many different cell formats" | Excel Worksheet Functions | |||
Linear Mode
