<CellRangeList> error on trying to publish an excel workbook

[Guest]

I have a simple workbook that contains three cells being used for common
dropdown lists. The cells that reference this list are conditionally
formatted dependent on the cell value. When I try to save the workbook as a
webpage (Publish) I receive an error stating "Validation Load Error: For Type
List, absence of a <CellRangeList> tag implies relative cell references in
the list values which is not allowed.

Any ideas

Michael

 

[algor]

when you have validation list tied to a cell, saving as xml wil add the following fragment:
============
<DataValidation xmlns="urn:schemas-microsoft-comffice:excel">
<Range>R2C1:R5C1</Range>
<Type>List</Type>
<Value>R10C1:R32C1</Value>
</DataValidation>
=========
I found then if it loaded into MS Office spreadsheet component OWC11 an error happen.
replacing fragment with following helps(edit xml in notepad)
<DataValidation xmlns="urn:schemas-microsoft-comffice:excel">
<Range>R2C1:R5C1</Range>
<Type>List</Type>
<CellRangeList/>
<Value>&quot;ITEM1,ITEM2,ITEM3&quot;</Value>
<ErrorMessage>out of range</ErrorMessage>
<ErrorTitle>Wrong Data</ErrorTitle>
</DataValidation>