| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links to other worksheet not updated or showing #VALUE!
I have a formula linking to another worksheet but it does not show the result
unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Unless you use an Add-In; these formulas will work only if all external data
sources are open. If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Errrm... where & how do i use the Add-in?
"Jacob Skaria" wrote: Unless you use an Add-In; these formulas will work only if all external data sources are open. If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Check out the below link...and download.
http://xcell05.free.fr/morefunc/english/index.htm If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: Errrm... where & how do i use the Add-in? "Jacob Skaria" wrote: Unless you use an Add-In; these formulas will work only if all external data sources are open. If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Unable to download from site. Any other options?
"Jacob Skaria" wrote: Check out the below link...and download. http://xcell05.free.fr/morefunc/english/index.htm If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: Errrm... where & how do i use the Add-in? "Jacob Skaria" wrote: Unless you use an Add-In; these formulas will work only if all external data sources are open. If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Try the SUMPRODUCT() version of the formula and feedback
=SUMPRODUCT(--('D:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000=$A33), --('D:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000DATE(2009,1,1))) If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: Unable to download from site. Any other options? "Jacob Skaria" wrote: Check out the below link...and download. http://xcell05.free.fr/morefunc/english/index.htm If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: Errrm... where & how do i use the Add-in? "Jacob Skaria" wrote: Unless you use an Add-In; these formulas will work only if all external data sources are open. If this post helps click Yes --------------- Jacob Skaria "jaysan3" wrote: I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Your problem is that Excel does not recognize "01/01/09" as a date. It
thinks you are looking specifically for that text string. Do it this way: =countifs(...,""&date(2009,1,1)) Regards, Fred. "jaysan3" wrote in message ... I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Links to other worksheet not updated or showing #VALUE!
Changing the date doesnt help.
My mistake, the links are in a different workbook, not worksheet as mentioned earlier. "Fred Smith" wrote: Your problem is that Excel does not recognize "01/01/09" as a date. It thinks you are looking specifically for that text string. Do it this way: =countifs(...,""&date(2009,1,1)) Regards, Fred. "jaysan3" wrote in message ... I have a formula linking to another worksheet but it does not show the result unless I open that worksheet too. Any ideas? Please correct me if my formula or excel settings is wrong. =COUNTIFS('d:\[Outgoing List 2009.xlsm]Outgoing'!$J$2:$J$10000,$A33,'d:\[Outgoing List 2009.xlsm]Outgoing'!$T$2:$T$10000,"01/01/09") When I tried a simple formula, it works fine. =d:\[Outgoing List 2009.xlsm]Report'!$B3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing when a file was updated | Excel Discussion (Misc queries) | |||
| This worksheet contains links that cannot be updated | Excel Discussion (Misc queries) | |||
| Links not updated when primary worksheet is sorted | Excel Worksheet Functions | |||
| Showing Updated Cells | Excel Discussion (Misc queries) | |||
| Links not showing updated value | Excel Discussion (Misc queries) | |||
Hybrid Mode
