Fix for Cannont Empty the Clipboard in Office ¼öÁ¤ Cannont ¿ÀÇǽºÀÇ Å¬¸³ º¸µå ºñ¿ì±â À§ÇØ

Posted on September 20, 2008 at 5:48 am 9 ¿ù 20 ÀÏ, 2008 °Ô½ÃµÊ ¿ÀÀü 5:48

Trying to copy something in Excel and get the error message ¡° Cannot empty the clipboard ¡±? Excel¿¡¼­ ¹º°¡¸¦ º¹»çÇÏ°í ¿À·ù ¸Þ½ÃÁö¸¦ ¾òÀ» ""Ŭ¸³ º¸µå¿¡ Áö¿ï ¼ö¾ø½À´Ï´Ù ¿Ã·¡? I was recently the victim of this annoying error, which would pop up EVERY time I tried to copy a cell or cells in Excel! ÃÖ±ÙÀÌ Â¥Áõ³ª´Â ¿À·ùÀÇ ³­ ÇÚµåÆù ¶Ç´Â Excel¿¡ÀÖ´Â ¼¼Æ÷¸¦ º¹»çÇÏ·Á°í ÇÒ ¶§¸¶´Ù ÆË¾÷ °ÍÀÌ ÇÇÇØÀÚ ¿´¾î!

The strange thing is that the copy still works for me, but I have to keep clicking OK to remove the error message. ÀÌ»óÇÑ °ÍÀº ±× »çº»À» ¾ÆÁ÷µµ ³¯ À§ÇØ ÀÏÇϴµ¥, ±Ùµ¥ ³»°¡ °è¼Ó È®ÀÎÀ» ´­·¯ ¿À·ù ¸Þ½ÃÁö¸¦ Á¦°ÅÇÒ Çʿ䰡ÀÖ´Ù. After some read and playing around on my own, I¡¯ve learned that this error can happen for all kinds of wacky reasons and so there are a number of things you can try to rectify the situation. Á» Àоî ÈÄ ³» Àڽſ¡ ³î·¯´Ù´Ï´Â ±×·± ¾û¶×ÇÑ ÀÌÀ¯·ÎÀÌ ¿À·ù°¡ ÀϾ ¼ö ÀÖµµ·Ï ¸ðµç Á¾·ùÀÇ¿¡ ´ëÇÑ ´ç½ÅÀÌ ¼öÀÖ´Â ¿©·¯ °¡Áö »óȲÀ» ÇØ°áÇÒ ¼ö ÀÖµµ·Ï ³ë·ÂÇϰíÀÖ´Ù ¹è¿ü¾î¿ä.

cannot empty the clipboard

For the most part, you¡¯ll see this error in Microsoft Excel and Word, especially when you are trying to copy cells in Excel. ´ëºÎºÐÀÇ °æ¿ì, ´ç½ÅÀº Microsoft Excel°ú Word, Excel¿¡¼­ÀÌ ¿À·ù´Â ƯÈ÷ ¼¼Æ÷¸¦ º¹»çÇÏ·Á°í ÇÒ ¶§ ³ªÅ¸³³´Ï´Ù. Here are some fixes to try: ¿©±â¿¡ ½ÃµµÇÏ´Â ÀϺΠ¼öÁ¤ :

Method 1: ¹æ¹ý 1 :

Sometimes in Excel you can get this error if a cell has been copied and you try to copy another cell. °¡²ûÀº Excel¿¡¼­ÀÌ ¿À·ù°¡ÀÖ´Â °æ¿ì¹ÞÀ» ¼öÀÖ´Â ÇÚµåÆùÀÌ º¹»çµÇ¾î ´Ù¸¥ ¼¼Æ÷¸¦ º¹»çÇÏ·Á°íÇÕ´Ï´Ù. You can try to press the ESC key to deselect the copied cell and then try to copy again. ´ç½ÅÀÌ ÇÚµåÆùÀ» Ãë¼ÒÇÏ·Á¸é Esc ۸¦ ´­·¯ º¹»çÇÑ ÈÄ ´Ù½Ã º¹»çÇÏ·Á°í ½ÃµµÇÒ ¼öÀÖ½À´Ï´Ù.

