Search results

Hello bobhc: I constructed the original workbook, which is why I assumed that the file path (which does not exist) may have been a draft that I created last year. Fortunately, I did not have to clean up the data source. The data source was fine - the only place where I had duplicates was in...

Thank you for your interest and consideration. At this point, I think that the problem was coming from an error regarding the Data Source File. I could "Refresh" the PivotTable with no problem - everything updated. But when I tried "Refresh All," I got a message telling me that Excel could not...

Thank you for the feedback. After I deleted the entire slicer, I hit UNDO and got the slicer back again. BOBHC suggested that I check the input data for duplicates. I tried this and I cannot find any duplicates. The data source is a table. The table has only one "Jan '12" so I cannot figure...

I have a duplicate "January 2012" on a slicer. When I tried to delete the duplicate, I deleted the entire slicer. Is there a way to remove the duplicate?