I am using the following formula to bring in data from a table but I am getting a reference error. =Getpivotdata("Value",Pivot absolute reference,"Date",cell reference A date,"TL",cell reference a TL" Here is my pivot table. Any help would be greatly appreciated...