98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel-based interactive web page
Excel-based interactive web page
Resolved · Low Priority · Version Standard
David has attended:
Excel Advanced course
Word Advanced course
Excel-based interactive web page
How do I ensure that a spreadsheet remains updated once it has been published on the web?
RE: Excel-based interactive web page
Hello David,
I hope you enjoyed your training sessions with us.
To answer your question, when you are saving your worksheet/workbook as a web page, follow these steps to ensure your data will always be updated:
1. Open or select the workbook that contains the items you want to publish.
2. On the File menu, click Save as Web Page.
3. Click Publish.
4. Under Item to publish, click what you want to publish in the Choose box.
5. Next to the File name box, click Browse, and locate the drive, folder, Web folder, Web server, or FTP location where you want to save or publish your Web page.
6. Tick the "AutoRepublish every time this workbook is saved" check box.
7. Click Publish.
I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |