View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
wgnewman wgnewman is offline
external usenet poster
 
Posts: 6
Default Worksheet/chart tabs changed names!

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.