blank cell / pivot table cell filled

[gimage]

Hello:
I have a pivot table associated with a inventory spreadsheet. In the pivot table, there are entries for tracking numbers when something ships. Many of the cells do not have tracking numbers yet in the pivot table, I see the same number in what should be a blank cell. How to I correct this? When I have something (or blank by pressing the space bar) in the tracking number cell, it shows up correctly.

Thanks,
Greg

 

[xenou]

Hi,
What you are describing doesn't make any sense at all - pivot tables just shouldn't do this.

Make sure of the basics:
1) Is the pivot-table refreshed?
2) Check under pivot table options to make sure that "For blanks Show: " doesn't have something wierd to show for blanks
3) Is the workbook on manual calculation? (I don't think this matters really)
Use the pivottable wizard button to "back" up to the pivot data source and make sure it is connected to the right source data!
4) Make sure that the field you are using in the pivot table is the right field!

Maybe you'd want to just kill this pivot table and start with a new one - or even copy the other sheets into a new workbook and build a new PivotTable there.

Hope this helps and you get this one figured out. If you have more problems post more detail - what's in the pivot table and what's the source data table like.
AB

 

[Padawan]

Gimage


Just a quick point.

So far as I know you would NEVER want to clear a cell in Excel (or probably any other computer spreadsheet) with a spacebar. This can really foul up a spreadsheet. The computer sees the spacebar as text - same as the letter "A" or the work "Gimage". Using the spacebar if it is within cells relating to a formula can give you some very frustrating results that can be difficult to find.

Use the delete key to clear cells, or the menu at Edit->Clear->Contents to clear your cells.

Regards,