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

Hi DC-

Use FileSave 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" wrote:

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

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

Hi DC-

Use FileSave 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" wrote:

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

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 |:)

"DC" wrote:

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

Hi DC-

Use FileSave 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" wrote:

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