Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I making a workbook that will have approx. 130 charts and name each tab as I
go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Excel 2007;
I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Shane, I've seen something similar in PowerPoint 2007. When the
presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hay Barb,
that's great input. When I send this topic to MS I will include this information if you don't mind. By the way how do you like PP 2007? -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: Shane, I've seen something similar in PowerPoint 2007. When the presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#7
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I believe the PowerPoint issue has been reported but you can add it. It may
be related. How do I like PowerPoint 2007? I haven't used it a whole lot, but I don't like that some of my footers that were in the 2003 version don't always show in 2007. I'm still on the learning curve to find where everything is in both Excel and PowerPoint and don't like that part at all. Barb "ShaneDevenshire" wrote: Hay Barb, that's great input. When I send this topic to MS I will include this information if you don't mind. By the way how do you like PP 2007? -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: Shane, I've seen something similar in PowerPoint 2007. When the presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#8
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The same has happened to me for quite a while. I made a half-hearted attempt
to get an answer from Microsoft tech support but they didn't seem to acknowledge the problem. Some of my workbooks are fine, others have the problem. I wonder if the workbook where you've experienced the problem includes data retrieved from an outside source. Geoff "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#9
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Folks,
I've posted the bug to Microsoft. Thanks for all your input. -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: I believe the PowerPoint issue has been reported but you can add it. It may be related. How do I like PowerPoint 2007? I haven't used it a whole lot, but I don't like that some of my footers that were in the 2003 version don't always show in 2007. I'm still on the learning curve to find where everything is in both Excel and PowerPoint and don't like that part at all. Barb "ShaneDevenshire" wrote: Hay Barb, that's great input. When I send this topic to MS I will include this information if you don't mind. By the way how do you like PP 2007? -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: Shane, I've seen something similar in PowerPoint 2007. When the presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#10
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
This same problem has been happening to me as well ever since I switched over
to 2007 last spring. As with others, it is more than a bit frustrating when the actual names are relied on and then get switched back to default Chart 1, Chart 2, etc. Isn't there any MVP out there that can get MS to look into this? -- javablood "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#11
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Shane,
Was the bug fixed? I have just recently encountered this problem (July 2009). I'm assuming that my employer's tech support has applied all recent updates. Thanks Laura "ShaneDevenshire" wrote: Hi Folks, I've posted the bug to Microsoft. Thanks for all your input. -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: I believe the PowerPoint issue has been reported but you can add it. It may be related. How do I like PowerPoint 2007? I haven't used it a whole lot, but I don't like that some of my footers that were in the 2003 version don't always show in 2007. I'm still on the learning curve to find where everything is in both Excel and PowerPoint and don't like that part at all. Barb "ShaneDevenshire" wrote: Hay Barb, that's great input. When I send this topic to MS I will include this information if you don't mind. By the way how do you like PP 2007? -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: Shane, I've seen something similar in PowerPoint 2007. When the presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#12
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi - all the workbooks we have, the chart tabs rename themselves. It is very
annoying. Is there a fix yet? "Laura604" wrote: Hi Shane, Was the bug fixed? I have just recently encountered this problem (July 2009). I'm assuming that my employer's tech support has applied all recent updates. Thanks Laura "ShaneDevenshire" wrote: Hi Folks, I've posted the bug to Microsoft. Thanks for all your input. -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: I believe the PowerPoint issue has been reported but you can add it. It may be related. How do I like PowerPoint 2007? I haven't used it a whole lot, but I don't like that some of my footers that were in the 2003 version don't always show in 2007. I'm still on the learning curve to find where everything is in both Excel and PowerPoint and don't like that part at all. Barb "ShaneDevenshire" wrote: Hay Barb, that's great input. When I send this topic to MS I will include this information if you don't mind. By the way how do you like PP 2007? -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: Shane, I've seen something similar in PowerPoint 2007. When the presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#13
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Has a solution been found to this problem yet? We switched to 2007 in the
spring. I have a workbook that worked fine until recently. I opened the workbook and all of my charts have been renamed. "javablood" wrote: This same problem has been happening to me as well ever since I switched over to 2007 last spring. As with others, it is more than a bit frustrating when the actual names are relied on and then get switched back to default Chart 1, Chart 2, etc. Isn't there any MVP out there that can get MS to look into this? -- javablood "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#14
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
My charts are still renaming themselves as well. It is November 2009. Is
there someone at MicroSoft we can contact? This is getting old. "KarenW" wrote: Has a solution been found to this problem yet? We switched to 2007 in the spring. I have a workbook that worked fine until recently. I opened the workbook and all of my charts have been renamed. "javablood" wrote: This same problem has been happening to me as well ever since I switched over to 2007 last spring. As with others, it is more than a bit frustrating when the actual names are relied on and then get switched back to default Chart 1, Chart 2, etc. Isn't there any MVP out there that can get MS to look into this? -- javablood "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#15
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Shane
Do you know if there has been a fix for this issue yet? I have spent hours recreating charts in 2007 rather than converting from 2003 as I thought this was the problem, but the problem has just recurred in my new workbook. I am creating many links between workbooks and 2007 seems to really struggle with it. 2003 was much better. regards James "ShaneDevenshire" wrote: Hi Folks, I've posted the bug to Microsoft. Thanks for all your input. -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: I believe the PowerPoint issue has been reported but you can add it. It may be related. How do I like PowerPoint 2007? I haven't used it a whole lot, but I don't like that some of my footers that were in the 2003 version don't always show in 2007. I'm still on the learning curve to find where everything is in both Excel and PowerPoint and don't like that part at all. Barb "ShaneDevenshire" wrote: Hay Barb, that's great input. When I send this topic to MS I will include this information if you don't mind. By the way how do you like PP 2007? -- Thanks, Shane Devenshire "Barb Reinhardt" wrote: Shane, I've seen something similar in PowerPoint 2007. When the presentation was opened in 2007 is had a .ppt extension and had slides with names that I'd set (other than the default names). When I saved the presentation as a .ppt (97-2003?), all of the slide names changed back to Slide1, Slide2, Slide3 format. The only way I was able to keep the slide names with the slides, if the presentation was edited in 2007 was to save as a 2007 format. -- HTH, Barb Reinhardt "ShaneDevenshire" wrote: Hi, No, I've never seen it, I'm just trying to gather info to send to Microsoft, or better yet discover a fix myself. At first I though maybe you had saved a copy of the file before renaming the tabs and then either opened that copy rather than the modified one, or had not saved the modified version. There was another post on this same problem. http://www.microsoft.com/communities...&cr=&sloc=&p=1 By the way about how many chart did you have in the WB when this happened? (as chart sheets, not embedded charts). -- Thanks, Shane Devenshire "wgnewman" wrote: Excel 2007; I created/inserted charts and relocated each as a new page in workbook and renamed tabs from "chart 1" to data name; Yes, chart 1, chart 2 . . ; I assume and hope they are in original order. I will have to go back and check each data source and ensure correct matches. I've made thousands of charts in Excel 2003 and this never happened. I take it that you don't know what caused it or how to prevent it from happening again, or do you? Thanks so much for responding. "ShaneDevenshire" wrote: Hi, Since I have heard of another case of this, what version of Excel are you using? Did the workbook have all the tabs in it before you started adding the chart, so that as you added charts you names each tab? Or did you create and name a tab and then continue? When you say numerals what do you mean - 1, 2, 3, 4 or Chart 1, Chart 2, .... or Sheet1, Sheet2, Sheet3...? Are the sheet numbers in their original order, that is are they named from left to right in the same order as they were before you named them or are they in a random order? -- Thanks, Shane Devenshire "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#16
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
It's Feb, 2010 and the problem still exists, very frustrating. Names stay on
some workbooks and get changed to chart1, chart2, etc. on others. Even worse, sometimes the new names stay for several times, suggesting the problem is solved, then they change. Doesn't appear to be affected by updating from outside sources. "Birmingham Futures" wrote: My charts are still renaming themselves as well. It is November 2009. Is there someone at MicroSoft we can contact? This is getting old. "KarenW" wrote: Has a solution been found to this problem yet? We switched to 2007 in the spring. I have a workbook that worked fine until recently. I opened the workbook and all of my charts have been renamed. "javablood" wrote: This same problem has been happening to me as well ever since I switched over to 2007 last spring. As with others, it is more than a bit frustrating when the actual names are relied on and then get switched back to default Chart 1, Chart 2, etc. Isn't there any MVP out there that can get MS to look into this? -- javablood "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
#17
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Is there a chance we can get the Microsoft incident number so my company can
reference it when we open our incident??? "wgnewman" wrote: I making a workbook that will have approx. 130 charts and name each tab as I go. Yesterday, I finished up number 68 and this morn I opened the workbook and found that ALL the tabs have converted to numerals! What would cause that? I depended on the tab names to inform me of alignment of data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disappearing Chart Worksheet Names | Excel Discussion (Misc queries) | |||
can worksheet names be changed by changing certain cells? | Excel Worksheet Functions | |||
How do I create a list (Word) of the names on Excel worksheet tabs | Excel Worksheet Functions | |||
How do I print worksheet tabs names from exel 2003 | Excel Discussion (Misc queries) | |||
Worksheet Tabs Names as Dates | Excel Worksheet Functions |