Hi I have a problem with Navision 3.70 and Excel 2003. On a Report where the data needs to be exported to excel, when the Automation variables are defined and the report is compiled. The following Error Message comes. The Variable APPLICATION::WORKBOOKPIVOTTABL is defined more than once An Example could be: ‘File’ exists as both a data type and a global Variable. The Report was earlier developed with using Excel 2000, it was working fine. Any Suggestions will be appreciated. Thanks Kutan
Export your report as text and see if that variable is used more than once in your report. It is possible, for example, to create a data item called Customer and have a variable called Customer. Perhaps you have two automation variables for Excel? Django
Did you create that variable in both Global and Local with the same name?? it may causes an error. If u didn’t, try to change the version of all Automation Objects U did create in the report to Excel 2003. Hope this will help u 
Taye
It´s also possible that there are two Event-Function in Excel, 1st called e.g. APPLICATION::WORKBOOKPIVOTTABLEa 2nd called e.g. APPLICATION::WORKBOOKPIVOTTABLEb imho Navision can´t handle these because it cut´s the Name of the Funktions after a couple of Chars and so you have two functions with the same Name. There are two workarounds to handle this error: 1. Specifie your Automation Variable only with 1 Character, so you habe more space for the Function Name. 2. Export the Objekt as text, and delete one of these Functions manually. I had this Problem by Project Automation 