I have a master document that grabs data for it's pivot tables from one external file and grabs data from another file directly. When I load up the master document everything it's referencing from external files shows #REF. If I load up the documents it works fine.
How do I make this work without having to load the other documents?
Once that works... How do I make it so people who open the document and don't have access to the external documents see what was last saved?