All of a sudden, when I try to copy a cell, no formulas get put into the buffer; only values. The second I hit Copy or Ctrl-C, the hash/highlight on the cell no longer appears. Also, the Paste Special options are much different, in that a different dialog comes up without the typical list. It is now a large text area with Unicode Text and and Text as the only two options.

This IS NOT an issue with Manual calculations being turned on.
This IS NOT an issue with the Format of the cells being something like Text.

I have rebooted, restarted, and even opened old files that never had this issue.

So, I assume some setting has been updated without me knowing.

The version is Excel 2007, and the OS is Win 7.

Any help that avoids reinstalling Excel would be much appreciated.

See...
http://groups.google.com/group/micro...24ba097?hl=en#
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Data Options add-in: rows stuff/date picker/random stuff)




"slipperybeans"
wrote in message ...

All of a sudden, when I try to copy a cell, no formulas get put into the
buffer; only values. The second I hit Copy or Ctrl-C, the
hash/highlight on the cell no longer appears. Also, the Paste Special
options are much different, in that a different dialog comes up without
the typical list. It is now a large text area with Unicode Text and and
Text as the only two options.

This IS NOT an issue with Manual calculations being turned on.
This IS NOT an issue with the Format of the cells being something like
Text.

I have rebooted, restarted, and even opened old files that never had
this issue.

So, I assume some setting has been updated without me knowing.

The version is Excel 2007, and the OS is Win 7.

Any help that avoids reinstalling Excel would be much appreciated.




--
slipperybeans

slipperybeans wrote on 04/03/2012 11:15 ET :
All of a sudden, when I try to copy a cell, no formulas get put into th
buffer; only values. The second I hit Copy or Ctrl-C, th
hash/highlight on the cell no longer appears. Also, the Paste Specia
options are much different, in that a different dialog comes up withou
the typical list. It is now a large text area with Unicode Text and an
Text as the only two options

This IS NOT an issue with Manual calculations being turned on
This IS NOT an issue with the Format of the cells being something lik
Text

I have rebooted, restarted, and even opened old files that never ha
this issue

So, I assume some setting has been updated without me knowing

The version is Excel 2007, and the OS is Win 7

Any help that avoids reinstalling Excel would be much appreciated


slipperybeans

I am having exactly the same problem on my desktop computer with Excel 7. The
problem started about a week ago and prior to that the Copy/Paste/Paste Special
command was working fine.

It is also curious that I do not have the same problem with the Excel 2007
installed on my laptop even with the same spreadsheet. So I am guessing that
it
has something to do with having inadvertently changed some setting on the
desktop version of Excel 2007.

Any help with this problem will be greatly appreciated.