Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have thousands of links to many consolidated spreadsheets created in Excel
2003. Now that I use Excel 2007, how do I convert the links without breaking them. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Apr 21, 2:06*pm, June wrote:
I have thousands of links to many consolidated spreadsheets created in Excel 2003. *Now that I use Excel 2007, how do I convert the links without breaking them. After making a copy of your workbook, try to search and replace ".xls" with ".xlms" Hope this helps, Chris M. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It's not clear what you've converted. Is it fair to assume you have already
converted some xls files to xlsm files, but you have sheets/books that now refer to the old and nonexistent xls file? One a COPY of your book with the broken links you could do a search for the old filename and replace with the new. Use Ctrl-H to bring up the dialog box, and be sure to expand the Options and select Within workbook "June" wrote: I have thousands of links to many consolidated spreadsheets created in Excel 2003. Now that I use Excel 2007, how do I convert the links without breaking them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Links between Sheets | Excel Discussion (Misc queries) | |||
Update all Sheets | Excel Discussion (Misc queries) | |||
How to update links between wk sheets | Excel Worksheet Functions | |||
Links between sheets | Excel Discussion (Misc queries) |