Forum Discussion
Alexa Chomat
Jul 11, 2017Copper Contributor
Connecting Workbooks on Mac
Hi all,
I'm on the Mac version of Excel 2016 and am wondering how to connect two workbooks (as in link a complete sheet to another workbook, not just referencing specific cells), because the instructions on the Office Support site don't seem to match what I'm seeing.
I don't have any option under my Data tab for “From File>From Workbook," and the only new query it'll allow me to select is a database, which isn't what I'm looking for.
Also, once they are linked, if the files were to be housed in a cloud system (e.g. Google Drive), would the connections remain synced if multiple people are editing the files?
If anyone has successfully done this, please let me know—thanks!
- Martin WohlwendCopper ContributorI'm facing the same issue.
- Philippe POUMAERECopper Contributor
Idem for me !