This method might let you copy, but you may still get the error message on the next attempt to copy. ÀÌ ¹æ¹ýÀ» »ç¿ëÇÏ¸é º¹»çÇÏÀÚ ÇÒ ¼öµµ ÀÖÁö¸¸, ¿©ÀüÈ÷ ´ÙÀ½ ½Ãµµ¸¦ º¹»çÇÏ¿© ¿À·ù ¸Þ½ÃÁö¸¦¹ÞÀ» ¼öÀÖ½À´Ï´Ù. It¡¯s not a permanent fix. ±×°ÍÀº ¿µ¿øÈ÷ °íÄ¥ ¾Æ´Ï¿¡¿ä.

Method 2: ¹æ¹ý 2 :

Another thing you can try is to open the ³Í ÇÒ ¼öÀÖ¾î ¶Ç Çϳª´Â ¿ÀÇÂÇÏ´Â °ÍÀÔ´Ï´Ù clipboard in Windows WindowsÀÇ Å¬¸³ º¸µå¿¡ and leave it open. ±×¸®°í ±×°ÍÀ» ¿­¾îµÎ°íÀÖ´Ù. Somehow doing this can help get rid of the error. ¾î¶»°Ôµç µµ¿òÀÌ ÀÏÀ» ¾òÀ» ¼öÀÖ´Â ¿À·ù¸¦ Á¦°ÅÇÕ´Ï´Ù. It¡¯s not a great solution, but these are the strange things you have to do in Windows! ±×°ÍÀº ÁÁÀº ÇØ°áÃ¥Àº ¾Æ´ÏÁö¸¸ À̵éÀÌ ´ç½ÅÀÌ Windows¿¡¼­ÇؾßÇÏ´Â ÀÌ»óÇÑ ÀϵéÀÌÀÖ´Ù!

You can open the Clipboard by going to Start , Run and typing in clipbrd.exe . ½ÃÀÛ, ½ÇÇàÇÏ·Á°í clipbrd.exe¿¡ ÀÔ·ÂÇÏ¿© Ŭ¸³ º¸µå¸¦ ¿­ ¼öÀÖ½À´Ï´Ù. You can also go to your Windows\System32 directory and double-click on clipbrd.exe. ¶ÇÇÑ À©µµ¿ì¿¡ °¥ ¼ö \ System32 µð·ºÅ͸® - clipbrd.exe¿¡ µÎ ¹ø ´©¸¨´Ï´Ù.

clipbook viewer

Method 3: ¹æ¹ý 3 :

If you¡¯ve been using Remote Desktop, you may get the cannot copy to clipboard error because Remote Desktop uses the clipboard and it can cause weird issues with Excel. ¿ø°Ý µ¥½ºÅ©ÅéÀ» »ç¿ëÇϸé ÀÖ¾ú°í, ´ç½Å ¶§¹®¿¡ Ŭ¸³ º¸µå¸¦ »ç¿ëÇÏ¿© ¿ø°Ý µ¥½ºÅ©Åé ¹× Excel¿¡¼­ ÀÌ»óÇÑ ¹®Á¦°¡ ¹ß»ýÇÒ ¼öÀÖ´Â ¿À·ù¸¦ Ŭ¸³ º¸µå¿¡ º¹»çÇÒ ¼ö¾ø½À´Ï´Ù ¾òÀ» ¼öÀÖ½À´Ï´Ù.

Go to Task Manager and then click on the Processes tab and kill the process called rdpclip.exe and see if that fixes your problem! ÀÛ¾÷ °ü¸®ÀÚ¸¦ ´©¸¥ ´ÙÀ½ ÇÁ·Î¼¼½º ÅÇÀ» Ŭ¸¯ °úÁ¤À» Á×ÀÌ°í °¡¼­ Rdpclip.exe ÀüÈ­¸¦ °É¾îº¸°í ¼öÁ¤ÇÏ´Â °æ¿ì ¹®Á¦°¡! If you have UltraVNC installed, it may also be the culprit! UltraVNC°¡ ¼³Ä¡µÇ¾îÀÖ´Â °æ¿ì, ±×°Íµµ ¹üÀÎÀÌ µÉ ¼öÀÖ½À´Ï´Ù! Any kind of remote desktop software could be causing the issue, so make sure to check to see if you have the problem when one of those programs are running. ¿ø°Ý µ¥½ºÅ©Åé ¼ÒÇÁÆ®¿þ¾îÀÇ ¸ðµç Á¾·ù, ±×·¸°Ô È®½Å Çϳª°¡ ±× ÇÁ·Î±×·¥À» ½ÇÇàÇÏ´Â °æ¿ì ¹®Á¦°¡ ÀÖ´ÂÁö È®ÀÎÇÒ ¼ö ÀÖµµ·Ï ¹®Á¦ÀÇ ¿øÀÎÀÌ µÉ ¼öÀÖ½À´Ï´Ù.

