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