FrontPage and Office web components.....

[Mike Berger]

This is my first attempt at using Office Web Components w/FP. When I create
a PivotTable in Excel, do a Save As Web Page, and use Publish to publish the
web page to my FP web, everything seems to work as expected. A .htm is
generated within my FP web that contains a ActiveX PivotTable control (with
the correct data), and a ActiveX DataSource control.
When I use FP to put a PivotTable on a web page, I do a Insert > Web
Component... > then select "Spreadsheets and charts" and select "Office
PivotTable". This inserts a ActiveX PivotTable on my web page. Now I need to
populate the PivotTable, so I activate the PivotTable (in FP design mode)
and press the hyperlink on the control labled "Click here to connect to
data". A dialog appears, and one of the dropdowns is labeled "Data source
control", which I assume is to contain a list of ActiveX DataSource
controls. On a new page, this list empty. So, my question is, how do you add
a DataSource control to a web page ?

Thanks
Mike