XL98: Analysis ToolPak Error: "Cannot Add Chart to a Shared Workbook"

ID: Q183188

The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you use the Exponential Smoothing, Histogram, Moving Average, or Regression tool in the Analysis ToolPak, and you click OK, you may receive the following error message:

<Tool Name> - Cannot add chart to shared workbook.
Continue creating output table?
Where <Tool Name> is the name of the analysis tool that you are using.


CAUSE

This problem occurs if the following conditions are true:

  • You do the following to create a chart for the analysis tool that you are using:

    • You click to select the Chart Output check box in the Exponential Smoothing, or Moving Average dialog box.

      -or-


    • You click to select the Residual Plots or the Line Fit Plots check boxes in the Regression dialog box.


    -and-


  • You click Output Range or New Worksheet Ply under Output Options to return the results to the source workbook.

    -and-


  • The "Analysis ToolPak - VBA" add-in is not loaded.



RESOLUTION

The following file is available for download from the Microsoft Download Center, and corrects the issue described in this article:

Procdb.hqx
For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address
http://www.microsoft.com/downloads/search.asp
and then click How to use the Microsoft Download Center.

To install the updated ProcDBRes file, follow these steps:
  1. Quit Microsoft Excel.


  2. Use an appropriate program to decode and decompress the add-in.


  3. Copy the ProcDBRes file to the following folder:


    4. Microsoft Office 98:Office:Excel Add-Ins:Analysis Tools
You will not receive an error message the next time that you use any of the analysis tools to create a chart.

Workaround

To work around this problem, use either of the following methods. Method 1 is a permanent workaround, and Method 2 is appropriate only if you are using the Histogram or the Regression tool.

Method 1 - Load the Analysis TookPak - VBA Add-In:

To use this method, load the Analysis ToolPak - VBA Add-in. If the add-in is not installed, use the Value Pack Installer to install it. To do this, follow these steps:
  1. Insert the Microsoft Office 98 compact disc (CD-ROM) into the CD-ROM drive.


  2. Open the Value Pack folder on the Office 98 CD-ROM.


  3. Double-click the Value Pack Installer icon.


  4. In the Value Pack Installer, click the triangle next to Programmability.


  5. Click to select the "Excel Analysis Toolpack VBA support" check box, and then click Install.


  6. Click Quit to click the Value Pack Installer.


  7. Start Microsoft Excel 98 Macintosh Edition.


  8. On the Tools menu, click Add-Ins.


  9. Click to select the "Analysis ToolPak - VBA" check box and click OK.


You can use the Exponential Smoothing, Histogram, Moving Average, or Regression tools in the Analysis ToolPak to create chart output.

Method 2 - Create a New Workbook:

If you are using the Histogram or Regression tool, you can work around the problem by clicking New Workbook under Output Options.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

Additional query words: XL98 toolpack

Keywords : kbfile kbtool kbdta kbchart xladdins
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: December 10, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.