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!
