Do you want to replace the destination cells?

[Martin ©¿©¬]

Hi
When copying and pasting in a spreadsheet I am getting the message
"Do you want to replace the destination cells"
I don't know why this message has started to appear, I must have hit
something.
Anyone know how to fix please?

 

[Gary''s Student]

Tools > Options > Edit > clear the alert before overwrighting cells checkbox.

 

[Martin ©¿©¬]

Tools > Options > Edit > clear the alert before overwrighting cells checkbox.

Thanks Gary
Took me a while to find it - using 2007
I have no idea what changed my settings !!
Only started happening this week

 

[Martin ©¿©¬]

Tools > Options > Edit > clear the alert before overwrighting cells checkbox.

Still having this problem ?--
Martin
©¿©¬

 

[Gary''s Student]

In 2007, click the fat button in the upper left of the screen. Then click
the Excel Options in the lower right. Then click Advanced. Then clear the
alert.

 

[flerdle]

I am using Excel2003 (SP3) on a PC and I have this problem. It's coming up
when using copy (or cut) and paste, NOT drag&drop. I've tried unchecking the
option related tod&d anyway (via tools/options/edit) but it happens either
way. From what I've read, it's NOT supposed to be giving a warning... ?

Interestingly, if I copy/cut one cell, it does not warn me. If i try two or
more, it has the warning box.

Anyone know how to fix in this version, or am I stuck with an incredibly
annoying "feature"?

flerdle