| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links Don't Update When Using Certain Functions
I have noticed that formulas containing MATCH, INDEX functions which reference external spreadsheets do not update unless the source is open. This doesn't seem to be the case with VLOOKUP though. Has anyone else found this? Know why it happens? Know anyway round it? Regards Ben -- blatham ------------------------------------------------------------------------ blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441 View this thread: http://www.excelforum.com/showthread...hreadid=530390 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
External Links Don't Update When Using Certain Functions
Is it a simple =index(match()) formula?
Or do you use other functions in your formula. =indirect(), =sumif(), =countif() (for example) won't work with closed workbooks. blatham wrote: I have noticed that formulas containing MATCH, INDEX functions which reference external spreadsheets do not update unless the source is open. This doesn't seem to be the case with VLOOKUP though. Has anyone else found this? Know why it happens? Know anyway round it? Regards Ben -- blatham ------------------------------------------------------------------------ blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441 View this thread: http://www.excelforum.com/showthread...hreadid=530390 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| options to update automatic links | Excel Worksheet Functions | |||
| Links only update when external workbook is open | Excel Worksheet Functions | |||
| Prompt to update links | Links and Linking in Excel | |||
| Update links prompt not wanted | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
