Error while Exporting to Excel from Analysis by Dimension

tewariankurtewariankur Member Posts: 8

Microsoft Dynamics NAV
This message is for C/AL programmers:

The call to member CreatePivotTable failed.
Microsoft Office Excel returned the following message:
The PivotTable field name is not valid.
To create a PivotTable report, you must use data that is organized as a list with labeled columns.
If you are changing the name of a PivotTable field, you must type a new name for the field.

While exporting from Analysis from Dimension the system is giving above error. Please suggest what is the problem.
Thanks and Regards,
Ankur Tewari
MS Dynamics Technical Consultant


  • Options
    DecBreenDecBreen Member Posts: 2
    I got the same error from a customer this morning.
    The Analysis view code was called P&L
    I took a gues that excel might not like the Ampersand so I changed the following code in codunit 424 and it sorted my issue.

    // xlSheetName := CONVERTSTR(xlSheetName,' -+','___');
    xlSheetName := CONVERTSTR(xlSheetName,' -+&','____');
  • Options
    manisharma31manisharma31 Member Posts: 285
    You can't just add the special character in the code to convert the Excel Sheet Name every time.
    Rather than doing a customization, i would suggest change the name of Analysis View Code (i.e Remove any special character).
Sign In or Register to comment.