Excel query

  Marko797 19:49 19 Jan 2011
Locked

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment utiliser Live Photos ?