Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strange Named Ranges
I'm using Excel 2007 and am getting some compatibility errors when saving a
file as a .xls file. Anyway, I'm checking the named ranges and when I list them out using some code I prepared, I have a bunch of names that look like this: Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.Cols Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.PrintArea Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.Cols Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.PrintArea Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.Cols Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.PrintArea I do have a worksheet 'Defect Summary', but I don't know where the Z_ ... part came from. I have another handful that apply to another worksheet. Can someone shed some light on the source of these? They also don't display in the name manager within Excel. Thanks, Barb Reinhardt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strange Named Ranges
I've done some Googling and found references to names like this being tied to
CustomViews. I checked the workbook and there are no customViews. Might these be artifacts of old ones? Thanks, Barb Reinhardt "Barb Reinhardt" wrote: I'm using Excel 2007 and am getting some compatibility errors when saving a file as a .xls file. Anyway, I'm checking the named ranges and when I list them out using some code I prepared, I have a bunch of names that look like this: Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.Cols Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.PrintArea Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.Cols Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.PrintArea Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.Cols Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.PrintArea I do have a worksheet 'Defect Summary', but I don't know where the Z_ ... part came from. I have another handful that apply to another worksheet. Can someone shed some light on the source of these? They also don't display in the name manager within Excel. Thanks, Barb Reinhardt |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strange Named Ranges
I've done some Googling and found references to names like this being tied to
CustomViews. I checked the workbook and there are no customViews. Might these be artifacts of old ones? Thanks, Barb Reinhardt "Barb Reinhardt" wrote: I'm using Excel 2007 and am getting some compatibility errors when saving a file as a .xls file. Anyway, I'm checking the named ranges and when I list them out using some code I prepared, I have a bunch of names that look like this: Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.Cols Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.PrintArea Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.Cols Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.PrintArea Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.Cols Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.PrintArea I do have a worksheet 'Defect Summary', but I don't know where the Z_ ... part came from. I have another handful that apply to another worksheet. Can someone shed some light on the source of these? They also don't display in the name manager within Excel. Thanks, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using named 3-D ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
Strange named range issue with multiple workbooks | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions |