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.
|