ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to make a workbook an interactive web page? (https://www.excelbanter.com/excel-discussion-misc-queries/53112-how-make-workbook-interactive-web-page.html)

DC

how to make a workbook an interactive web page?
 
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

how to make a workbook an interactive web page?
 
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?


DC

how to make a workbook an interactive web page?
 
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?


CyberTaz

how to make a workbook an interactive web page?
 
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?



All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com