Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I link information from a large table into new table | Excel Worksheet Functions | |||
How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Link Access table to Excel worksheet | Excel Discussion (Misc queries) | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |