Add-in for Excel: Pivot table error when numeric variable has missing values

[MariaD]

Hi folks, 

We have a table with 3M records on SAS. The table has numeric and character variables. Some of the records for the numeric variables are missing. 

When tried to open the table, using Add-in, on Excel as PivotTable an error appear with messages about "Not is possible to define NumberFormat property from PivotField class". The pivot table loads but the link with SAS is disabled so I can't refresh the Pivot when SAS table is update.

I tried to use, options missing = 0; on a SAS program in Excel but the same erro occurs. Any idea?

Regards,