Spreadsheet in two places

DavidOpenip

New Member
Joined
Dec 14, 2015
Messages
2
Hi,
Hopefully this hasn't been asked before and answered a million times before. And that I explain what I'm looking for well enough.
So, i have spreadsheet that I want to share and normally we put this in a shared drive that is accessible from two locations. However when at the third location, the spreadsheet is not accessible directly.
I was wondering if it is possible to link the spreadsheet at each of the location to the spreadsheet that is available from the central location.

E.g. Users 1 and 2 can access spreadsheet 1 when they are working in the office. If one of the users goes home they cannot access the central location when using VPN, however they can access a copy which is a 'mirror' of the central one. If they make any changes to their local copy, it will then be shown in the centrally accessible one AND the other users local copy which is also accessible from the central location.
Hopefully I explained that well enough..

 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,224,820
Messages
6,181,157
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top