I
Irene Shimizu
I am using both Word and Excel 2000. I create documents
that contain links to Excel spreadsheets, sometime there
are links to 3 or more spreadsheets (all the same
workbook). My company is planning to change the location
of my documents to a new server. When this is done, my
documents will not be able to access the Excel
spreadsheets since the path will have changed. I have
close to 1,000 documents, so opening each document and
changing the source location is not practical. Is there a
way to automatically update the path for all the documents?
I hope someone can give me an easy solution.
Thanks for your time
Irene
that contain links to Excel spreadsheets, sometime there
are links to 3 or more spreadsheets (all the same
workbook). My company is planning to change the location
of my documents to a new server. When this is done, my
documents will not be able to access the Excel
spreadsheets since the path will have changed. I have
close to 1,000 documents, so opening each document and
changing the source location is not practical. Is there a
way to automatically update the path for all the documents?
I hope someone can give me an easy solution.
Thanks for your time
Irene