#### in Access Pivot Tables

  • Thread starter Thread starter sternb
  • Start date Start date
S

sternb

I have an Access 2007 pivot table and can't seem to get rid of the ### signs
showing instead of my values showing. I have widened the columns but am still
having problems. Help!
 
Sternb -

What should the data look like? (How big are the numbers?) And how many
#s do you see in the widened column?
You may want to format your data - are you showing both comma and decimal
separators as well as maybe a currency symbol and/or brackets for negative
values? They all take up room. Expand the column very wide until you get a
value you can see - maybe there is an error in a calculation or something
that is returning numbers much larger than you expect?
 
The numbers are formatted correctly and the pivot table looks fine until I
look at it in Print Preview. Then many of the numbers change to the ####
symbols and print with the #### symbols showing.
 
You just might be running into a case where the size of the font , length of
the string, and the width of the "Cell" conspire to prevent display of the
entire value. When that happens, the result will be #### is displayed to
tell you "there is something here, but that it is too wide to print/display
in this particular mode."

The solution, obviously, is to give that cell more width so it can do its
job more gracefully.

HTH

George
 
Back
Top