Copy not functioning (not a Paste issue) - Excel 2007

[slipperybeans]

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

[Jim Cone]

See...
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/0c6a3ff4324ba097?hl=en#
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Data Options add-in: rows stuff/date picker/random stuff)




"slipperybeans" <excel...@slipperybeans.com.spam>
wrote in message news:slipperybe...@excelbanter.com...

[zaf]

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.