Microsoft KB Archive/317168

= XL: Access Violation Error When You Click Hyperlink to OLAP PivotTable =

Article ID: 317168

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q317168



SYMPTOMS
When you host an Office Spreadsheet component in an HTML page, and you click a table of contents link in the left frame, you receive an access violation error at various memory addresses.



CAUSE
This problem occurs when the following conditions are true:
 * PivotTables in the spreadsheet are configured to refresh when you open them.
 * The PivotTables use Online Analytical Processing (OLAP) analysis server tables or cubes as a data source.



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: 

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.
 * 1) Click to select the component, and then click the Click here to connect to data hyperlink.
 * 2) Click Connection, and then click Edit.
 * 3) In the Select Data Source dialog box, click New Source. In the list of data sources, click Microsoft SQL Server OLAP Services. Click Next.
 * 4) In the Server name box, type the name of your SQL Server. Type the correct logon information for your database. Click Next.
 * 5) Click the correct database in the list of databases.
 * 6) Click the correct cube or table name.
 * 7) 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.
 * 8) 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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2002 XL2000

Keywords: kbbug kbpending KB317168

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.