In Excel 2007, I get an error when trying to use table names in formulas. Eg.
I am trying to 'Sum' a column of figures whose heading is 'Jan' and I have
entered the function as =SUM(Jan). The option 'Use table names in formulas'
has been activated.
Jan
223
223
114
=(Sum)Jan
The result is #NAME?
The same procedure works perfectly in Excel 2003.
Thanks