I have a pivot table accessing data using the external data source option via Data Connections. I am averaging 8 data fields in the pivot table and 4 fields are giving a #DIV/0 error. When I open a data sheet within the pivot table to look at the data, I see that the data has an error message "number stored as text". However, the external data source used does display these fields as text.

Note: I do not experience this problem when the data is retrieved via the excel table/range option.

Sound familiar to anyone?