| 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 |
| 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) | |||
Threaded Mode
