Inactivating of "Paste special" while linking charts
 

Version: Excel 2003

Problem:

a) Linking data in forms of diagrams from one chart (1), to another (2), no
problem
b) Close down chart (2).
c) When reopening chart (2), it's impossible to link more data
dynamically(?) (Paste special) from chart (1), the commando has become
inactivated in chart (2). It's still possible to use the commando paste,
though.

I'd be very grateful if somebody knows how to activate "paste special" even
while reopening chart (2).
--
klodvig