F
Fambrius
Hello.
I have several pivot tables in an Excel-1 file. They all aquire the data
from another Excel-2 file where I have a List created, which enlarges
everytime I add more data to it.
I have created a dynamic name in Excel-2 as explained in
http://contextures.com/xlPivot01.html. I would like to use the name of the
data range in Excel-2 in the pivot tables as its source data in Excel-1.
Unfortunately, when I try to use that name as an external source for the
pivot tables, it doesn't appear.
Do you know how could I do that?
Maybe I could create some cell with the data range in Excel-2 and make the
pivot table aquire the range from that cell, but I don't know how can I make
the pivot table to aquire the content of a cell as the data range.
Any idea?
Thanks in advance.
I have several pivot tables in an Excel-1 file. They all aquire the data
from another Excel-2 file where I have a List created, which enlarges
everytime I add more data to it.
I have created a dynamic name in Excel-2 as explained in
http://contextures.com/xlPivot01.html. I would like to use the name of the
data range in Excel-2 in the pivot tables as its source data in Excel-1.
Unfortunately, when I try to use that name as an external source for the
pivot tables, it doesn't appear.
Do you know how could I do that?
Maybe I could create some cell with the data range in Excel-2 and make the
pivot table aquire the range from that cell, but I don't know how can I make
the pivot table to aquire the content of a cell as the data range.
Any idea?
Thanks in advance.