Iteration Backlog Burndown tab unable to get DataFields property of the PivotTable class

Question

I've been trying to get the Iteration Backlog worksheet to display all the data it is designed to display. The burndown chart is my last issue. I get this problem:

 

I've unhid the Burndown data tab and cannot see to get data there. Is there a post or trick to getting data there? When I create my own report off the Analysis cube I can get data just fine.

Answer 1

Hi Chris,

 

Thanks for your post.

 

I’m currently looking into this issue and will give you an update as soon as possible.

 

If you have any further research of this issue, please share your experience here. 

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

I just noticed that when I open Excel Reports / Burndown.xlsx I don't have any data. Updating the report filters to with values that should have data doesn't fix it.

These two issues seem related. Hope that helps. 

Answer 3

I looked for information on the error you are getting (“Unable to get the Datafields property of the Pivottable class”). I did find a bug regarding Team Foundation Server and Excel that produces this exact  message. However, I am not sure this applies to your issue.

Can you tell me what version of Excel are using?

What version (including service pack) of TFS do you have installed?

Can you give me brief steps you use to get the error?

---

--Trevor H.
Send files to Hotmail.com: "MS_TREVORH"

Answer 4

Excel 2007

TFS 2010 RTM Standard Edition. No service packs. 

I get the error by 

1. Opening the iteration backlog

2. Changing the tab to Burndown

3. Clicking Update Now link in worksheet.

Hope that helps. 

Answer 5

Thanks for the quick reply.  I want to test something on my end.   Let me do the testing, and I plan on updating you sometime Monday.

 

---

--Trevor H.

Answer 6

Hi,

 

I tried to reproduce this behavior by opening and refreshing the data in the Iteration Backlog.xlsm spreadsheet in both Excel 2007 and Excel 2010.  It works without error in both cases.  I had to enable macros for it to run under Excel 2007, but it did run without a problem.  

 

 

This issue is exceeding the scope of forum support.  If you want to pursue this issue, I recommend you open a case with our Excel team and have them debug the error.  Visit this link to see the various support options that are available to better meet your needs:  http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone.

---

--Trevor H.