external data source for pivot tables

R

Robin Krupp

i am using using office 2003. i am pulling data in from access i have two
hundred thousand plus records all my summed data shows up as zeros when
infact its not zero .... anyone have any clues
 
S

ShaneDevenshire

Hi,

Probably Excel thinks the data is text.
Check the Access table in design mode and make sure the field is a numerical
data type, not text.
 
R

Robin Krupp

that was exactly it..... access is treating these fields as text fields when
they are not
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Excel file linked to external source 0
pivot table missing rows? 0
making an excel table visible for external data on pivot table 1
Error message on external data for pivot tables 0
Can a pivot table be redirected to an external source? 1

Top