I hace created graphs in microsoft with the data of teh graph being copied to
teh data sheet of teh graph. this has been done using the copy command for
the excel data and paste link command in teh graph data sheet. The datasheet
of the graph is not updated with changes to teh excel worksheet automatically
but only when i double teh chart and open it.

is theer a way i could have teh datasheet of teh graph updated automatically.