Hi,
Hoping someone might guide / help me with something that google can’t help me with.
I tried to search the forums but I can not find anyone posting the same or similar question.
I have created a document by exporting a lot of data and compiling it in a sort of “master” document.
That document hold all information that I want to use in other “child” documents.
Every “child” document got its own tab in my “master” document.
An example would be that “Child 1” gets its data from “Master” document, tab 1.
“Child” document only consisting of pivots and charts, and they get there information from my “master” document by using external data sourc and picking my “master” Excel file.
When opening “master” the options show as to what tab I would like to use and I pick the correct one.
I have to create about 15 different “child” documents that are to show different pivots and charts.
All “childs” have auto update when opening document ticked.
I am now faced with a challenge I did not think was an issue, most likely due to lack of knowledge.
I want to have my “master” document on my own PC and be able to update all documents that I need to place in MS Teams.
The pivot connections seemed to be broken du to moving documents created on my PC to Teams, so I changed the data source of all child’s documents when placed on teams, to “master document” on my own PC.
Next issue that occurred (I should have know that) is that they do not have access to my PC, so I put in my password in all excel documents. That did not fix my issue.
So my question –
Is there any way to have documents on MS Teams that is auto updated when I update my master document?
Should I maybe rethink this and approach this differently and not use Excel to handle this type of a task with master – child documents? (pros/Cons?)
Would it be better to use macros to grab information instead?
Thanks in advance.
Bookmarks