I have a summary spreadsheet which pulls in data from a central spreadsheet (masterWIP.xls)to show breakdowns on a weekly basis.

I need to change the name of the central spreadsheet to master.xls as it is no longer the work in progress file. My summary spreadsheet is still pulling the data through using the old workbook name in the external reference, but I would prefer to update the external references so that they reflect the new name of the summary file and in case I need to use the WIP file in the future. However, I don't know how to do this without going into every cell.

I found a handy guide to this at http://www.likeoffice.com/site/detai...k_for_all_exte but it is for Excel 2007 and I am still on 2003...

Can anyone tell me how to do this in Excel 2003?

Thanks