Hi all,

I have created a pivot table which is reading from a table of data in another sheet.

The table of data has a lot of formulas in it and the pivot table is counting the cells with the formulas in it, not just the cells with the text.

If i copy the data table and paste values then the pivot table works fine but i want to be able to keep the formulas in the data table.

Is there a solution for this?

Many thanks