| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table inquiry
Hi,
in one workbook, i have one main sheet with compiled data of only 400 rows and 60 columns (approx.) No blank cells... then on 12 sheets i got pivot tables for different summary presentation... then on 6 sheets i got charts linked to the pivot table summary data... i'd like to freeze or let say protect only the the 12 sheets-pivot tables to disable selection.... Please recommend a macro to disable pivot table selection, while being also able to update by inserting another rows of data on my main data sheet... any suggestions are welcome regards... -- ***** birds of the same feather flock together.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Threaded Mode
