Built a macro to create a pivot table but I want the user to be able to
select the file from any location and use that as the Data Source. Filename
will remain constant. I have tried GetOpenFilename and FileDialog w/o
success.

Any advice would be greatly appreciated.