Hi There
I couldn't find any reference to this issue so I'm posting and I really hope one of you clever people out there have experienced this issue?
At work, myself and the team use a shared drive (G) to save our work files. The team folder has 10 team member files in it and each team member is working on their own standard spreadsheet.
The standard spreadsheet has a "results" tab and that tab contains a table - standard size.
What I am trying to do is link with each team member's results table and pull the data into the master sheet to give me a real time update on how the team's work is progressing.
I can easily get this to work when I open both a Team Member Spreadsheet and My Own Master List at my own PC - the link is instantaneous. But when one of the team members open the exact spreadsheet I was working on (from their own PC), the link does not work at all.
The IT guys seem to think that the network isn't creating a firewall and as all the files are in the same folder, there shouldn't be any network related issues (but I am not sure if this is true).
Is there anything obvious I am missing here as my research into the issue has drawn a blank!
I hope the above makes sense?
Kind regards
Mike
I couldn't find any reference to this issue so I'm posting and I really hope one of you clever people out there have experienced this issue?
At work, myself and the team use a shared drive (G) to save our work files. The team folder has 10 team member files in it and each team member is working on their own standard spreadsheet.
The standard spreadsheet has a "results" tab and that tab contains a table - standard size.
What I am trying to do is link with each team member's results table and pull the data into the master sheet to give me a real time update on how the team's work is progressing.
I can easily get this to work when I open both a Team Member Spreadsheet and My Own Master List at my own PC - the link is instantaneous. But when one of the team members open the exact spreadsheet I was working on (from their own PC), the link does not work at all.
The IT guys seem to think that the network isn't creating a firewall and as all the files are in the same folder, there shouldn't be any network related issues (but I am not sure if this is true).
Is there anything obvious I am missing here as my research into the issue has drawn a blank!
I hope the above makes sense?
Kind regards
Mike
