Slicer Disappears On Refresh

Hi All

I am creating a spread sheet using pivots and slicers.

When I 'refresh all' one of the slicers disappear.....

Is there anything that can be done to stop this?

Kindest regards



Diane

Thanks msexcelathome for your quick reply.

In the process of condensing the workbook so that it could be uploaded I seem to have solved the problem.

I am extracting data from Sage 200 using ODBC. The last slicer I wanted to install would give the name of the warehouse where stock was being held.

I inserted the slicer, and everything refreshed normally.

I then changed the name of the column heading from Name2 to Warehouse, and doing this caused the problem.

I have attached a copy of the file.

Many thanks for your time



Diane