I copy info from a bi-monthly Quicken report to Excel, then do some
manipulation to get a report I like.

The following has happened since last fall, ever since I had "return block"
in the "Memo" field for _one_ record:
a) _Most_ records with a blank in Memo field end up with "return block" in
that field of the pivot table, even though the "data" worksheet does not
contain that text anywhere!!!
b) Double clicking on the 'amount' of the row brings up a new sheet which
correctly shows a blank cell.

I just noticed another oddity (I was trying to conditionally format so that
"return block" would be white, therefore invisible - it does work, but I
shouldn't need it!).
c) There are some rows which DO have data in the Category field, but none in
Memo, but BOTH columns are BLANK, even though double-clicking shows the
correct underlying data.

I've dealt with pivot tables for years - never had a problem until this.
Can anyone help??

Thanks,
vcard


*** Posted via a free Usenet account from http://www.teranews.com ***