conversion from 2003 to 2007
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. |
conversion from 2003 to 2007
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. |
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com