Excel users workbooks, how to link over the web?

hueknight1969

Hi



I know it's possible to pastelink cells between separate workbooks on the same drive or network. But is it possible to achieve the same on 2 separate workbooks on 2 separate PCs over the internet?



I looked at OneDrive but it doesn't update "live" (some cells do and don't) !!!


Tia



Hue

Neil_Jones

In theory probably yes, in reality probably no.

Both PCs would have to be fully accessible from the internet, possibly with their shared drives fully accessible too depending on the location of the files in question. Which from a security point of view is a stupid thing to do.

This might be a better idea if you have access to some webspace:
https://www.octoparse.com/blog/scraping-data-from-website-to-excel

Of course this won't 100% do what you want but at least it can be one way, assuming the other computer is work and yours is home.

Heedtheadvice

Maybe files on a shared drive run under Google's G Suite?
The workbooks being files on the cloud drive.


Have a look at https://gsuite.google.com/intl/en_uk/features
Not used it myself but looks like it is designed for the job.

bengalknights

If you upload them to a shared one drive folder or to sharepoint that is accesible then it does work.

Gers

When I was using Onedrive for work information in a cell wouldn't save unless you click out of it before closing. Just putting in something and then closing didn't work, even if 'save' was selected.

I have no idea if this was a problem specific to my organisation or not, so it's just my experience.