Excel 2007 - Pasting values instead of formulas

T

trunten

Active Member

Joined

Jul 26, 2011

Messages

497

• Apr 11, 2012

• #2

I'm going to guess that your worksheet is protected. I've noticed that seems to happen to me when I'm copying from protected sheets

 

Upvote 0

MrKowz

Well-known Member

Joined

Jun 30, 2008

Messages

6,653

Office Version

1. 365
2. 2016

Platform

1. Windows

• Apr 11, 2012

• #3

Sadly, that isn't the case. I've created a new workbook, and simply created a formula and copy/pasted it, same result. It is pasting the value, not the formula.

 

Upvote 0

Colin Legg

MrExcel MVP

Joined

Feb 28, 2008

Messages

3,507

Office Version

1. 365

Platform

1. Windows

• Apr 11, 2012

• #4

I noticed someone with the same issue posted on this old thread today:
http://www.mrexcel.com/forum/showthread.php?p=3113120

 

Upvote 0

MrKowz

Well-known Member

Joined

Jun 30, 2008

Messages

6,653

Office Version

1. 365
2. 2016

Platform

1. Windows

• Apr 11, 2012

• #5

Colin,

I'd love to do a system restore, however that isn't possible, as I'm not the IT guy, and there has been a lot of work done across the machine in the past 24 hours . Excel DID work as intended for a short period of time after a reboot, however, it reverted back to this behaviour within 10 minutes or so.

I have to head out of work now, and will check back in on this thread (and the machine) in the morning. I greatly appreciate any insight/help anyone can provide!

Cheers!

 

Upvote 0

Colin Legg

MrExcel MVP

Joined

Feb 28, 2008

Messages

3,507

Office Version

1. 365

Platform

1. Windows

• Apr 11, 2012

• #6

My line of thinking was more along the lines of what a coincidence it was... and then the cynic in me says it might not be a coincidence. Are there any recent downloads/updates/installs etc (you know the drill) on the box?

Also, if you start Excel in safe mode, does the problem persist?

 

Upvote 0

MrKowz

Well-known Member

Joined

Jun 30, 2008

Messages

6,653

Office Version

1. 365
2. 2016

Platform

1. Windows

• Apr 11, 2012

• #7

Colin Legg said:

My line of thinking was more along the lines of what a coincidence it was... and then the cynic in me says it might not be a coincidence. Are there any recent downloads/updates/installs etc (you know the drill) on the box?

Also, if you start Excel in safe mode, does the problem persist?

Click to expand...

I haven't tried Excel in safe mode yet, and I know that Microsoft rolled out a series of updates yesterday (I'm not sure if any affected Excel or Office 2007). I'll try out the safe mode tomorrow morning, and see if any of those updates involved Excel 2007.

Thanks!

 

Upvote 0

X

XL&ME

Board Regular

Joined

Jun 21, 2009

Messages

117

• Apr 12, 2012

• #8

ZVI recently just posted a possible solution to your problem.

If Skype is installed with the Click to Call addin, remove this addin

 

Upvote 0

MrKowz

Well-known Member

Joined

Jun 30, 2008

Messages

6,653

Office Version

1. 365
2. 2016

Platform

1. Windows

• Apr 12, 2012

• #9

Thanks for the idea, XL&ME. Sadly, there was no addin related to Skype on his Excel (though Skype IS installed, and he uses it daily).

 

Upvote 0

MrKowz

Well-known Member

Joined

Jun 30, 2008

Messages

6,653

Office Version

1. 365
2. 2016

Platform

1. Windows

• Apr 12, 2012

• #10

XL&ME said:

ZVI recently just posted a possible solution to your problem.

If Skype is installed with the Click to Call addin, remove this addin

Click to expand...

Correction - this WAS the issue! I was looking in Excel for a "Click to Call" addin, and didn't realize that it was something I had to uninstall from the Add/Remove Programs. Thanks much for this information!

 

Upvote 0