Link a block of cells in from another workbook

Dan Holme

October 30, 2007

1 Min Read
ITPro Today logo in a gray background | ITPro Today
  1. Open both workbooks.

  2. Select the source cells.

  3. Right-click and choose Copy.

  4. Using the Window menu, switch to the destination workbook.

  5. Select the first destination cell.

  6. Right-click and choose Paste Special.

  7. Choose Paste Link.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like