Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating links in Excel 2002
Hi,
I'm trying to create links between two or more files such that when a file (destination) is opened, some of its cell values would be updated from its source file(s). So far, I've tried using "Import External Data -import data" feature and sucessfully linked the source and destination files. The destination file will be refreshed each time I selected to update links when the file is opened. However, I could not associate the destination file with more than one source file. Also, how could I just select certain cells in the source file for updates ? I've tried creating "Names" under the Insert menu but to no avail. This is to update the destination file by linking the name of the field in the source file so that we could just refresh the destination file when there's new or changed data . Does anyone have any idea ? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Links on Excel | Excel Discussion (Misc queries) | |||
updating links in Excel | Excel Discussion (Misc queries) | |||
Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
Updating Links to Other Excel Files | Excel Worksheet Functions | |||
not updating links in excel 2003 | Excel Worksheet Functions |