Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 23rd 09, 03:30 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 1
Default Edit Links - Status Unknown

Hi

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 enusre 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?

Thanks in advance

Hillheader

  #2   Report Post  
Old February 15th 09, 01:57 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Edit Links - Status Unknown

Hi,

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Hillheader" wrote:

Hi

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 enusre 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?

Thanks in advance

Hillheader



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
Says can't update links, but status ok meg Excel Discussion (Misc queries) 0 February 21st 08 04:13 PM
Update links box gives Continue or Edit Links dialog KarenF Excel Discussion (Misc queries) 0 May 18th 07 01:17 PM
Edit Links: Changing links on a protected worksheet Halibut68 Excel Discussion (Misc queries) 0 April 28th 06 11:03 AM
why does the link status always reverts back to UNKNOWN? Rupa Excel Discussion (Misc queries) 0 February 28th 06 03:15 PM
unknown links BorisS Excel Discussion (Misc queries) 1 November 12th 05 04:08 PM


All times are GMT +1. The time now is 02:46 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017