Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update links from .xls sheets to .xlms sheets
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
|
|||
|
|||
How do I update links from .xls sheets to .xlms sheets
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
|
|||
|
|||
How do I update links from .xls sheets to .xlms sheets
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 | |
|
|
Similar Threads | ||||
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) |