Compatibility Mode error w/ Defined Names

[DocBrown]

I can't quite figure why I'm getting this error. I have two workbook
templates called 'Budgets' and 'Accounts'. 'Budgets' has worksheets: 'Lists'
and 'Budget Template'. Accounts has WS: 'Lists' and 'Account Template'

I have a macro in 'Accounts' WB that checks if 'Lists' in Budget WB is newer
and if so, deletes 'Lists' and copies 'Lists' from the 'Budget' workbook.

The hitch is that when I save the file after the copy I get the following:
------------------------
Compatibility Report for Account.xlt
Run on 1/20/2010 19:28

The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.

Minor loss of fidelity

Some formulas in this workbook are linked to other workbooks that are
closed. When these formulas are recalculated in earlier versions of Excel
without opening the linked workbooks, characters beyond the 255-character
limit cannot be returned.


# of occurrences
1
Defined Names
--------------------

By luck I found that there's a Defined Name that is getting copied
unexpectedly. The Defined Name is called 'Bud_ExpenditureTable' and the
Refersto is:

='Budget Template'!$D$30,'Budget Template'!$R$159

The scope is Workbook.

The really unknown issues is that if I delete the second range, the Defined
name does not get copied. Also, There are other Defined names in the 'Budget'
WB that refer to the 'Budget Template' and are scope workbook that don't get
copied.

So why is this one, with two ranges, getting copied when I copy the 'Lists'
WS? Any ideas how to fix it?

 

[Juantonio123]

I can't quite figure why I'm getting this error. I have two workbook
templates called 'Budgets' and 'Accounts'. 'Budgets' has worksheets: 'Lists'
and 'Budget Template'. Accounts has WS: 'Lists' and 'Account Template'

I have a macro in 'Accounts' WB that checks if 'Lists' in Budget WB is newer
and if so, deletes 'Lists' and copies 'Lists' from the 'Budget' workbook.

The hitch is that when I save the file after the copy I get the following:
------------------------
Compatibility Report for Account.xlt
Run on 1/20/2010 19:28

The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.

Minor loss of fidelity

Some formulas in this workbook are linked to other workbooks that are
closed. When these formulas are recalculated in earlier versions of Excel
without opening the linked workbooks, characters beyond the 255-character
limit cannot be returned.

# of occurrences
      1
Defined Names
--------------------

By luck I found that there's a Defined Name that is getting copied
unexpectedly. The Defined Name is called 'Bud_ExpenditureTable' and the
Refersto is:

='Budget Template'!$D$30,'Budget Template'!$R$159

The scope is Workbook.

The really unknown issues is that if I delete the second range, the Defined
name does not get copied. Also, There are other Defined names in the 'Budget'
WB that refer to the 'Budget Template' and are scope workbook that don't get
copied.

So why is this one, with two ranges, getting copied when I copy the 'Lists'
WS? Any ideas how to fix it?

Looks like a bug, though probably not one Msoft would care much about.
They've chosen to err hugely on the side of inclusiveness when taking
in names as sheets are copied.
Happens to me in 2003 as well as 2007. Even using INDIRECT in the name
definition rather than a direct reference. Don't see any simple
workaround beyond having the macro delete the name after the copy or
naming the cells individually and referring to both names in any
formulas that previously used just the one.
Best,