Method 4: ¹æ¹ý 4 :

Go to Excel, click on Tools , then Options , and go to the Calculation tab. ¿¢¼¿, µµ±¸¸¦ Ŭ¸¯ÇÏ°í ´ÙÀ½ ¿É¼ÇÀ¸·Î °¡¼­ °è»ê ÅÇÀ»·Î À̵¿ÇÕ´Ï´Ù.

excel automatic calculation

Make sure that Automatic is selected from the three options. ÀÚµ¿ ¼¼ °¡Áö ¿É¼ÇÀÌ ¼±ÅõǾî ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù. Also, try rebooting your machine. ¶ÇÇÑ ÄÄÇ»Å͸¦ ÀçºÎ ÆÃÇϽʽÿÀ.

Method 5: ¹æ¹ý 5 :

If you have a program like GetRight or Flashget installed on your computer, you will have to go in and uncheck the option for ¡°Monitor the clipboard¡±. GetRight °æ¿ì ¶Ç´Â Flashget °°Àº ÇÁ·Î±×·¥ÀÌ ÄÄÇ»ÅÍ¿¡ ¼³Ä¡µÇ¾îÀÖ´Â, ´ç½ÅÀÌ °¡°í, ¸ð´ÏÅÍ "¿¡ ´ëÇÑ ¿É¼ÇÀº Ŭ¸³ º¸µåÀÇ ¼±ÅÃÀ» Ãë¼Ò"°¡ Ç¥½ÃµË´Ï´Ù. Any other program that may try to use the Windows Clipboard could be causing the problem, so uninstall any third party software that you know uses the clipboard. ´Â WindowsÀÇ Å¬¸³ º¸µå¸¦ »ç¿ëÇÏ´Â ´Ù¸¥ ÇÁ·Î±×·¥À» ½ÃµµÇØ º¼ ¼öµµÀÖ½À´Ï´Ù ¹®Á¦ÀÇ ¿øÀÎÀÌ µÉ ¼öÀÖ´Ù, ±×·¡¼­ ´ç½ÅÀÌ ¾Ë°íÀִ Ÿ»ç ¼ÒÇÁÆ®¿þ¾î¸¦ Á¦°ÅÇÑ ÈÄ Å¬¸³ º¸µå¸¦ »ç¿ëÇÕ´Ï´Ù.

Method 6: ¹æ¹ý 6 :

Clear the office clipboard by going to Edit and choosing Office Clipboard . ÆíÁýÇÏ·Á°íÇϰí Office Ŭ¸³ º¸µå¸¦ ¼±ÅÃÇÏ¿© Ŭ¸³ º¸µå Áö¿ì±â »ç¹«½Ç. This will only work for Office XP and 2003. ÀÌ Office XP ¹× 2003¿¡¼­¸¸ ÀÛµ¿ÇÕ´Ï´Ù. Now go ahead and click Clear All to clear the office clipboard completely. Áö±ÝÀº ¾Õ¼­ ¸ðµÎ Áö¿ì±â¸¦ Ŭ¸¯ ¿ÏÀüÈ÷ Ãë¼Ò Office Ŭ¸³ º¸µå·Î À̵¿ÇÕ´Ï´Ù.

clear all office clipboard

Also, at the bottom of the screen, you should see an Options button. ¶ÇÇÑ È­¸éÀÇ ÇÏ´Ü¿¡¼­, ´ç½ÅÀº ¿É¼Ç ¹öưÀÌ Ç¥½ÃµË´Ï´Ù. Click on that and select the ¡° Collect without showing office clipboard ¡± option. ±×°ÍÀ» Ŭ¸¯ÇÏ¸é ¼±Åà "À» ¸ð¾Æ¼­"¿É¼ÇÀ» Office Ŭ¸³ º¸µå¸¦ Ç¥½ÃÇÏÁö ¾Ê°íÀÖ´Ù.

Method 7: ¹æ¹ý 7 :

