I have a shared .xlsx file on my network that several users are pulling data from. Each user has their own pivot table that they pull the data to. When they try to refresh the data it attempts to refresh 2x and then fails and says it can't obtain a connection. When a user saves a local copy of the shared .xlsx, the connection works fine and they are able to refresh the data. Is there any way I can have the users refresh data from this shared file on the network drive without each saving a local copy? This is a massive file and would take a very long time for them to save a local copy to their computer.

Thanks all!