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
Bookmarks