TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Updating Links To The Current Workbook

When you combine two previously separate workbooks that shared linked formulas, you may end up with some formulas in the newly combined workbook that are still linked back to the old workbook, which you are probably going to delete. Instead, you want these links to refer to the current workbook.

Fixing all of these links could be quite a task. But rather than editing them one by one, simply click Edit, Links, Change Source, browse to find the current workbook (Yes, the one you have open). Click on the filename and click OK.

All the links will update to the new combined workbook.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window