Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Linking files on One Drive

Posted on 2016-09-02
2
Medium Priority
?
100 Views
Last Modified: 2016-09-17
If I have a file pulling in links from other files (let's call them child files)  let's call it the Master File...can I put the Masterfile on One Drive, password protect it and have (a) changes made to the master file reflected on the child files automatically? What do I need to look out for? Thanks
0
Comment
Question by:agwalsh
2 Comments
 
LVL 34

Accepted Solution

by:
Rob Henson earned 2000 total points
ID: 41781324
The way I interpret your question the link is in the Master File PULLING information FROM the Child File.

If that is the case changes to the Master File will not be reflected in the Child File

However, changes in the Child File will be reflected in the Master File if the changes are to the information which is linked.

If however, your child file also has a link pulling from the master file then changes to the master file will affect all child files that have the link.

The way I understand how OneDrive works is that you will effectively work on a local copy of the file which will then synchronise with the OneDrive copy, assuming it is in the OneDrive folder on the local PC.
0
 

Author Closing Comment

by:agwalsh
ID: 41802935
It's still a work in progress to be honest..but you've given me great pointers as to where to work through the issues. Thank you :-)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

916 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