Error in using Excel Import/Export

Dynamics 365 Business Central/NAV Developers Forum
1

Hi everyone,
I am trying to export some report data to excel.
I used the table 370 Excel buffer and specially the function AddColumn
When I run the report, I get the following error:
This message is for C/AL programmers:

Could not invoke the member Range. The OLE control or Automation server returned an unknown
error code.

I am using Nav 20009 R2 Classic, SQL Server 2008 R2, Office 2013 Professional.
What seems to be the problem?
Thanks in advance :)

2

What Office version are you using? With NAV 2009 32-bit Office installation is recommended.

3

I have Office 2013 64-bit installed and it used to work just fine…

I don’t know what happened…