Hi
In my excel sheet i have made a Pivot.
Everytime when i change or copy teh file to a network source, the pivot takes it path automatically and in teh network it ask for password.
How can we make the pivot absolute to the same file?