Charts formed from Name ranges

[crack100]

Hi ,


I have built a chart using dynamic named ranges. The problem that I am facing is I tested it on two systems . One system the charts works fine but the other system the charts does not work . Both are excel 2007. Now the error that I get is if I see the chart data source from one system it is showing "<filename>!<dynamic name range>". The other file shows the chart data source as "0!<dynamic name range>". What should I be checking so that it works in the other system as well?


Thank you in advance,

 

[bobhc]

Good day crack100


When you copy the charts over you are copying the full workbook ??

 

[crack100]

Yes I am making a copy of the workbook and then using it in the other system.

 

[SirJB7]

Hi, crack100!

I guess that the chart which shows "<filename>!<dynamic name range>" is that of the copied system, isn't it? If so, than happened when you copied your chart workbook, because Excel keeps on trying to point to the original data source.

Tried copying both workbooks, chart & source to the same folder structures or to same folder in target machine?

Regards!

 

[crack100]

Hi Sir,


Yeah so the way my charts are built is the data source for the charts are in the same workbook as the charts are in. So it is just one standalone workbook .

 

[crack100]

Sir , To check this what are the possible settings that I should look for that would be different in the two systems. As the file is running in one system but not in other.