Originally Posted by
Banixxx
THis sint working because the Pivot Tables are on a Seperate Sheet.
The Pivot Tables are on a Sheet Called "Pivot Tables" and I want to access PT "Day_1" and get the Information. I can do it on the Same sheet just fine but when i go to my sheet called "Table" and try to get the data it doesnt work.
I tried GETPIVOTDATA('Daily Pivots'!Day_1, "DESIRED FIELD" but get a ?#NAME error cause it cant find the Table. Is this possible to access a Pivot Table form another Sheet?