Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to Pivot data in another worksheet
Hi,
I use dynamic name ranges within the same worksheet to refer to pivot tables. I love this tool as it saves me loads of time. However, I now want to create a dynamic reference to pivot data in a different worksheet. I've found that you can create a named range that links to another worksheet, however if you try to use this as a data source for a pivot table it doesn't work ("Reference not valid"). Has anyone got a work around for this, or am I resigned to a static external reference? RA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |