<CellRangeList> error when trying to publish Excel workbook

Hi,

I'm trying to publish an Excel spreadsheet as a webpage. In Excel 2003 I'm selecting
'Save as webpage'
Clicking on 'Add interactivity'
Publishing 'Entire Workbook'

When I try to open the web page generated I get an Error:-

Validation Load Error: For Type List, the absence of a <CellRangeList> tag implies relative cell references in the list values which is not allowed.

I am using a Data Validation box with Allow set to list which I have tracked down is causing the problem. Can replicate the problem very easily as follows

On a blank workbook, in cells A1, A2, A3, A4 & A5 put 1, 2, 3, 4 & 5 respectivly.
In Cell A6 enter data validation Allow list.

I have tried naming the data range and have the data validation refer to the named range, have also tried entering =$A$1:$A$6 and =A1:A6 manually in the data validation source(the error specifically refers to 'relative cell references' as not being allowed, hence trying with both relative & absolue).

I get the same error on all the of the above methods of referencing the data range when trying to load the webpage generated.

Interestingly! I have seen the exact same question asked when I tried searching for a solution to this problem, a reply to the poster asked him to check if the data validation was refering to data on a hidden page, the post was maked [solved] implying that the OP had managed to get round the problem (although clearly this solution is not the cause of my problem) - makes me think the problem is solvable, I was just starting to think that Data Validation from a list isnt allowed when wanting to publish the spreadsheet

Thanks in advance to anyone that might be able to help me out.

Tony