:::image type="content" source="media/paste-special-missing-or-not-working/paste-special-settings.png" alt-text="Check the Paste Special settings." border="false"::: :::image type="content" source="media/paste-special-missing-or-not-working/paste-special.png" alt-text="Check the Paste Special performance with office safe mode."::: Leave that one disabled or uninstall it.įor more information, see Adding or Removing Add-ins and Working with Office Safe Modes. If the Paste Special option works in the Safe Mode as follows, enable your Add-ins one by one until you hit that one that is causing the conflict. This works with any Microsoft Office product. If you have an icon on your desktop, hold the CTRL key and click on the icon. Press and hold the CTRL key and double-click the application shortcut.Ĭlick Yes when a window appears asking if you want to start the application in Safe Mode. To determine if an add-in is causing the issue: Third party Add-ins can cause a variety of issues, one of then being, conflicting with the Paste Special option. Windows Internet Explorer (8-9) do not conflict with the Paste Special option in Excel 2010. Paste special will not function if your web browser is causing the conflict. To enable the option, you need to set the value of the Application.EnableEvents property to False.Įnsure that all instances of the web browsers that you use are closed and try to use the Paste Special option again. Using the Worksheet_SelectionChange event will clear the clipboard, which disables the Paste Special option. Under Cut, copy and paste, ensure the Show Paste Options button when content is pasted option is checked.To see if the Paste Special option is enabled:
If you are having issues with the Paste Special option, continue on to the resolutions below. The Paste Special option can make the task of pasting text go more smoothly by letting you choose which formatting you want to keep (source or destination) or by stripping all the formatting and just pasting the text. Paste Special option is missing or not working in Microsoft Office
0 kommentar(er)
