D
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?
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?