440 Automation error

[raghu_ram]

Hi All,

We have an EVDRE submission templates we have been using for the

past few years and they worked fine but when we have users in BPC Excel

2007, we are getting a 440-Automation Error. This does not happen in

BPC Excel 2003.

SAP BPC 7.0 SP4

SQL Server 2005 SP2

Please advice.

Thanks in advacne.

Regards,

Raghu.

[Former Member]

Hello Raghu,

I have the same error:

I had installed BPC 7.5 SP07 and I have executed an upgrade to SP14. Any reports show this error.

What did you do with this issue?

Regards

Gustavo

[raghu_ram]

Hi Nilanjan,

This is happening only with the EVDRE report.

Regards,

Raghu.

[Former Member]

Hi Raghu,

Can you please try to create a similar EVDRE report and check whether that is working or not? I am guessing that the newly created EVDRE reports will definitely work.

[Former Member]

if you are using a mixed office 2003/2007 environment- you should make sure that the office 2007 folks have their default save as option set to excel 97-2003 format and not excel 2007 format (xls rather than xlsx)

With a mixed environment, the office 2003 users that open xlsx documents using the compatibility pack can cause corruption in xlsx files.

[raghu_ram]

Hi,

They have all the excel reports with the compatability mode.97-03

So what could be solution for this.

Raghu.

[Former Member]

Hi,

I would request you to try create one of the templates once again in office 2007. See if you are getting the same error or not.

[raghu_ram]

Hi Nilanjan,

Its the problem only with two of the EVDRE reports.

There are large amount of data in the two reports and really difficult to create them again from the scratch.

Please advice.

Raghu.

[Former Member]

Hi Raghu,

Since, this error is coming only in 2 reports, I am pretty sure that it is due to some design setting in these reports. If you have any macros, revisit them. There might be some problem with the macros or VB script.

I would suggest you to open a ticket with SAP.

[Former Member]

Hi Raghu,

Is this happening will only this EVDRE report or all the reports?