In Excel 2003, there's an option to specify the whole workbook when doing a
search and replace. This would get around having to S&R on each worksheet in
a workbook. Otherwise, you might have to write some VBA Code. As far as
S&Ring over multiple workbooks, i'd suggest you DEFINITELY need some VBA code!

Regards

Pete

"Tee" wrote:

The company that I work for has recently changed their name, we have
literally thousands of spreadsheets with the old name on. Is there any way
that I can do edit replace over a whole file?