The_excell_initiate
New member
- Joined
- Nov 24, 2015
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013, 2016
Hey Everyone,
Many painfull hours I realized my data connection was being made in temporary internet files.
The set up is the following :
File A : data
File B: Pivot
File A is on a sharepoint and File B is on a local system and hopefully in the future on a SP as well.
File A is constantly open and being changed.
Is it possible to build a pivot table in file B with a permanent connection to File so I can update data as live as possible , without opening File A ???
As always appreciate the help !!!
Many painfull hours I realized my data connection was being made in temporary internet files.
The set up is the following :
File A : data
File B: Pivot
File A is on a sharepoint and File B is on a local system and hopefully in the future on a SP as well.
File A is constantly open and being changed.
Is it possible to build a pivot table in file B with a permanent connection to File so I can update data as live as possible , without opening File A ???
As always appreciate the help !!!