Starting with version 2013 (possibly earlier), and persisting through the latest MU of version 2014, we seem to have lost a valuable feature in BIE.

In the past, one can create an Excel "template" file that uses the data exported by BIE in the SourceInfo named range and have subsequent exports automatically update the "template".   For example,

1. Export BIE data to Excel

2. Add a pivot table to that Excel book

3. Save the file 

4. Export BIE data to "Excel Template" and select the file created earlier

5. The pivot table would automatically be updated with fresh data.

Starting Version 2013, when you do #4, the pivot table is converted into values and the ability to pivot is gone.    

I couldn't find anything about this in the KB.   This would seem like a major loss of functionality to me.    Is it a known bug?  Or is there a new procedure to get this to work?

Thanks,

John

The ERP Group, LLC