Trying to convert a workbook into an interactive web page ready for publishing, I chose File- Save as a Web Page from the Menu bar, and followed the required steps. In the Save As a Web Page dialog box, I checked "Add Interactivity With: ", but I get the error message:
"The Microsoft Office Spreadsheet Component could not load the XML data.
Validation Load Error: For Type list, the absence of a < cell range list > tag implies relative cell references in the list values which is not allowed."
I am using Excel 2003, SP3.
Any suggestions will be much appreciated.
Bookmarks