undo change in two worksheets

Question

When I have two worksheets open and I copy information from one to another, when I undo a change in one, I undo the other one as well.

How to take it off?

Answer 1

Hello,

There is no feature to turn this off. I'd recommend submitting this feedback using Excel:

How do I give feedback on Microsoft 365?

https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-365-2b102d44-b43f-4dd2-9ff4-23cf144cfb11

---

If this helpful please accept answer.

Answer 2

Hi @BiCa7

If you copy values from worksheet A to worksheet B, then undo a previous change in worksheet A, the pasting data in worksheet B will be revoked.

As Dillon S suggested, there is no option to turn it off.

Based on my tests, if you open worksheet A in one Excel instance, and run excel /x in Run dialog to open a new Excel instance, then open worksheet B, you can past the values and formats. (But the formulas can not be pasted.)

Under this case, you can undo a change in worksheet A, the pasting operation will not be effected.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---