| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
links to a second workbook doesn't work if origin not open
I have some links from one workbook to another, but when I open only the
destination workbook the link shows #value! error. If I then open the origin, the link does show the proper value. If I close the origin, the link keeps the values in destination just during that "session" if I close the workbook and open again I will need to open the origin as well. Why the link doesn't keep the values as it should? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
links to a second workbook doesn't work if origin not open
*Actual links* will work on open and/or closed WBs, so I'm assuming that
you're talking about formulas that reference other WBs. Certain functions *do not* work on closed files, such as Sumif(), Countif(0, and Indirect(), among others. Post back with the formulas you're trying to use, and we'll see about helping with work-around formulas. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gerardo" wrote in message ... I have some links from one workbook to another, but when I open only the destination workbook the link shows #value! error. If I then open the origin, the link does show the proper value. If I close the origin, the link keeps the values in destination just during that "session" if I close the workbook and open again I will need to open the origin as well. Why the link doesn't keep the values as it should? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
links to a second workbook doesn't work if origin not open
Thank you, that is actually the case, I have a sumif() with the conditions in
the workbook that contains the formula and the values to be added coming from a second workbook. So maybe I should link to those cells in the second workbook and then use the formula with all the parameters within the same workbook right? Regards "RagDyer" wrote: *Actual links* will work on open and/or closed WBs, so I'm assuming that you're talking about formulas that reference other WBs. Certain functions *do not* work on closed files, such as Sumif(), Countif(0, and Indirect(), among others. Post back with the formulas you're trying to use, and we'll see about helping with work-around formulas. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gerardo" wrote in message ... I have some links from one workbook to another, but when I open only the destination workbook the link shows #value! error. If I then open the origin, the link does show the proper value. If I close the origin, the link keeps the values in destination just during that "session" if I close the workbook and open again I will need to open the origin as well. Why the link doesn't keep the values as it should? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
links to a second workbook doesn't work if origin not open
You can do it that way.
If you like, an array formula using a combination of Sum() and If(), OR, a Sumproduct() formula, would probably do the job in one shot. Care to post some of your formulas to see what can be worked out? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Gerardo" wrote in message ... Thank you, that is actually the case, I have a sumif() with the conditions in the workbook that contains the formula and the values to be added coming from a second workbook. So maybe I should link to those cells in the second workbook and then use the formula with all the parameters within the same workbook right? Regards "RagDyer" wrote: *Actual links* will work on open and/or closed WBs, so I'm assuming that you're talking about formulas that reference other WBs. Certain functions *do not* work on closed files, such as Sumif(), Countif(0, and Indirect(), among others. Post back with the formulas you're trying to use, and we'll see about helping with work-around formulas. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gerardo" wrote in message ... I have some links from one workbook to another, but when I open only the destination workbook the link shows #value! error. If I then open the origin, the link does show the proper value. If I close the origin, the link keeps the values in destination just during that "session" if I close the workbook and open again I will need to open the origin as well. Why the link doesn't keep the values as it should? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links work in one workbook, not in another | Excel Discussion (Misc queries) | |||
| My links to another workbook don't work | Excel Discussion (Misc queries) | |||
| links within excel don't work when workbook is e-mailed - why ? | Excel Discussion (Misc queries) | |||
| Links only update when external workbook is open | Excel Worksheet Functions | |||
| inter workbook links do not update even when both are open ??? | Excel Discussion (Misc queries) | |||
Linear Mode
