 |
 | 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 / October 2003How do you find the Link
Someone in our office has opened an Excel sheet & the following message came up 'The workbook you opened contains automatic links to information in another workbook. Do you want this workbook with changes made to the other workbook? To update all linked information, click, Yes. To Keep the existing information click, No' The issue is this person cannot find where the links are in his folders so he can go ahead & delete them. He apparently does not want this to be linked but to have it seperate. How can he find what sheets this is linked. He has a 'C' drive, 'H' drive for his personal folders & a share drive. Thank you hi there, you can usually go to Edit-->Links and see them in there. Another place is in a named range, so go to Insert-->Name-->Define and you may see a named range that references another spreadsheet. HTH, katherine > Someone in our office has opened an Excel sheet & the following message came up 'The workbook you opened contains automatic links to information in another workbook. Do you want this workbook with changes made to the other workbook? > To update all linked information, click, Yes. > To Keep the existing information click, No' > > The issue is this person cannot find where the links are in his folders so he can go ahead & delete them. He apparently does not want this to be linked but to have it seperate. How can he find what sheets this is linked. He has a 'C' drive, 'H' drive for his personal folders & a share drive. Thank you Navigator Utilities will find all your links, including those in Names and many other places such as behind buttons or other objects. Check out the Link Navigator in Navigator Utilities. Free download at www.robbo.com.au. Lots of other useful stuff for navigating around spreadsheets too. regards Mark > Someone in our office has opened an Excel sheet & the following message came up 'The workbook you opened contains automatic links to information in another workbook. Do you want this workbook with changes made to the other workbook? > To update all linked information, click, Yes. > To Keep the existing information click, No' > > The issue is this person cannot find where the links are in his folders so he can go ahead & delete them. He apparently does not want this to be linked but to have it seperate. How can he find what sheets this is linked. He has a 'C' drive, 'H' drive for his personal folders & a share drive. Thank you |
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.