Publishing with validation

[Guest]

Is it possible to publish and .htm adding interactivity file that has cells
using the validation (list type) functionallity?

if so, how?

i'm trying to it with no sucess. I publish the page, but when i'm going to
open it, an error message appears saying that it could not load the
validation cells or something like this.

thanks!

 

[Guest]

I am having the same problem. I am surprised that not more people are having
this issue. When searching on the internet I see a couple of other people
having the same troubles. The error message is as follows:

"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"

I understand that this means that validation that uses relative cell
references is not allowed. So, why is there not a tool that can check an
excel file and change all relative references to absolute references when
excel tries to convert the file?

Any help would be great