| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup: file moved or new one. keep cache
i have vlookup formula to external file, but what if that file moved or
renamed?? how to keep vlookup to find what i need?? there is formula extra properties?? and is it possible to keep data once received? some cache, i mean if i have some table full already, all needed data is taken from other file, do not update this table any more. there is any better alternative to this formula + changes above? =VLOOKUP(K29;'C:\Data.xls]Data'!$A$5:$Z$568;12;FALSE) thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a cell even if its contents are moved moved/replaced | Excel Discussion (Misc queries) | |||
| Open hyperlinks when file is moved | Excel Programming | |||
| Someone moved my linked file | Excel Worksheet Functions | |||
| A repost: Automatic file opening procedure seeming to hold cache | Excel Programming | |||
| Automatic file opening procedure seeming to hold cache | Excel Programming | |||
Threaded Mode
