Excel 2007, SP1 on Vista

I turned a rectangular region (with column headings) into a Table (for
ease of adding new rows, etc) in a workbook - it's Table15 in Program
List.xlsx

In a second workbook, when I use the worksheet Function Wizard to set
up a Vlookup using part of that table, it gives me syntax like

=VLOOKUP(A5,'Program List.xlsx'!Table15[[#All],[Program]:[Status]],
4,FALSE)

or

=VLOOKUP(A6,'Program List.xlsx'!Table15[[Program]:[Status]],4,FALSE)

(I think the [All] 'means look at the column headings, too')

Both work when the Program List.xlsx workbook is open - neither work
when it is closed.

Reverting to the older syntax for referring to a range, i.e.,

=VLOOKUP(A6,'[Program List.xlsx]Unique Composite'!$B$1:$E$959,4,FALSE)

works when the Program List.xlsx workbook is open AND when it is
closed.

Am I missing some element of the new Table syntax or is this behavior
a 'feature' of the new Tables in 2007?

Thanks for your help on this!

James