E-NV: Unable To Set The ShowDetail Property Of The Range Class' Error For 'Microsoft Excel: '

(Doc ID 2228781.1)

Last updated on MARCH 12, 2018

Applies to:

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


nVision layouts with manual grouping of rows error out with the following message:
'Excel interface exception [E:\pt85512b-retail\peopletools\src\psnxl\gridapp.cpp:3803] Unable to set the ShowDetail property of the Range class' Error for 'Microsoft Excel: '. (28,160)

The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > PS/nVision > Define Report Request (Define ReportBook)
3. Run a report
4. Notice the error in Process Monitor.


This error can also occur if a formula is inadvertently placed in an intersection of layout definition criteria that also includes an nPlosion option.




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