Paste Special Not Working
When I try to use Paste Special, the normal menu of choices (value, formula,
etc.) does not appear. Instead, a dialog box asking if I want to paste as Unicode Text or Text appears. Also, when I right-click a cell and choose 'copy' then move to another cell and right-click to 'paste' the 'paste' and 'paste special' are grayed out - I have to repeat the operation for the choices to become active. Is there a setting that has changed? It used to work fine, but now for some reason Paste Special is not special anymore. |
Paste Special Not Working
You have two instances of excel running.
Close one workbook and that instance of excel. Then in the remaining instance, do File|open to open that other workbook. Then try your copy|paste special. Joe VW wrote: When I try to use Paste Special, the normal menu of choices (value, formula, etc.) does not appear. Instead, a dialog box asking if I want to paste as Unicode Text or Text appears. Also, when I right-click a cell and choose 'copy' then move to another cell and right-click to 'paste' the 'paste' and 'paste special' are grayed out - I have to repeat the operation for the choices to become active. Is there a setting that has changed? It used to work fine, but now for some reason Paste Special is not special anymore. -- Dave Peterson |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com