Dynamically Update Worksheets Published to the Web

One advantage of working with Excel over the Web is that you can make it possible for you and your colleagues to interact with Excel worksheets you have published on the Web. By adding interactivity to your worksheet, you and your colleagues can edit cell values, sort the values in the worksheet, filter, or create formulas. You can also use interactivity to update an Excel-based Web page whenever there is a change in the workbook on which the file is based.

Dynamically Update Worksheets Published to the Web

  1. Click the Microsoft Office button.

  2. Click Save As.

  3. Click the Save As Type down arrow.

  4. Click ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.