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