Lm th? no ? ki?m tra v ki?m tra t?nh tr?ng c?a cc lin k?t trong Excel 2002 ho?c phin b?n m?i nh?t c?a Excel

D?ch tiu ? D?ch tiu ?
ID c?a bi: 288940 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny


Bi vi?t t?ng b?c ny m t? lm th? no ? ki?m tra t?nh tr?ng cc lin k?t v xc ?nh nh?ng hnh ?ng c?n thi?t d?a trn t?nh tr?ng bo co. Cc Ch?nh s?a cc lin k?t h?p tho?i trong Microsoft Excel cung c?p ?c c?i thi?n ch?c nng, cho php b?n ki?m sot nhi?u hn cc lin k?t trong sch bi t?p c?a b?n.

Ki?m tra lin k?t

M?t lin k?t l m?t tham chi?u ?n m?t b?ng tnh. N i khi ?c g?i l m?t tham kh?o ngoi. M?t lin k?t c?ng c th? ?c th?c hi?n cho m?t chng tr?nh khc, ch?ng h?n nh Microsoft Word 2002. Lo?i h?nh lin k?t ny i khi ?c g?i l m?t ti li?u tham kh?o t? xa. B?i v? d? li?u trong b?ng tnh ho?c chng tr?nh khc c th? thay ?i, c nh?ng l?a ch?n ? ki?m sot nh th? no lin k?t ?c C?p Nh?t.

? ki?m tra t?nh tr?ng c?a cc lin k?t trong b?ng tnh c?a b?n, h?y lm theo cc b?c sau:
  1. Trn cc Ch?nh s?a tr?nh n, nh?p voLin kt.

    Chu y Cc Lin kt l?nh khng s?n dng n?u t?p tin c?a b?n khng ch?a thng tin ?c lin k?t.
  2. Nh?p vo Ki?m tra tr?ng thi ? c?p nh?t t?nh tr?ng cho t?t c? cc lin k?t trong danh sch.

    Qu tr?nh ny c th? m?t vi pht n?u b?ng tnh ch?a m?t s? l?n cc lin k?t ho?c n?u b?ng tnh ngu?n cho cc lin k?t l trn v? tr m?ng v k?t n?i m?ng l ch?m.

    Khi hon t?t cc th? t?c ki?m tra tr?ng thi, t?nh tr?ng hi?n t?i cho t?t c? hi?n c lin k?t s? ?c hi?n th? trong cc Tr?ng thi c?t.
  3. ? ti?p t?c qu?n l? cc lin k?t, ch?n lin k?t, v sau i hnh ?ng c?n thi?t nh ?c ch? ?nh trong b?ng sau:
       Status               Action Required
       OK                   No action required; the link is working and up to
       Unknown              Click Check Status to update the status for all
                            links in the list. 
       Not applicable       The link uses Object Linking and Embedding (OLE) 
                            or Dynamic Data Exchange (DDE). Excel 
                            2002 cannot check the status of these types of  
       Error:               Click Change Source and select the correct        
       Source not found     workbook. The source may have been moved or
       Error:               Click Change Source, and then select the correct
       Worksheet not found  worksheet. The source may have been moved or
       Warning:             Click Update Values. The link was not updated when
       Values not updated   the workbook was opened. 
       Warning:             Click Open Source and calculate the workbook by
       Source not           pressing F9. The workbook may be set to manual
       recalculated         calculation. To set to automatic calculation, click
                            Options on the Tools menu, select the
                            Calculation tab, and then click Automatic. 
       Warning:             Some names cannot be resolved until the source
       Undefined or         workbook is opened. Click Open Source, switch
       non-rectangular name back to the destination workbook, and then click
                            Check Status. If this does not resolve the issue,
                            make sure the name is not misspelled or missing.
                            Switch to the source workbook, point to Name on the
                            Insert menu, click Define, and then look for the
       Warning:             Click Open Source. The link cannot be updated until 
       Open source to       the source is open.
       update values     
       Source is open       The source is open. No action required unless
                            worksheet errors are present.
       Values updated       No action required; the values have been updated.
       from filename  
       Warning:             Excel cannot determine the status of the link.
       Status indeterminate The source may contain no worksheets or be saved
                            in an unsupported file format. Click Update Values.


? bi?t thm chi ti?t v? cc lin k?t, nh?p vo Tr? gip Microsoft Excel trn cc Tr giup tr?nh n, lo?i lin k?t trong tr? l? vn ph?ng ho?c thu?t s? tr? l?i, v sau b?m Tim kim ? xem cc ch? ? tr? l?i.

Thu?c tnh

ID c?a bi: 288940 - L?n xem xt sau cng: 23 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft Excel 2002 Standard Edition
T? kha:
kbxlslink kbprb kbhowtomaster kbmt KB288940 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:288940

Cung cp Phan hi


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com