| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#value! in linked document
Hi there, is there any way to automatically update linked documents without
opening the source document? When I leave them closed, my main worksheet shows #VALUE! in the cell, but when I open the source documents, the value is displayed. Not sure if this can be helped, but I thought I'd ask -- Thanks for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value! in linked document
It sounds like you are using the INDIRECT function, otherwise this should
not be a problem. If you are, I'm afraid INDIRECT requires the source document to be open. -- Best Regards, Luke M "TamIam" wrote in message ... Hi there, is there any way to automatically update linked documents without opening the source document? When I leave them closed, my main worksheet shows #VALUE! in the cell, but when I open the source documents, the value is displayed. Not sure if this can be helped, but I thought I'd ask -- Thanks for your help! |
|
#3
|
|||
|
|||
|
Quote:
sorry for the intervene, when the source is not opened, indirect throws #REF error not #value
__________________
Thanks Bala |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value! in linked document
Hi,
You are using one of the following 5 functions (which do not work when the source workbook is closed) - INDIRECT(), OFFSET(), GETPIVOTDATA(), SUMIF() or COUNTIF(). Please check which of these formulas are you using. If you are using SUMIF() and COUNTIF(), the we can solve the problem by using the SUMPRODUCT() instead (which can work even if the source workbook is closed) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "TamIam" wrote in message ... Hi there, is there any way to automatically update linked documents without opening the source document? When I leave them closed, my main worksheet shows #VALUE! in the cell, but when I open the source documents, the value is displayed. Not sure if this can be helped, but I thought I'd ask -- Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked excel tables in word document | Excel Discussion (Misc queries) | |||
| Excel spreadsheet linked into a word doc a compound document? | Excel Discussion (Misc queries) | |||
| linked cells in excel on a shared document | Excel Discussion (Misc queries) | |||
| Updating Linked Excel Document | Excel Worksheet Functions | |||
| Problems Printing a Linked Word document | Excel Discussion (Misc queries) | |||
Linear Mode
