Connecting sheets that are shared?

%3CLINGO-SUB%20id%3D%22lingo-sub-1939108%22%20slang%3D%22en-US%22%3EConnecting%20sheets%20that%20are%20shared%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939108%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20share%20a%20file%20that%20someone%20is%20forced%20to%20make%20a%20copy%20of%20and%20still%20pull%20data%20to%20a%20master%20sheet%3F%20I%20have%20a%20data-tracker%20that%20I%20want%20to%20share%20with%20some%20students.%20They%20will%20be%20forced%20to%20download%20a%20copy%20of%20the%20file%20to%20fill%20in%20their%20own%20data.%20Is%20there%20a%20way%20I%20can%20still%20pull%20data%20from%20the%20new%20files%20that%20are%20created%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1939108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1939406%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20sheets%20that%20are%20shared%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F885041%22%20target%3D%22_blank%22%3E%40JEllsworth%3C%2FA%3E%26nbsp%3B%2C%2C%2C%3C%2FP%3E%3CP%3EThere%20are%20two%20possibilities%2C%3C%2FP%3E%3COL%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3EFrom%26nbsp%3B%3C%2FSPAN%3EReview%3CSPAN%3E%26nbsp%3Btab%2C%20in%20the%26nbsp%3B%3C%2FSPAN%3EChanges%3CSPAN%3E%26nbsp%3Bgroup%2C%20click%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EShare%20Workbook%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bbutton.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3EThe%26nbsp%3B%3C%2FSPAN%3EShare%20Workbook%3CSPAN%3E%26nbsp%3Bdialog%20box%20will%20appear%2C%20%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3ESelect%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAllow%20changes%20by%20more%20than%20one%20user%20at%20the%20same%20time.%20This%20also%20allows%20workbook%20merging%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bcheck%20box%20on%20the%26nbsp%3B%3C%2FSPAN%3EEditing%3CSPAN%3E%26nbsp%3Btab.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3EOptionally%2C%20switch%20to%20the%26nbsp%3BAdvanced%26nbsp%3Btab%2C%20then%20select%20the%20desired%20settings%20for%20tracking%20changes%2C%20and%20click%26nbsp%3BOK.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3CLI%3E%3CFONT%20size%3D%223%22%3E%3CSPAN%3ESave%20you%20Excel%20file%20to%20a%20network%20location%20where%20other%20people%20can%20access%20it.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%20is%2C%2C%3C%2FP%3E%3COL%3E%3CLI%3EMake%20copy%20of%20Master%20file%2C%20and%20share%20over%20the%20cloud%2C%20ONE%20Drive%20or%20Google%20Drive.%3C%2FLI%3E%3CLI%3ECollect%20after%20are%20been%20edited.%3C%2FLI%3E%3CLI%3ECompare%20files%20and%20if%20required%20merge%20them.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is it possible to share a file that someone is forced to make a copy of and still pull data to a master sheet? I have a data-tracker that I want to share with some students. They will be forced to download a copy of the file to fill in their own data. Is there a way I can still pull data from the new files that are created?

1 Reply

@JEllsworth ,,,

There are two possibilities,

  1. From Review tab, in the Changes group, click the Share Workbook button.
  2. The Share Workbook dialog box will appear,
  3. Select the Allow changes by more than one user at the same time. This also allows workbook merging check box on the Editing tab.
  4. Optionally, switch to the Advanced tab, then select the desired settings for tracking changes, and click OK.
  5. Save you Excel file to a network location where other people can access it.

 

Second is,,

  1. Make copy of Master file, and share over the cloud, ONE Drive or Google Drive.
  2. Collect after are been edited.
  3. Compare files and if required merge them.