E-ExcelToCI: Getting "Excel found unreadable content ...", "Excel was able to open the file by repairing or removing the unreadable content. ..." and "Run-time Error '5' : ..." on Opening ExcelToCI2007.xlsm in Excel 2010 (Doc ID 2041604.1)

Last updated on AUGUST 07, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.

Symptoms

On PeopleToos 8.5x, trying to use the delivered template file "ExcelToCI2007.xlsm" in Microsoft Excel 2010.
The delivered complementary macro library file "RelLangMcro.xla" is present in the same directory folder.
However when trying to open the template file, get a sequence of warning and error messages as follows:

Excel found unreadable content in 'ExcelToCI2007.xlsm'. Do you want to recover the contents ...?
Excel was able to open the file by repairing or removing the unreadable content. ...
Run-time error '5': Invalid procedure call or argument

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms