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.

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.

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:

Q179700 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

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.
   
   
   1. In the Choose Data Source dialog box, click "<New Data Source>". Click OK.
   
   
   
   2. In the first box, type Test. In the list box, click Microsoft 3.01 dBASE PPC. Click Connect.
   
   
   
   3. Select the following folder:

      Microsoft Office 98:Sample Files:Sample Databases

      Then, click the 'Select "Sample Databases"' button.
   
   
   
   4. Click OK. Click to select the Use The Query Wizard check box. Then, click OK again.
   
   
   
   5. In the list of tables and columns, click ORDERS. Click the ">" button. Then, click Next.
   
   
   
   6. 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.

Q179297 XL98: Using Server Page Fields in PivotTables

Additional query words: XL98

Keywords : xlquery xlpivot
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb