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