pivot tables shows grand totals sometimes, sometimes not...?

J

J.W. Aldridge

any clues as to why i get grand totals, and sometimes i dont.

occassionally i go over my numbers and fix errors and suddenly the
grand total appears.

but sometimes i dont find any errors and it still doesnt appear.


any clues?
 
S

Sandy Mann

It sounds like your *numbers* are actually text representations of numbers.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
J

J.W. Aldridge

sure nough, i went back over my data and an error was in there
somewhere ( i had hidden it using conditional format).
when i went back, i deleted it and my totals popped right up!

thanx a million!
 
S

Sandy Mann

Glad that you found it. Thanks for the feedback.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

Top