how to make a workbook an interactive web page?

[DC]

I have a workbook with 2 interactive and 1 hidden sheet. What are processes
for fo enabling an interactive web page with the workbook?

 

[CyberTaz]

Hi DC-

Use File>Save As Web Page and put a check in the box for Add Interactivity.
You should also use the Publish button & make any other settings necessary,
then click Publish in the Publish as Web Page dialog box. Keep in mind that
not all browsers support the interactivity features, though.

HTH |:>)

 

[DC]

Thanks for the advice. I have tried this but get a message
" The Microsoft Office Spreadsheet Component could not load the XML data.
Validation Load Error: For Type List, the absence of <CellRangeList> tag
implies relative cell references in the list values which is not allowed"

The result is an empty workbook with 3 sheets. I am guessing that it doesn't
like "data validation". Would this be right?

DC

 

[CyberTaz]

I haven't seen this message before, and it doesn't seem particularly clear
(surprise!surprise1). Could there be content on the visible sheets that refer
to content on the hidden sheet?

Regards |:>)