Refreshing pivot table leaves a blank pivot table

[DonnaRonna]

Hi,

I have been using pivot tables for years and I have never run into problems like I've had in the last couple of days. I've created a pivot table with 2 filters. One is a label filter which uses the "less than" function to confine the pivot table to a certain level of item numbers. The other is a filter which I am selecting which locations I wanted. It works fine until I tested the refresh function. No change in data, no change in anything. I just click refresh and my pivot table is now blank, where before it had data!!

I've been touting the benefits of pivots to my client and now the simplest of pivots won't work!

My client has Office 365 (which I've never used before) so is it something with this version of excel? Is there something I should check in the format of the data set I'm using? Can I not use more than one filter (although each filter is on a separate field)? If I take off one of the filters, the pivot table works, but I need both.

I've tried just letting the pivot select the data range and I've also created a data table, and the same thing happens in both cases.

I would be grateful for ANY suggestions. I'm pretty desperate at this point and I don't want to have to resort to a bunch of SUMIFs to get the summarized data my client needs.

Thanks in advance

Donna

 

[DonnaRonna]

Follow-up: it seems to be the label filter, because when I remove it, the pivot refreshes without incident. So cannot I not use the "less than" or "between" (there will be a need for this one too at some point) label filters? Anyone else use these successfully?