XL: Access Violation Error When You Click Hyperlink to OLAP PivotTable (317168)

WORKAROUND

To work around this problem, use either of the following methods.

Method 1

Set the hyperlinks to open Excel in a new window. To do this, the hyperlink must resemble the following HTML code:

<a target="_blank" href="filename.xls">
				

Method 2

Instead of linking to Excel Spreadsheet components, create HTML pages that contain PivotTable components, and link to them. To do this, follow these steps in Microsoft FrontPage 2002:

1. On the Standard toolbar, click the Create a new normal page button.
2. On the File menu, click Save. Click Change title.
3. In the Page title box, type a descriptive title, and then click OK.
4. In the File name box, type a file name, and then click Save.
5. On the Insert menu, click Web Component. Under Component type, click Spreadsheets and Charts. Under Choose a control, click Office PivotTable. Click Finish.
   
   FrontPage inserts a blank PivotTable component in the Web page.
6. Click to select the component, and then click the Click here to connect to data hyperlink.
7. Click Connection, and then click Edit.
8. In the Select Data Source dialog box, click New Source. In the list of data sources, click Microsoft SQL Server OLAP Services. Click Next.
9. In the Server name box, type the name of your SQL Server. Type the correct logon information for your database. Click Next.
10. Click the correct database in the list of databases.
11. Click the correct cube or table name.
12. Click Next. Type a name for your data source, and then click Finish. In the Select Data Source dialog box, click Open to return to the Web page.
13. In the PivotTable component, click the Field List button on the toolbar to show the available fields. Build your PivotTable as you would in Excel, and save the file.