Microsoft has written about this error in their KB and they have a hotfix for it, but it may or may not work for you. MS´Â À̵é ÀÌÇÏ¿¡¼­ÀÌ ¿À·ù¿¡ ´ëÇØ ÀÛ¼ºÇß½À´Ï´Ù ±×¸®°í ±×µéÀº ±×°ÍÀ»ÇϱâÀ§ÇÑ ÇÖÇȽº¸¦ °¡Áö°í ÀÖ¾î¿ä,ÇÏÁö¸¸ ´ç½ÅÀ» À§ÇØ ÀÛµ¿ÇÏÁö ¾ÊÀ» ¼öµµÀÖ½À´Ï´Ù. It¡¯s only for Windows Server 2003 and it has to do with Terminal Services. Windows Server 2003 ¿ë¿¡ ºÒ°úÇÏ°í ±×°ÍÀ» Å͹̳Π¼­ºñ½º¸¦ ÇÔ²² ÇÒ ¼öÀÖ´Ù.

You can download the hotfix here: ´ç½ÅÀÌ ¿©±â ÇÖÇȽº¸¦ ´Ù¿î·ÎµåÇÏ½Ç ¼öÀÖ½À´Ï´Ù : http://support.microsoft.com/?id=840872 .

That¡¯s all the solutions I could find for not being able to empty the clipboard! ³»°¡ ºñ¾î¸¦ ÇÒ ¼ö ¾ø´Ù´Â Ŭ¸³ º¸µå¿¡ ´ëÇÑ ¸ðµç ¼Ö·ç¼ÇÀ» ãÀ» ¼ö ÀÖ¾î¿ä! If you have another solution that has worked for you, post a comment here! ±×·± ´ç½ÅÀ» À§ÇØ ÀÏÇØ¿Ô´Ù¸é ´Ù¸¥ ÇØ°áÃ¥, ¿©±â¿¡ ÀǰßÀ» °Ô½ÃÇß½À´Ï´Ù! Good luck! Çà¿îÀ» º÷´Ï´Ù!

Windows has lots of crpytic messages like this and I¡¯ve written about a few of them before like how to Windows°¡ÀÌ °°Àº ¸Þ½ÃÁö¸¦ crpytic ¸¹ÀÌ °¡Áö°í Àִµ¥ ±×µé Áß ÀϺο¡ ´ëÇØ ÀÌÀü°ú °°Àº ¹æ¹ýÀ» ¼­¸éÀ¸·Î ÀÛ¼ºÇß½À´Ï´Ù fix missing or corrup NTFS.sys ´©¶ôµÇ°Å³ª ¼öÁ¤ ºñ¿­ÇÑ ntfs.sys , fix Windows Search Indexer has stopped working ¼öÁ¤ ÇÁ·Î±×·¥Àº Windows °Ë»ö IndexerÀÇ ÀÛµ¿ÀÌ ÁßÁöµÇ¾ú½À´Ï´Ù , fix USB device not recognized in Windows USB ÀåÄ¡¸¦ Windows¿¡¼­ ÀνĵÇÁö ¼öÁ¤ , and , ±×¸®°í fix for host process in Windows has stopped working error Windows¿¡¼­ È£½ºÆ® ÇÁ·Î¼¼½º¿¡ ´ëÇÑ ¼öÁ¤ ÇÁ·Î±×·¥ÀÌ ¿À·ùÀÇ ÀÛµ¿ÀÌ ÁßÁöµÇ¾ú½À´Ï´Ù . Whew! ÈÞ!

Enjoyed this post? ÀÌ °Ô½Ã¹°À» ÀßÇß³ª? Subscribe to Online Tech Tips via ¿Â¶óÀÎ Å×Å© ÆÁÀ» ÅëÇØ ±¸µ¶ ½Åû RSS Feed RSS Çǵå or via ¶Ç´Â¸¦ ÅëÇØ Email À̸ÞÀÏ and receive free daily productivity tips. ¹«·á ÀÏÀÏ »ý»ê¼º ÆÁÀ»¹ÞÀ» ¼öÀÖ´Ù.

» Filed Under »Ãâ¿ø¿¡¼­ MS Office Tips MS ¿ÀÇǽº ÆÁ

¸ÀÀִ¿¡ Ãß°¡ Save this page ÀÌ ÆäÀÌÁö¸¦ ÀúÀå ±×°Í Mixx Stir it up on Mixx Mixx¿¡ ¿Ã·Á ÆÄ¹®
reddit Add to Reddit reddit¿¡ Ãß°¡ StumbleUpon Stumble this page ÀÌ ÆäÀÌÁö¸¦ ´õµë´Ù

Related Posts °ü·Ã °Ô½Ã¹°

Please post your comments/suggestions! ±ÍÇÏÀÇ ÀǰßÀ» °Ô½ÃÇϽñ⠹ٶø´Ï´Ù / Á¦¾È!