Knowledge Base

Welcome to The Carlisle Group's Knowledge Base.

Search or Ask a Question

This is a keyword search that looks for matching articles that contain one or more words specifically by a user in articles’ tags, title and content. Admin writes brief intro content here via admin end. If you are unable to find an answer to your issue, please submit an issue here.

Search the Knowledge Base

Back to Articles List

CAS Reports and Excel Named Ranges. | CAS

Added: 07/16/2012; Last Modified: 07/16/2012; Visits:1,830

Many CAS reports that have outputs to Excel also generate a Named Range reference to user convenience.  CAS will do it's best to name the ranges according to the report Title, Expression, Field Name, or Description.  If the range name cannot be created due to Excel limitation, CAS will do it's best to continue with the name prefixed with "Named_Range_". 

For example, the CAS field "OPT2" cannot be defined as a Excel Named Range.  OPT2 can be interpreted as a cell reference.  In this case CAS will convert OPT2 to Named_Range_OPT2.