Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent refresh in certainpivot tables in workbook
Can I selectively freeze, and refresh multiple pivot tables on a
worksheet, based on the same source data? I didn't think so, but maybe someone has a good mousetrap to accomplish this. Pierre |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent refresh in certainpivot tables in workbook
Excel 2007
If multiple PTs have Table1 as a source, convert Table1 to a range and give the table range, including headers, multiple defined names, such as ArrayA, ArrayB, etc. Assign these names to the different PTs as data sources. This will also unlink the PTs for grouping purposes. After recreating Table1, the defined names will stay dynamic. In the Name Manager, edit the names to ArrayX, ArrayY, etc. When trying to refresh, "Reference not valid" will appear. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent refresh in certainpivot tables in workbook
On Mar 3, 1:15*pm, Herbert Seidenberg wrote:
Excel 2007 If multiple PTs have Table1 as a source, convert Table1 to a range and give the table range, including headers, multiple defined names, such as ArrayA, ArrayB, etc. Assign these names to the different PTs as data sources. This will also unlink the PTs for grouping purposes. After recreating Table1, the defined names will stay dynamic. In the Name Manager, edit the names to ArrayX, ArrayY, etc. When trying to refresh, "Reference not valid" will appear. Thats very clever. Thank you Herbert. I'll have a gander at it. Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh Pivot Tables with one hit | Excel Discussion (Misc queries) | |||
Automatic refresh of pivot tables | Excel Discussion (Misc queries) | |||
Cannot Refresh Pivot Tables | Excel Worksheet Functions | |||
Pivot Tables Refresh | Excel Discussion (Misc queries) | |||
Refresh all pivot tables in a workbook | Excel Discussion (Misc queries) |