how to disable table names/ column names

[faizee]

can anybody please help me how to disable column names/ sub names in table in excel 2007.
for example:
=IF(OR(Table3[[#This Row],[ISSUE / RECEIVE]]="RECEIVE",Table3[[#This Row],[ISSUE / RECEIVE]]="ISSUE"),IF(ISNUMBER(FIND("BOARD",Table3[[#This Row],[MATERIAL]])),Table3[[#This Row],[WIDTH]]*Table3[[#This Row],[LENGTH]]*Table3[[#This Row],[GSM]]/15500,IF(ISNUMBER(FIND("STICKER",Table3[[#This Row],[MATERIAL]])),Table3[[#This Row],[WIDTH]]*Table3[[#This Row],[LENGTH]]*Table3[[#This Row],[GSM]]/15500,IF(ISNUMBER(FIND("CARD",Table3[[#This Row],[MATERIAL]])),Table3[[#This Row],[WIDTH]]*Table3[[#This Row],[LENGTH]]*Table3[[#This Row],[GSM]]/15500,Table3[[#This Row],[WIDTH]]*Table3[[#This Row],[LENGTH]]*Table3[[#This Row],[GSM]]/3100))),0)

i want to disable it..i want only cell number. i have unchecked excel options --> formulas --> "use table names in formulas" but it didnt work.

 

[iliace]

Unless you're using 2007-specific features, the best way is to save in XL 2003 format and re-open.

 

[faizee]

no. issue is still unresolve, when i m saving it in XL2003, its disabling some feature that i need in file..

 

[iliace]

Under the table design feature, select "Convert To Range".