Forum Discussion
Linking cells/sheets from different workbooks
rebeccap2021 Unfortunately, Power Query (aka Get & Transform) isn't available on Mac, but you can use direct cell links.
For example, with a source workbook open (one with data you want to link to), enter = in a cell in your destination workbook, switch to the source workbook, select the cell to link, and press enter. Excel will capture the file path/cell address for you. Note that it will return the link in Absolute form (=$A$1), so you'll want to remove the $'s, then you can copy/paste that formula wherever you want.
HTH
Smitty Smith thanks for this. Seems to be working, although I imagine it won't update if the source sheet is updated? Shame that the full functionality is not on the Mac version (hint?).
rebeccap2021 If both workbooks are open, then the values should update automatically. If they don't, you can always go to Data > Edit Links > Update.
But when I try to copy the original spread sheet my calculated values do not come through,
Can I copy a spread sheet into a linked page so that values when changed anywhere in the original spread sheet, they are automatically and newly reflected in the second spread sheet?Smitty Smith
BRusso26 Sure, go to Copy > Paste Special > Paste Link. You'll want to watch out for unnecessary blank cells, where you'll probably want to delete the links for overhead.
