Solved

A basic sharepoint Question

Posted on 2014-02-18
1
155 Views
Last Modified: 2014-07-03
Hi - this is a really basic sharepoint question. I'm thinking of sharing an excel document between a number of my users.

one will be the master copy and others will have a read only version.

The functionality I want it to have is when the master copy is updated, the changes are passed through automatically to the read only copies.

Is this possible, and if so what is the refresh rate?

Thanks
0
Comment
Question by:andygrove7269
1 Comment
 
LVL 37

Accepted Solution

by:
Bing CISM / CISSP earned 500 total points
Comment Utility
By using SharePoint's content management features, you can do the same thing without dealing with the master copy and other copies. It uses Check In and Check Out mechanism to make document content consistent among all users.

Basically, there is only one copy per version kept on the server, only one person is allowed to check out the document (master copy in your words) for editing the content, the other users are allows to read-only the document (old content) while the document has been checked out. Once the editor finished reviewing the document, s/he checks in the document so the changes will be made in the original document (master copy), all other users will see the updated version accordingly.

FYI

http://office.microsoft.com/en-au/excel-help/check-a-file-in-or-out-of-a-sharepoint-library-HA010131479.aspx
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now