Error: “Essbase has encountered an internal Excel error” When Retrieving in Excel With Essbase Excel Add-In 11.1.1.3

Applies to:

 
Hyperion Essbase – Version: 11.1.1.3.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Confirmed Bug Status on 07-Mar-2011

Symptoms
Error: “Essbase has encountered an internal Excel error. Your sheet will not be overwritten and none of your data will be lost. However, you are strongly urged to exit Excel and restart in order to clear up the problem”

This error occurs when retrieving in Excel with Essbase Excel Add-In 11.1.1.3.

Cause
The Excel Add-in can only support the number of columns that Excel 2003 supports.

This issue has been verified unpublished Bug 9160216 – Internal Essbase error when lock or retrieve section on complicated spreadsheet.

Solution
This has been documented in the 11.1.1.3.5 readme:
Spreadsheet Add-in. When using Spreadsheet Add-in on Microsoft Office, performing a retrieve or lock on a particularly complex worksheet can cause an internal Excel error. Users may see an error message such as this:
“Essbase has encountered an internal Excel error. Your sheet will not be overwritten and none of your data will be lost. However, you are strongly urged to exit Excel and restart in order to clear up the problem.”
To avoid this situation, Oracle recommends that you take steps to reduce the complexity of the worksheet. For example, if your worksheet contains large ranges which are not required, reduce ranges by deleting or hiding unnecessary columns or rows.

The following workaround may also resolve the issue:

1. Open your Excel Workbook.
2. Go to File -> Save As and save it as an ‘Excel 97-2003 Workbook’.
3. Close and re-open this newly saved file.
4. Go to Files -> Save As and save it back as an ‘Excel Workbook’ (this will reset it as an Excel 2007 book).

You should now be able to retrieve without errors.

Another option is to use Smart View instead of the Excel Add-In.

Advertisements
This entry was posted in Oracle EPM, Oracle Essbase and tagged , , , . Bookmark the permalink.

5 Responses to Error: “Essbase has encountered an internal Excel error” When Retrieving in Excel With Essbase Excel Add-In 11.1.1.3

  1. I blog frequently and I genuinely appreciate your content.
    This article has truly peaked my interest. I am
    going to take a note of your blog and keep checking for new details about once per week.
    I opted in for your Feed as well.

  2. This totally worked. Thank you.

  3. Adele says:

    This is brilliant!! saved my at least 1 day to re-link all the file that linked to this retrieve sheet!

  4. Mikha says:

    Thank you, that helped me out a lot 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s