Scheduling and Linking the Workbooks

[dglslewis1021616]

Currently I have created a schedule for a small group of people and want to link the 2 wookbooks. 1- master Schedule and 2 Employee schedule as read only that cannot be altered. Also changes need to be in real time, we have had some success but then after a few months the color and changes are not occuring.

[Don]

Hi and welcome to the forum!

There are lots of ways to 'link' workbooks. Can you be more specific with exactly what data you want to be linked between the worksheets and how you need that data to be linked?

Generally though, the easiest way to get data from one workbook to another (on a smaller scale at least) is to have both files open at the same time, go to one and start typing a formula, then select the desired cell from the other workbook and complete the formula in the first workbook.

[Sisyphus]

Hi,

The cure for formulas (or code?) that used to work and don't any more should be looked for in those formulas (or the code) or in the system changes made since inauguration. Basically, whatever system of linking you have, has worked once and should still work.

With regard to "real time" you may like to review your requirements:-
If an Employee copy is open you will have great difficulty updating it without the help of the user who is looking at it. If the Employee copy isn't open, why should you want to update it? So, "real time" means that the copy is updated when it is opened. However, if you are thinking of revampingyour system, you may like to look at the possibilities offered by file Sharing. All the problems that come with having linked copies disappear if there are no copies to update, and I'm sure there must be ways to restrict access to read-only on a shared workbook.

Have a great day!