Hi All,

I created a Pivot Table based on data source from another Excel file.

The PivotTable Data Source is as follows:

'\Users\Lior\Dropbox\DailyForex Reports\2013\2013 Income_Visits_Clicks - Yaron.xlsx'!VisitsClicksData

The problem is that the data source has my windows username in it (Lior) so others can't use this file.

Is there a way making a dynamic data source according to Windows logged in user?
Is there a way using %USERPROFILE% instead of \User\Lior in the data source?

Thanks,
Lior