Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error in formula after auto-filtered
In a table, i have one column (let say Column A) where the formula is
referred to another workbook. The formula works well, until i do an auto-filtered on another column (Column B). The formula in Column A would then displayed "#Value!". The formula would works well only if i have the other workbook opened. How do i do an auto-filter without getting the error on the formula? Pls advice. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to filtered Data - AUTO | Excel Discussion (Misc queries) | |||
using auto filter, how to tell what columns are filtered? | Excel Discussion (Misc queries) | |||
Conditional List (auto filtered) | Excel Discussion (Misc queries) | |||
Copy auto filtered data | Excel Discussion (Misc queries) | |||
Calculating auto filtered data | Excel Discussion (Misc queries) |