Bex 3.5, Runtime error 1004; application or object defined error. <internal error> Problem when writing table: E_T_CEL

[sai_v]

Hi Frds,

One of our user is working on Bex3.5 workbook. User running multiple queries in a single workbook and when he is trying to copy and past the content in to a new tab he is getting and error like below

- Runtime error 1004; application-defined or object defined error

And also when he is trying to insert the query into new tab he is getting below error

- <internal error> Problem when writing table: E_T_CEL

When I searched in community, I found some thing to do some changes in Excel like below

In MS Excel -> Excel Options-> click Add In tab-> Manage Add Ins -> Uncheck "euro currency tools"

But after this change also user getting the same error messages. I also found that excel will have limitations in rows and columns level but user wants to execute the multiple queries in a single workbook.

User has MS office with 2010 and SAP Bex in 3.5 version

Can any one help on this.

[Former Member · Accepted solution]

Hi,

Please check below SAP note for your issue.

711442 - Problem when writing table: E_T_CEL

Regards,

Amit

[sai_v · Accepted solution]

Hi Amit,

Thank you. This is the right NOTE for my issue.

Regards,

Sai.