(blank) Fields on Pivot Table from Database Connection

[hahdawg]

Hi

I've been trying to create a pivot table from a database connection, and the last row and column fields always show up as (blank). The row fields are stores, and the column fields are cities. There are some blank cells in the database, but each store and column cell has a value. Also, the value I want to use is sum of sales, but it shows up as count of sales, even though there are no blank sales cells in the database.

As a check, I put the table from the database into Excel, ran a pivot table, and I got the results I expected: There were no row or column fields named (blank), and the value showed up as sum of sales.

It seems that when I run the pivot table from the database, Excel thinks there are blank cells, when there aren't any.

I could easily clean this up with a macro, but I'd rather figure out the root of the problem. Can anyone help with this?

 

[hahdawg]

I fixed it.

The import range name was dynamic, so it didn't show up in the Access import wizard. So I created a static range name and used the import wizard to import it, and the (blank) issues disappeared.