LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default Updating Links to a new spreadsheet

We are trying to update a spreadsheets links, which there are many, to a new
Source Workbook. The old Source workbook was called 2007, now the new Source
workbook is called 2008. We have attempted a find and replace, but each time
it asks us to go out and find the new workbook again to update the link.
This spreadsheet has so many links it would take a very long time to point to
the same workbook each time. Is there a faster/easier/better way to do this?

Thanks!
Trisha
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating links BMA Excel Discussion (Misc queries) 2 July 6th 07 12:46 PM
updating links Laura Jean Excel Worksheet Functions 1 August 19th 06 11:07 AM
Updating links Mr. Boyer Excel Worksheet Functions 0 June 1st 06 03:32 PM
Updating links Mike Links and Linking in Excel 1 August 17th 05 01:04 PM
Updating Links Doug Excel Worksheet Functions 0 February 16th 05 05:21 PM


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"