How do I update links from .xls sheets to .xlms sheets
in [Functions]
|
Prev: COUNTIF: everything in a row larger than zero over multiple worksh
Next: How do i set up a concecutive numbers in Microsoft excel sheet?
From: June on 21 Apr 2010 15:06 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.
From: mcescher on 21 Apr 2010 15:22 On Apr 21, 2:06 pm, June <J...(a)discussions.microsoft.com> 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.
From: Duke Carey on 21 Apr 2010 15:57
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. |