Excel "pseudo" ranges
 

I used a tool called "Name Manager" to summarize all of the ranges in a
spreadsheet. It surfaced a large number of ranges that end with the
following:

"_.wvu.PrintArea", "_.wvu.PrintTitles", "_.wvu.Cols", "_.wvu.Rows"

below are some examples:

Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B8 93_.wvu.PrintArea =Balance_Sheet!$A$1:$P$141
Bud Exp
Study-ITLF'!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu. PrintTitles ='Bud Exp
Study-ITLF'!$A:$B
Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B8 93_.wvu.Cols =Balance_Sheet!$S:$AG
Bud Exp Study-ITLF'!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu. Rows ='Bud
Exp Study-ITLF'!$50:$71

Anyone know what generates ranges like this?

Excel "pseudo" ranges
 

Bob Phillips has posted this list of (partial) names that excel uses:

*_FilterDatabase
*Print_Area
*Print_Titles
*wvu.*
*wrn.*
*!Criteria
*xlfn.*

(* is a wildcard that represents any string.)

Some of those are created by web queries, Advanced Filter, conversion from
xl2007 to earlier versions, maybe solver(???).

But that's not too definitive. I think I've seen some of those names that are
attributed to solver in workbooks that have never used solver.

All I know is that I'm careful to avoid deleting those names when I'm cleaning
names.

JonH wrote:

I used a tool called "Name Manager" to summarize all of the ranges in a
spreadsheet. It surfaced a large number of ranges that end with the
following:

"_.wvu.PrintArea", "_.wvu.PrintTitles", "_.wvu.Cols", "_.wvu.Rows"

below are some examples:

Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B8 93_.wvu.PrintArea =Balance_Sheet!$A$1:$P$141
Bud Exp
Study-ITLF'!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu. PrintTitles ='Bud Exp
Study-ITLF'!$A:$B
Balance_Sheet!Z_218A505F_A146_41E5_9BD6_6A8E8D88B8 93_.wvu.Cols =Balance_Sheet!$S:$AG
Bud Exp Study-ITLF'!Z_218A505F_A146_41E5_9BD6_6A8E8D88B893_.wvu. Rows ='Bud
Exp Study-ITLF'!$50:$71

Anyone know what generates ranges like this?

--

Dave Peterson