Hi all -
I am attempting to use a template we built but experiencing problems. The spreadsheet not pulling the data from the "Keywords" tab's pivot table. The first tab "Prospects" is using the =GETPIVOTDATA formula to pull from the "Keywords" tab for columns I - AE (if data is present).
I'm not sure why the keywords pivot table has reverse ordered the dates in the pivot table columns from most recent to oldest, but I think this may have some effect?
This issue occurs on Excel 2007, and when I attempt to replicate it in Excel 2013, I do not have the same issue. The dates in mine (Excel 2013) also are from oldest to most recent in the pivot table on the tab labeled "Keywords."
Thanks in advance for your help!
I have attached a few images that show the getpivotdata formula I'm using. I cannot attach the spread sheet as it is too large...
Bookmarks