Excel Spreadsheet with Autofilters as a Web Page
 

All,

I would like to convert my spreadsheet along with its Autofilter option into
a web page & then post it on my intranet.
Is there a way to do this. If I use Excel 2003 can I directly save it as an
XML & then post it , if yes what if user has Excel 2000 or lower versions.
What is the best solution.


regards

When a worksheet is published as a web page with interactivity it is
converted into an HTML file that the Office Spreadsheet Component (SSC) can
read. It is no longer an Excel workbook and it does not have any connection
to Excel. The only functionality such a converted file has is limited to
the capabilities of the SSC. Unfortunately the SSC has only a small subset
of Excel's capabilities and Autofilter is not among them.

--
Jim
"Shirish" wrote in message
...
| All,
|
| I would like to convert my spreadsheet along with its Autofilter option
into
| a web page & then post it on my intranet.
| Is there a way to do this. If I use Excel 2003 can I directly save it as
an
| XML & then post it , if yes what if user has Excel 2000 or lower versions.
| What is the best solution.
|
|
| regards