Hi there.

Hopefully someone can help with something that seems pretty strange. I'm
exporting data from access to excel and doing some stuff to the data with
pivot tables.

In the pivot tables however, blank cells don't register as 'blank' unless I
manually go into each cell and hit delete (even though there seems to be
nothing there to delete).

Here's an example of befo

Count of QualityChecked
QualityChecked Total
(blank)
4
Yes 6
Grand Total 10

and after I delete the data in the seemingly blank cells:


Count of QualityChecked
QualityChecked Total
(blank)
Yes 6
Grand Total 6

Someone in the access group mentioned that the empty fields from access are
appearing in excel as empty strings (as opposed to empty cells) and that you
guys might be able to help me with resolving that.

It's one of those strange things that's driving my insanity to the edge of
oblivion.

Thanks in advance.

Shane