Excel is defaulting to paste values

C

cmhoz

Active Member
Joined
Aug 20, 2006
Messages
268
Hi All -

Excel decided yesterday that when I click 'paste' it would paste values - always- unless I paste special formulas or all.

I was hoping this was an "Excel is tired" issue - so I shut down for the night. However, this morning... it's still doing it.

I'm not aware of being able to change the default paste method ?? Is there a setting someplace that I've accidentially changed, or is Excel simply possessed?

Thanks!!
 
Sort by date Sort by votes
Sounds odd - off the top of my head I can't think of any native settings to do this. Of course one could write some code to overload commandbarbutton or shortcut key behaviour?
 
Upvote 0
I know - crazy to post to a six year old thread. Still someone else might get here via Google like I did.
I had the same problem today, MS Excel 2007 pasting values when using CTRL+v. I had used the cmd NET SHARE v:/D or similar to remove mapped drives in the morning, then noticed the odd behaviour later in the day.
Performed a system restore to yesterday and problem solved. Thanks to previous poster for the hint.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
VBA - Overpass default Scripting.Dictionary Keys comparison
Replies
4
Views
236
saboh12617
S
FrumpyJones
  • Question Question
Is there a way to stop COPY/PASTE but still allow manual entries and use of drop down lists.
Replies
5
Views
540
FrumpyJones
FrumpyJones
B
  • Question Question
When removing links with copy and paste special some values appear in scientific notation or expanded decimal places.
Replies
7
Views
390
BYahr
B
W
  • Question Question
VBA to Copy Excel cells (one at a time) text to Windows Clipboard so that the text can be Pasted into another application using Windows+V
Replies
3
Views
489
WFCompany
W
U
  • Question Question
Inserting images into Excel workbook - loss of image quality problem
Replies
1
Views
829
ranman256
ranman256

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top