 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / June 2006Dead links retreiving data?
Hi, I have a cell linked to a file that no longer exists. After this file was deleted, I expected to see "#REF" in the cell. (I always update links when opening files.) However, the cell contained the data from the last time the link was valid. Any idea why a link to a file that doesn't exist is bring back data? Thx. By design. Otherwise, the first time you opened a file when a network link wqs down, etc., you would lose the link Edit|Links allows will bring up a box that will allow you to update links, change then source, delete dead links, or change them to their current values. > Hi, > I have a cell linked to a file that no longer exists. After this file [quoted text clipped - 4 lines] > > Thx. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.