Pivot Source - Update source via cell reference?

[djredden73]

I have a Pivot Table that pulls data in from a Microsoft Access table. The Access DB itself resides on my local drive (right now). In the future the Database as well as the Excel file will be transferred many different places, network drive folder, other user's local drives. My question is: Is there a way to force the user who may not have Excel skills to know where to change the Source like I do to put the folder location of the database (filename will not change) in a cell and have the Pivot table update the reference accordingly?