Don't have an immediate solution for you, but I ran into a similar
problem -- actually worse -- as you.

I created a drop down combo box in a chart on its own sheet. The combo
box has a source range of =TeamList, where TeamList is a range on a
worksheet. The chart and combo box work fine when created. After
saving, closing, and reopening the file, the combo box is no longer
linked to TeamList. Worse, if I try and reestablish the list, XL
crashes.

Happens consistently on XL2003. Haven't had time to research the issue
further.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
Hello,

I am having a problem with a dynamic chart title and saving, closing and
then re-opening the workbook and the chart title still being dynamic.

On Sheet2 of my workbook I have some drop-down menus in cells B2:E2.

On Sheet7 of my workbook in cells BA1:BA3 I have Concatenation formulas that
I want to use as my Chart titles.
For example: =CONCATENATE("This is my " Sheet2!$B$2, " ", "chart.")

I named the ranges on Sheet7, BA1 is named "FAC", BA2 is named "POD" and BA3
is named "NAF".

I then added a text box to my first chart where the chart title should go.
In the text box I put the formula =FAC.

Then I go back to Sheet2 change my options in my drop down menus, come back
to Sheet7 to make sure it worked and it does.

But, when I save the workbook, close it and re-open it, the text box seems
to "forget" the range that I had put in there and I have to do it all over
again.

How do I make the text box "remember" from save to save and open - close -
re-open?

This is the web site I used as a guide to accomplish this:
http://www.tushar-mehta.com/excel/ne...rts/index.html

TIA,

Sharon