You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Are Named Ranges in excel report output generated by FCCS MR referenced anywhere?

in Financial Consolidation and Close 7 comments

Summary:

Getting an error message to repair the excel report due to named ranges generated by the application. Need suggestions to deal with it.

Content (please ensure you mask any confidential information):

We have used a book to club our reports and generated the output in excel format. The output is a workbook containing multiple sheets/tabs. These tabs are split into separate excel file using python scripting. We observed that once the output is generated, there are named ranges created by the application for each tab of the workbook and they are retained even after they are split into separate files. There is this particular named range that is referencing the entire workbook and we are getting an error while accessing that excel because of the named ranges. Posting the error

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!