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?
|