Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
Hi All.......
I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
A possible solution....
I'm guessing the "bad" range names on the other sheets are sheet-level names. Are the range names on the Main sheet workbook-level names or sheet-level names? If they're workbook level names....you should be able to just delete the range names on the other sheets...the formulas would then reference the workbook level names. Does that help? *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hi All....... I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
Hmmmm.....didn't know there was two kinds of RangeNames......have always been
able to access any that I created from any sheet in the book. I just went to a secondary sheet and tried to delete a RangeName and the whole workbook crashed. Maybe it's got molasses in it's crankcase, 'er sumpthing. I can fix these by just re-doing them, but was wondering what happened so maybe can keep it from happening again. Thanks anyway Ron, Vaya con Dios, Chuck, CABGx3 "Ron Coderre" wrote: A possible solution.... I'm guessing the "bad" range names on the other sheets are sheet-level names. Are the range names on the Main sheet workbook-level names or sheet-level names? If they're workbook level names....you should be able to just delete the range names on the other sheets...the formulas would then reference the workbook level names. Does that help? *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hi All....... I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
Sorry about the crash...deleting a range name shouldn't trigger that.
Sounds like that workbook has had a rough life. <g *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hmmmm.....didn't know there was two kinds of RangeNames......have always been able to access any that I created from any sheet in the book. I just went to a secondary sheet and tried to delete a RangeName and the whole workbook crashed. Maybe it's got molasses in it's crankcase, 'er sumpthing. I can fix these by just re-doing them, but was wondering what happened so maybe can keep it from happening again. Thanks anyway Ron, Vaya con Dios, Chuck, CABGx3 "Ron Coderre" wrote: A possible solution.... I'm guessing the "bad" range names on the other sheets are sheet-level names. Are the range names on the Main sheet workbook-level names or sheet-level names? If they're workbook level names....you should be able to just delete the range names on the other sheets...the formulas would then reference the workbook level names. Does that help? *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hi All....... I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
That would give #NAME?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Ron Coderre" wrote in message ... A possible solution.... I'm guessing the "bad" range names on the other sheets are sheet-level names. Are the range names on the Main sheet workbook-level names or sheet-level names? If they're workbook level names....you should be able to just delete the range names on the other sheets...the formulas would then reference the workbook level names. Does that help? *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hi All....... I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
No problem, I've gotten used to crashes around here........."rough life",
yep, it's kinda grown-up with me and has been rode hard and put away wet a lot........ Thanks for trying tho.... Vaya con Dios, Chuck, CABGx3 "Ron Coderre" wrote: Sorry about the crash...deleting a range name shouldn't trigger that. Sounds like that workbook has had a rough life. <g *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hmmmm.....didn't know there was two kinds of RangeNames......have always been able to access any that I created from any sheet in the book. I just went to a secondary sheet and tried to delete a RangeName and the whole workbook crashed. Maybe it's got molasses in it's crankcase, 'er sumpthing. I can fix these by just re-doing them, but was wondering what happened so maybe can keep it from happening again. Thanks anyway Ron, Vaya con Dios, Chuck, CABGx3 "Ron Coderre" wrote: A possible solution.... I'm guessing the "bad" range names on the other sheets are sheet-level names. Are the range names on the Main sheet workbook-level names or sheet-level names? If they're workbook level names....you should be able to just delete the range names on the other sheets...the formulas would then reference the workbook level names. Does that help? *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hi All....... I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Home on the RANGE
On Sheet1
<insert<Name<Define Names in Workbook: MyValue Refers to: Sheet1!A1 Click [OK] A1: WkbkName Then On Sheet2 <insert<Name<Define Names in Workbook: Sheet2!MyValue Refers to: Sheet2!A1 Click [OK] A1: SheetName Still on Sheet2 B1: =MyValue (B1 returns "SheetName") <insert<Name<Define Names in Workbook: MyValue Click the [Delete] button (B1 returns "WkbkName") Am I missing something? *********** Regards, Ron XL2002, WinXP "Bob Phillips" wrote: That would give #NAME? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Ron Coderre" wrote in message ... A possible solution.... I'm guessing the "bad" range names on the other sheets are sheet-level names. Are the range names on the Main sheet workbook-level names or sheet-level names? If they're workbook level names....you should be able to just delete the range names on the other sheets...the formulas would then reference the workbook level names. Does that help? *********** Regards, Ron XL2002, WinXP "CLR" wrote: Hi All....... I have an old "many times modified" workbook that has RangeNamed cells on it's Main sheet which work just fine. But if I switch to another sheet, all results for those RangeNames return #REF! on those sheets, and to do Insert Name Define while on one of those sheets, shows the address of the Range at #Ref!$A$3 or whatever, but on the Main sheet still shows the correct address. Only by hand re-typing the MainSheet name part of the address in the Insert Name Define window while on one of the other sheets seems to correct the problem. Any ideas what I might have done to have caused this? Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions |