![]() |
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? |
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? |
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? |
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