Error while Exporting to Excel from Analysis by Dimension

tewariankur

---

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.

DecBreen

Hi
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,' -+&','____');

manisharma31

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).