That is a good point and I thought the same thing.
However, I selected a single (small) tab out of the main file and
tested the above formulas on it as well with no luck.

As far as why the main file is huge, 15 tabs, 30 Vlookup columns, and
several hundred thousand cells with formulas.


--
Tai-Pan
------------------------------------------------------------------------
Tai-Pan's Profile: http://www.excelforum.com/member.php...o&userid=28269
View this thread: http://www.excelforum.com/showthread...hreadid=478339