pivot table data range

Giganews Newsgroups
Subject: pivot table data range
Posted by:  dawn.hort…@peoples.com (anonymo…@discussions.microsoft.com)
Date: Wed, 15 Oct 2003

I am creating a pivot table in one excel file and pulling
the data source from another excel file. The problem is
the name of the data source file changes every month to
coordinate with the new reporting month. For an example,
the name goes from this: datasource 403.xls, to this:
datasource 503.xls. How can I enter the range name of this
file without manually changing the date in the range? Can
I use a cell reference in the name range, which I have
tried unsuccessfully?