View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Is it possible to link a whole table into another worksheet

If the sheet is composed of the table you desire, on yoru other spreadsheet,
go to Data Import External Data Import Data

Change your files of type to Excel

Select your source file and spreadsheet and import it.

Once done, you can set the data to update on open or refresh whenever needed
by going back to Data

"Linda" wrote:

I need to link to a table in a separate worksheet (and later on, into a
separate workbook).

Can a table be linked so that every cell in that table is updated when the
original table is updated?