Change Source of Links

[CL]

Dear experts:

I use publisher 2000 to generate reports for my company. We use same
format for each report and I keep the frame and format of the report
in Publisher.
I made link with excel file where I can easily do my calculation.

The problem is each report comes up with new excel file, I mean
different excel file name. I have to change source of link. I tried
to use the "Edit - Link - Change Source" funtion. It only allows me
to change file name (i.e. 2003 summary report.xls!Sheet 1!R1C1:R100C50
=> 2003 SUMMART REPORT (3).XLS) but not allow me to set range in that
specific file.

Is there anyone know how to change source not just file name but also
specific range? Please, please, please help me.

Thanks.

J.Y.

 

[°°°M°S°°Publisher°°°]

It is so quick to dump the old link and add a new one, I would not have
thought messing around editing the linked file name and range would be a
waste of time.
I would not expect to see any change from the way it presently works.

--