Excel query

  Marko797 19:49 19 Jan 11

I have 2 spreadsheets in excel, being used as a database essentially, with many rows of text entries, & filtered columns, etc.

One is kept on the shared drive of the network, and is amended/adjusted as a working copy of a day to day database.

The other, kept on sharepoint, accessed via the same network, as a master version of the other shared drive version.

Rather than keep replacing the sharepoint version with the shared drive version (via copy & paste), is there a way of auto updating/synchronising the sharepoint version with the changes made to the shared drive version?

I suppose I could just replace the sharepoint version daily, but was hoping just the changes could be updated/synchronised automatically, or at the click of a button.

I can't introduce additional synchro-software owing to IT policy, so that's a no-go.

Hope this isn't too confusing or ridiculous an idea. Thanks,

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

Best Mac antivirus 2017