Forum Discussion

Alexa Chomat's avatar
Alexa Chomat
Copper Contributor
Jul 11, 2017

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!

 

Resources