| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked File Calcuation req. source file to be open
Unless I have a linked file open it is not giving me the correct result. Even when I refresh or update values, it is still incorrect, I have to have the source file open. Can you please help as it is driving me insane and I am very worried I will send something out that is very very wrong! I am using Excel 2003, -- smcd ------------------------------------------------------------------------ smcd's Profile: http://www.excelforum.com/member.php...o&userid=33625 View this thread: http://www.excelforum.com/showthread...hreadid=533982 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked File Calcuation req. source file to be open
If you can avoid it, then avoid linked files. Better to have one large file than 3 linked ones. What formulae are you using? =indirect() only works on opened files Is your linked file (son) also linked to another file (grandson)? If so then you need to update these source links (as well as any earlier links) before updating the final links. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=533982 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| disabling linked object before you open a file | Excel Discussion (Misc queries) | |||
| Trying to open file, may have renamed it | Excel Discussion (Misc queries) | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
| XL2003 Destination and Source Open but not updating | Excel Discussion (Misc queries) | |||
Linear Mode
