Validation Load Error on trying to publish an Excel Spreadsheet

[Michael6]

Trying to publish an interactive spreadsheet, I get this message: "The Microsoft Office Spreadsheet Component could not load the XML data. Validation Load Error: For Type List, the absence of a <CellRangeList> tag implies relative cell references in the list values which is not allowed."
Your help will be much appreciated

[royUK]

Which version of Excel? I suggest that you fill in the version of Excel that you are using in your Profile.

[Michael6]

It is Excel 2003, SP3

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[DonkeyOte]

A quick Google (and error msg) implies that the issue is related to publishing something utilising Data Validation - spec. Lists (I think) though not sure if this is any List or only those sourced from named ranges etc

[Michael6]

Thank you a lot for your response
A sample Worksheet is attached to show the Data Validation used in the actual Worksheet

[Michael6]

A quick Google (and error msg) implies that the issue is related to publishing something utilising Data Validation - spec. Lists (I think) though not sure if this is any List or only those sourced from named ranges etc

A quick Google (and error msg) implies that the issue is related to publishing something utilising Data Validation - spec. Lists (I think) though not sure if this is any List or only those sourced from named ranges etc .
.............................................................................
DonkeyOte
God bless you. You never let any one down.
How reassuring it is to know that you are there on this forum when help is needed !!!!