I have a series of workbooks (about 40) that are linked to a master workbook.
Information from the master workbook is also linked to various worksheets
within the 40 workbooks.
Our office is converting to 2007 and one of the problems will be changing
all the .xls file references which are not valid references in 2007. There
are approximately 58,000 file extension references in each worksheet and each
workbook.

can I do a general find/replace search to change the extensions.

Also is there any other problems with converting to 2007 that will effect my
macros.

Select the first sheet of the master book, and press ctrl + shift + Page down
to select every sheet in the book.

Then:

1. Press Ctrl + H to bring up find and replace. Find ".xslx" and replace
with ".xls"
2. Another find and replace, find ".xls" and replace with ".xlsx"

You have to do step 1 fist or you'll replace every existing instance of
..xlsx with a .xlsxx

Sam

"carourke" wrote:

I have a series of workbooks (about 40) that are linked to a master workbook.
Information from the master workbook is also linked to various worksheets
within the 40 workbooks.
Our office is converting to 2007 and one of the problems will be changing
all the .xls file references which are not valid references in 2007. There
are approximately 58,000 file extension references in each worksheet and each
workbook.

can I do a general find/replace search to change the extensions.

Also is there any other problems with converting to 2007 that will effect my
macros.