The case is:

I have created a dynamic graph. It works fine. But today i recognize that
the file name which is excel using gets crashed. Let me explain.

I have 2 formulas with names one is "stock" and the other is "year". In the
graph when try to locate the formulas i add "=sheet1!stock" to the series and
"=sheet1!year" to the rows. Excel changes themm to dynamic file names as
"=file_name!stock" and "=file_name!year". No problem till here. It works very
fine. But when i close the file and open it again the names used in the graph
has been gone. It changes the formulas to "=[0]!stock" and "[0]!year" . So
bounded to the formula graphs won't work. I can't understand where is the
problem, can anyone help!