Getpivotdata not working excel 2013, options are on

Hello,

I'm trying to use getpivotdata to populate another table for my pivot charts. All options are turned on to generate pivot formulas. I enter "=" then click a cell in my pivot table and the getpivotdata formula is not automatically generating. I'm struggling to make the formula from scratch as well. Any ideas to get the formula working? I've restarted my workbook after unchecking the options to generate pivot table formulas. I can't update software on my work computer and I'm using Excel 2013.

Originally Posted by rorya

You need to check, not uncheck, the option to generate the formulas. You also need to select a cell in the values area of the pivot table; GETPIVOTDATA does not work for fields in any other areas of the pivot table.

Sorry for the misunderstanding, they are/were checked. I was trying something another user did. But yes they are checked and I selected a value which happens to be a date and I'm still getting a normal cell reference. I've tried several cells with value and nothing is triggering getpivotdata. Thanks for your quick reply.

Originally Posted by rorya

Is that definitely a value field rather than a row/column field? It would probably help to post a workbook and state which cell(s) you are trying to reference

I'll upload my file in 30 minutes (having lunch). Hopefully I'm allowed to now since I'm a new user. I'll find out soon. I appreciate the help Rorya.

It's attached. The table below the pivot table (Dashboard sheet) is where I'm trying to populate this information.
I moved that table there temporarily from my "Workings" tab to see if it would make a difference and for ease of transferring data.
I'm taking this step since I lose the conditional formatting in my gantt chart as soon as I use a slicer. Thank you again!

Hi rorya!

I forgot to reply to this message with my post. I posted the file in this thread below.

Thank you again for taking a look. I'll check back in tomorrow.

All the best

I've seen videos where you can getpivotdata with dates and you treat them as text. But I can't get the formula to pop-up which I now I understand with your help. Is there a work around for this? I just edited my data table and I lost my gantt bars for one project as well. I was hoping this getpivotdata would help with my gantt issues. Thanks for your reply.