Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Edit Links shows unknown status in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-02-2012
Member
 
Join Date: Feb 2012
Posts: 11
Edit Links shows unknown status in Microsoft Excel

First time posting here so apologies in advance if I am not using the correct format or procedure. I have a spreadsheet (Excel 2002) which links to 40 others to ensure the most recent data from each is used in the calculations. Links are set to update automatically when the file is opened, but when I look at the "Edit Links" option all the files show "Status" as "Unknown". Can anyone confirm that these links have actually been updated or should I use "Check Status" to ensure that all are fully refreshed.

Reply With Quote
  #2  
Old 24-02-2012
Member
 
Join Date: May 2011
Posts: 520
Re: Edit Links shows unknown status in Microsoft Excel

I see no one got to this one so here is a detailed discussion. On the Edit menu, click Links. The Links command is unavailable if your file does not contain linked information. Click Check Status to update the status for all links in the list. This may take a while if there are a lot of links, or if the source workbook for the links is on a network location, and the network is slow. Check the status in the Status column, select the link, and then take the action needed. OK No action required, the link is working and up to date. Unknown Click Check Status to update the status for all links in the list. Not applicable The link uses Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) or Dynamic Data Exchange (DDE) (Dynamic Data Exchange (DDE): An established protocol for exchanging data between Microsoft Windows-based programs.). Microsoft Excel cannot check the status of these types of links.
  • Error: Source not found Click Change Source, and select another workbook.
  • Error: Worksheet not found Click Change Source, and then select another worksheet. The source may have been moved or renamed.
  • Warning: Values not updated Click Update Values. The link was not updated when the workbook was opened.
  • Warning Click Open Source, and calculate the workbook by pressing F9. The workbook may be set to manual calculation. To set to automatic calculation, on the Tools menu, click Options, select the Calculation tab, and then click Automatic.
  • Warning Some names (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) cannot be resolved until the source workbook (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) is opened.
  • Click Open Source, switch back to the destination workbook (destination file: The file that a linked or embedded object is inserted into. The source file contains the information that is used to create the object. When you change information in a destination file, the information is not updated in the source file.), and click Check Status. If this does not resolve the problem, make sure the name is not misspelled or missing. Switch to the source workbook, and then on the Insert menu, point to Name, and then click Define, and look for the name.
  • Warning Click Open Source. The link cannot be updated until the source is open. Source is open The source is open. No action required unless worksheet errors are present. Values updated from filename No action required, the values have been updated.
  • Warning Excel cannot determine the status of the link. The source may contain no worksheets, or be saved in an unsupported file format. Click Update Values.
Reply With Quote
  #3  
Old 24-02-2012
Member
 
Join Date: May 2011
Posts: 445
Re: Edit Links shows unknown status in Microsoft Excel

Try to read the below links for troubleshooting the issue. This occurs baiscally when there is any inundation done to the version of Excel.
External links may be updated in Excel when you open a workbook that was last saved in an earlier version of Excel
How to check and manage the status of links in Excel 2002 or later versions of Excel
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Edit Links shows unknown status in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Connection status unknown, DPS and missing permissions for Trustedinstaller EricBy Vista Help 1 03-05-2012 04:33 PM
How to hide status bar in Microsoft Excel 2007 Aza MS Office Support 2 21-02-2012 01:21 PM
I want to edit existing drop down list in Microsoft Excel Edha MS Office Support 2 01-02-2012 06:08 PM
Not able to edit a lock sheet in Microsoft Excel Tur^turro MS Office Support 3 25-01-2012 07:01 PM
How to edit existing MS Query in Microsoft Excel 2007 connoisseur MS Office Support 1 21-01-2012 03:47 PM


All times are GMT +5.5. The time now is 08:37 AM.