¸ÅÅ©·Î¸¦ Mac¿ë Excel ¿¡¼­ ¼ö½Ä ¸µÅ©¸¦ »èÁ¦ÇÏ·Á¸é

±â¼ú ÀÚ·á: 192895 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
Microsoft Excel 97 ¹× ÀÌÀü ¹öÀüÀÇ ÀÌ ¹®¼­¿¡ ´ëÇÑ 126093 ÂüÁ¶ÇϽʽÿÀ.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

¿ä¾à

´Ù¸¥ ÅëÇÕ ¹®¼­¿¡ ´ëÇÑ ¸µÅ©°¡ Æ÷ÇÔµÈ ÅëÇÕ ¹®¼­¸¦ ¿­ ¶§ ÀÚµ¿À¸·Î ¿¬°áÀ» ¾÷µ¥ÀÌÆ®ÇÒ °ÍÀÎÁö ¹¯½À´Ï´Ù. ¸µÅ©¸¦ ´õ ÀÌ»ó ÂüÁ¶ÇÒ ¼ö ÀÖ´Â ÆÄÀÏÀÌ ÀÖ´Â °æ¿ì ¶Ç´Â ´Ù¸¥ Æú´õ·Î À̵¿µÈ °æ¿ì ÀÌ ¸Þ½ÃÁö°¡ ³ªÅ¸³ªÁö ¾Êµµ·Ï ¸µÅ©¸¦ »èÁ¦ÇÒ ÇÒ ¼ö ¾ø½À´Ï´Ù.

Ãß°¡ Á¤º¸

¼ö½Ä ¸µÅ©¸¦ °¡Àå ÀϹÝÀûÀÎ ¿¬°á Çü½Ä Áß ÇϳªÀÔ´Ï´Ù. ¿¬°á ¼ö½Ä ¼¿¿¡ ¼¿¿¡ ÀÖ´Â ´ÝÈùµÈ ÅëÇÕ ¹®¼­ ÆÄÀÏ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇØ´ç ÆÄÀÏÀÌ ´õ ÀÌ»ó ÀÖÀ¸¸é ¼ö½ÄÀÌ ´õ ÀÌ»ó À¯È¿ÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ·¯ÇÑ ¸µÅ©¸¦ »èÁ¦ÇÏ·Á¸é ´À³¦Ç¥ (!) ¿¡ ´ëÇÑ °Ë»ö ¹× ÆíÁý ¸Þ´º¿¡¼­ ã±â ¸¦ Ŭ¸¯ÇϽʽÿÀ. ¶Ç´Â ÀÌ ÀÛ¾÷ÀÌ ½ÇÆÐÇϸ鿡 ´ëÇÑ () ´ë°ýÈ£ °Ë»öÇÕ´Ï´Ù. °¢ ¸µÅ©¸¦ ½ÃÆ®¿¡ Ç¥½ÃµË´Ï´Ù. °¢ ¼¿ÀÇ ¼ö½ÄÀ» »èÁ¦ÇÏ°í ¼¿À» ÀÖ´ø °ªÀ¸·Î ´ëüÇÕ´Ï´Ù À̵¿ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿©·¯ ¼¿¿¡ ¸µÅ©°¡ ÀÖÀ¸¸é ¸µÅ©¸¦ »èÁ¦ÇÏ´Â ½Ã°£ÀÌ °É¸± ¼ö ÀÖ½À´Ï´Ù. »èÁ¦ ÇÁ·Î¼¼½ºÀÇ ¼Óµµ¸¦ ºü¸£°Ô ÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸ÅÅ©·Î¸¦ »ç¿ëÇϸé ÀϺΠ¸µÅ© ¹× ´Ù¸¥ »èÁ¦ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿­·Á ÀÖ´Â ÅëÇÕ ¹®¼­ ¶Ç´Â ÇöÀç ÅëÇÕ ¹®¼­ ³»ÀÇ ¸µÅ©´Â »èÁ¦µÇÁö ¾Ê½À´Ï´Ù.

Âü°í: ¸µÅ©ÀÇ ¼Ò½º ÆÄÀÏÀÌ ³×Æ®¿öÅ© µå¶óÀ̺꿡 ÀÖ´Â °æ¿ì ÀÌ ¸ÅÅ©·Î°¡ ÀÛµ¿ÇÏÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì ¸µÅ©´Â µË´Ï´Ù ¼ö ÀÖÁö¸¸ »èÁ¦µÇÁö´ÂÁö ¾Ê½À´Ï´Ù.

Visual Basic ÄÚµå ¿¹Á¦

