XL98: "Error in Parameter 1" When Working with PivotTable

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you work with a PivotTable in Microsoft Excel 98 Macintosh Edition, you may receive the following error messages:

   [INTERSOLV][ODBC dBase driver]Database does not allow negative scale
   values. Error in parameter 1.

    -and-

   Problems obtaining data.

    -and-

   PivotTable is not valid.

To see an example of this problem, see the "More Information" section in this article.

CAUSE

This problem may occur when the following conditions are true:

• You create a PivotTable that uses external data that is stored in a dBASE table.

      -and-
  

• The PivotTable contains one or more page fields.

      -and-
  

• One or more of the page fields refer to numeric fields in the dBASE table.

      -and-
  

• You have set the page fields as server page fields.

When you use a server page field, Microsoft Excel uses a parameterized query to query the external database and retrieve the proper data; because the dBASE ODBC driver does not always support this functionality, the operation fails, and you receive the error messages described in this article.

RESOLUTION

To resolve this problem, remove and recreate the PivotTable; it is not possible to repair the damaged PivotTable.

To prevent this problem from occurring, use the workaround in the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q179700
   TITLE     : XL98: "Out of Range" Error Running Parameter Query in MS
               Query

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This problem does NOT occur if the following is true:

• The external database is not a dBASE table.

      -or-
  

• The field in the table is not a numeric field.

  For example, the field is a text field.

      -or-
  

• You do not set the page field to act as a server page field.

Example

To see an example of this problem, follow these steps:

1. In Microsoft Excel 98 Macintosh Edition, create a new workbook. Select cell A1 in Sheet1.

2. On the Data menu, click PivotTable Report.

3. In the Step 1 dialog box, click External Data Source and click Next.

4. In the Step 2 dialog box, click Get Data.

       a. In the Choose Data Source dialog box, click "<New Data Source>".
          Click OK.
   

       b. In the first box, type "Test" (without the quotation marks). In the
          list box, click Microsoft 3.01 dBASE PPC. Click Connect.
   

       c. Select the following folder:
   

             Microsoft Office 98:Sample Files:Sample Databases
   
          Then, click the 'Select "Sample Databases"' button.
   
       d. Click OK. Click to select the Use The Query Wizard check box. Then,
          click OK again.
   
       e. In the list of tables and columns, click ORDERS. Click the ">"
          button. Then, click Next.
   
       f. Click Next twice more. Then, click "Return Data to Microsoft
          Excel," and click Finish.
   
   

5. In the Step 2 dialog box, click Next.

6. In the Step 3 dialog box, drag the ORDER_AMT field to the PAGE area. Drag the CUSTOMER_ID field to the ROW area. Drag the EMPLOY_ID field to the DATA area. Then, click Next.

7. In the Step 4 dialog box, click Finish.

   The PivotTable appears in the worksheet.

8. Click the ORDER_AMT field in cell A1. On the PivotTable toolbar, point to the PivotTable menu and click Field. Click Advanced. Click Query External Data Source. Click OK twice.

   [INTERSOLV][ODBC dBase driver]Database does not allow negative scale
   values. Error in parameter 1.

   Problems obtaining data.

   PivotTable is not valid.

   ARTICLE-ID: Q179297
   TITLE     : XL98: Using Server Page Fields in PivotTables