Insert...Name Range

[Guest]

Hello:

I have a named range within Microsoft Excel that I created as an ODBC within
Crystal Reports. I did this in Excel by choosing Insert...Name...Define. It's
working perfectly!

Now, if the spreadsheet gets updated monthly by adding additional rows, will
the range in Excel and for the Crystal ODBC connection be updated
automatically?

If not, is there a way to do such an update?

Thanks!

childofthe1980s

 

[Jim Rech]

I haven't used Crystal Reports so I don't know if it has the capability to
adjust ranges names, however if you assign a name to the range A1:A10 and
then type data in A11, Excel has no feature to redefine the name
automatically. However if you select cell A10 and insert a row, so that
what was in A10 is now in A11, the range name will be redined as A1:A11.

It is possible to create self-expanding names that are actually formulas
that return ranges. There are restrictions however. Create a new name like
"Rg" and define it as =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1). Now
if there are entries in A1 and A2 Rg will be A1:A2. Add an entry to A3 and
Rg becomes A1:A3. (Press F5 and enter "Rg" to check this).

However for this to work there must be contiguous entries in A1 and
downward. No gaps and no extraneous entries below the data.

--
Jim
message | Hello:
|
| I have a named range within Microsoft Excel that I created as an ODBC
within
| Crystal Reports. I did this in Excel by choosing Insert...Name...Define.
It's
| working perfectly!
|
| Now, if the spreadsheet gets updated monthly by adding additional rows,
will
| the range in Excel and for the Crystal ODBC connection be updated
| automatically?
|
| If not, is there a way to do such an update?
|
| Thanks!
|
| childofthe1980s
|