Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
Hi friends,
I have a small problem with pivot table - When ever i create a copy of a sheet containing the pivot, the pivot range in the new sheet will be for old sheet cells. is it possible to overcome this, meaning is it possible to make the range as activesheet name automically. Thanks Thyag |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table
i have half a solution for you. but not the whole caboodle.
your pivot table is on the same sheet as your data. if you make your data a named range (insertnamedefine) and then set up your pivot table source to be this named range, when you copy a sheet you will find that the named range has copied too. depending on which sheet you are on, the named range applies to that sheet so if you change a value in one sheet, and refresh the pt from that sheet, it will find the new data sadly the pt on the orignal sheet changes at the same time. interesting. i only have ten minutes and couldn't get to the end o fthis -- Allllen "Thyag" wrote: Hi friends, I have a small problem with pivot table - When ever i create a copy of a sheet containing the pivot, the pivot range in the new sheet will be for old sheet cells. is it possible to overcome this, meaning is it possible to make the range as activesheet name automically. Thanks Thyag |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |