Hi All, I encountered the below error when I tried to export data from Analysis By dimension: “The PivotTable field name is not valid. To create a PivotTable, you must use data that is organised 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.” May I know what is the reason of the error? Navision Version 3.7 is used. Cheers Joyce
hi Joyce There are two reasons for these error One reason error will happen if you are giving Analysis view name which contains ambersent sign i.e. “&” or any other sign. second reason can be your excel is open. Befor exporting dat you have to make sure that your excel is completly closed. Please revert if your problem is solve danesh