Forum Discussion
Connecting sheets that are shared?
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 do...
JEllsworth ,,,
There are two possibilities,
- From Review tab, in the Changes group, click the Share Workbook button.
- The Share Workbook dialog box will appear,
- Select the Allow changes by more than one user at the same time. This also allows workbook merging check box on the Editing tab.
- Optionally, switch to the Advanced tab, then select the desired settings for tracking changes, and click OK.
- Save you Excel file to a network location where other people can access it.
Second is,,
- Make copy of Master file, and share over the cloud, ONE Drive or Google Drive.
- Collect after are been edited.
- Compare files and if required merge them.