undo change in two worksheets

BiCa7 20 Reputation points

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?

A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,191 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,326 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Dillon Silzer 52,906 Reputation points


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

    How do I give feedback on Microsoft 365?


    If this helpful please accept answer.

    0 comments No comments

  2. Emily Hua-MSFT 27,466 Reputation points

    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.