| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Source
Hello I am trying to create a pivot table using data source from another
workbook . This source is a named range. I tried different ways but I'm unable to connect the two. Whenever I try to insert named range it goes to the current workbook and the name range does not appear. How ca I do this? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Source
Hi
When you get to the point asking for range, choose Browsenavigate to the Folder for the sourceclick on FilenameEnter Table name after the full path that has bee inserted in the dialogue pane. The source data can be Open or Closed. -- Regards Roger Govier "Wanna Learn" wrote in message ... Hello I am trying to create a pivot table using data source from another workbook . This source is a named range. I tried different ways but I'm unable to connect the two. Whenever I try to insert named range it goes to the current workbook and the name range does not appear. How ca I do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| Pivot Table Source | Excel Worksheet Functions | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Linear Mode