Microsoft´Â ¹¬½ÃÀûÀÎ º¸Áõ ¾øÀÌ ¸ñÀûÀ¸·Î¸¸ ÇÁ·Î±×·¡¹Ö ¿¹Á¦¸¦ Á¦°øÇÕ´Ï´Ù. ÀÌ Æ÷ÇÔµÇÁö¸¸, »óǰ¼º ¶Ç´Â ƯÁ¤ ¸ñÀû¿¡ÀÇ ÀûÇÕ¼º¿¡ ´ëÇÑ ¹¬½ÃÀûÀÎµÈ º¸ÁõÀÌ Á¦ÇѵÇÁö ¾Ê½À´Ï´Ù. ÀÌ ¹®¼­¿¡¼­´Â ¸¸µé·Á¸é ¹× ÇÁ·Î½ÃÀú¸¦ µð¹ö±ëÇÏ´Â µ¥ »ç¿ëµÇ´Â µµ±¸ ¹× ¿©±â¼­ ¼³¸íÇÏ´Â ÇÁ·Î±×·¡¹Ö ¾ð¾î¿¡ Àͼ÷ÇÑ »ç¿ëÀÚ¸¦ ´ë»óÀ¸·Î ÇÕ´Ï´Ù. Microsoft Áö¿ø ¿£Áö´Ï¾î´Â »ç¿ëÀÚ¿¡°Ô µµ¿òÀÌ µÇµµ·Ï ƯÁ¤ ÀýÂ÷¿¡ ´ëÇÑ ±â´ÉÀ» ¼³¸íÇÒ ¼ö ÀÖÁö¸¸ Ãß°¡ ±â´ÉÀ» Á¦°øÇϰųª ƯÁ¤ ¿ä±¸ »çÇ׿¡ ¸Âµµ·Ï ÇÁ·Î½ÃÀú¸¦ ±¸¼ºÇÏÁö´Â ÀÌ ¿¹Á¦¸¦ ¼öÁ¤ÇÏÁö ¾Ê½À´Ï´Ù.
  1. »õ ¸ðµâ ½ÃÆ®¿¡ ´ÙÀ½ ¸ÅÅ©·Î Äڵ带 ÀÔ·ÂÇÕ´Ï´Ù:
        Option Base 1
    
        'This macro deletes all formula links in a workbook.
        '
        'This macro does not delete a worksheet formula that references an open
        'book, for example:
        '
        '   =[Book1.xls]Sheet1!$A$1
        '
        ' To delete only the links in the active sheet, see the comments
        ' provided in the Delete_It macro later in this article.
    
        Public Times As Integer
        Public Link_Array As Variant
    
        Sub Should_Delete()
        Items = 0 'initialize these names
        Times = 0
        Link_Array = ActiveWorkbook.LinkSources 'find all document links
    
        Items = UBound(Link_Array) 'count the number of links
        For Times = 1 To Items
    
        'Ask whether to delete each link
        Msg = "Do you want to delete this link:  " & Link_Array(Times)
          Style = vbYesNoCancel + vbQuestion + vbDefaultButton2
          Response = MsgBox(Msg, Style)
          If Response = vbYes Then Delete_It
          If Response = vbCancel Then Times = Items
        Next Times
        End Sub
    
        Sub Delete_It()
        Count = Len(Link_Array(Times))
        For Find_Bracket = 1 To Count - 1
          If Mid(Link_Array(Times), Count - Find_Bracket, 1) = ":" _
          Then Exit For
        Next Find_Bracket
        'Add brackets around the file name.
        With_Brackets = Left(Link_Array(Times), Count - Find_Bracket) & _
          "[" & Right(Link_Array(Times), Find_Bracket) & "]"
    
        'Does the replace.
    
        'If you want to remove links only on the active sheet, change the
        'next two lines into comments by placing an (') apostrophe in front of
        'them as well as the line, "Next Sheet_Select", that closes the loop.
    
        For Each Sheet_Select In ActiveWorkbook.Worksheets
    
        Sheet_Select.Activate
        Set Found_Link = Cells.Find(what:=With_Brackets, After:=ActiveCell, _
                lookin:=xlFormulas, lookat:=xlPart, searchorder:=xlByRows, _
                searchdirection:=xlNext, matchcase:=False)
           While UCase(TypeName(Found_Link)) <> UCase("Nothing")
               Found_Link.Activate
    
               On Error GoTo anarray
    
               Found_Link.Formula = Found_Link.Value
    
               Set Found_Link = Cells.FindNext(After:=ActiveCell)
    
           Wend
        Next Sheet_Select 'To remove links only on the active sheet
                         'place an (') apostrophe at the front of this line.
    
        Exit Sub
    
        anarray:
        Selection.CurrentArray.Select
        Selection.Copy
        Selection.PasteSpecial Paste:=xlValues
        Resume Next
    
        End Sub
    					
  2. Should_Delete ¸ÅÅ©·Î¸¦ ½ÇÇàÇϽʽÿÀ.
  3. ÅëÇÕ ¹®¼­ÀÇ °¢ ¸µÅ© ½Äº°µÇ¸ç °¢ ¸µÅ©¿¡ ´ëÇÑ ¸µÅ©¸¦ »èÁ¦ÇÒ °ÍÀÎÁö ¿©ºÎ¸¦ ¹¯½À´Ï´Ù. ¿¹ ¸¦ ´©¸£¸é ¸µÅ©¸¦ »èÁ¦Çϰí ÇöÀç ¼¿ °ªÀÌ °¢ ÀÌÀü¿¡ ¿¬°áµÈ ¼¿¿¡ ÀúÀåµË´Ï´Ù.

¼Ó¼º

±â¼ú ÀÚ·á: 192895 - ¸¶Áö¸· °ËÅä: 2007³â 1¿ù 23ÀÏ È­¿äÀÏ - ¼öÁ¤: 4.4
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
Ű¿öµå:?
kbmt kbdtacode kbhowto KB192895 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.

Çǵå¹é º¸³»±â