Are you using Excel 2007 and InsertTable?

Table headers cannot be formulas.

If you have a formula the formula will be changed to a static value when you
create the table.

You will be warned of this when you create the table.

If you try to enter the formula after you have created the table, it will
turn to 0................no warning.


Gord Dibben MS Excel MVP




On Wed, 11 Nov 2009 13:19:03 -0800, Doug
wrote:

For some reason the header will not hold the formula because the zero it
returns deletes =Import!$Q2