ExcelBanter - Pivot table data source

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table data source (https://www.excelbanter.com/excel-discussion-misc-queries/220326-pivot-table-data-source.html)

gordonrss

Pivot table data source

Is it possible to use a range from a saved file as a pivot table data source
as you can with a link, or is it necessary for the file containing the source
range to be open in order to refresh the table? I'm using Excel 2003.
--
Take care,
Gordon

All times are GMT +1. The time now is 01:21 AM.