Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 10, 05:21 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 18
Default Linked Workbooks - change in file location

Hi there,

I recently changed the folder locations of a couple files. Now I find that I
cannot update the links. I keep the destination file open and close the other
excel workbooks and then I update Values and choose the correct file and it
doesn't stick. They keep showing up as Error: Source not found. How can I
connect these worksheets.

Thanks,

Meme

  #2   Report Post  
Old January 6th 10, 09:12 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
Default Linked Workbooks - change in file location

Does Edit Links Change Source, followed by saving the workbook not
work for you?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



Reply
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
Creating a linked file based on variable location reference Monk[_2_] Excel Discussion (Misc queries) 2 May 18th 08 10:47 AM
pathnames to linked workbooks change from mapped drive to UNC occasionally Larry Wrinn Links and Linking in Excel 0 March 3rd 08 04:14 PM
Locking linked file location in a formula ScottL Excel Discussion (Misc queries) 0 July 9th 07 07:50 PM
Find/Replace Linked Cells Prompts File Location Inquisitive1 Links and Linking in Excel 4 October 20th 05 01:40 PM
Utility to change location of linked tables? Laurel New Users to Excel 1 August 6th 05 04:50 PM


All times are GMT +1. The time now is 08:57 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017