undo change in two worksheets

asked 2023-01-16T16:56:38.5733333+00:00
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.
52 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
51 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2023-01-16T17:19:52.2466667+00:00
    Dillon Silzer 33,226 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.

    No comments

  2. answered 2023-01-17T10:23:48.1666667+00:00
    Emily Hua-MSFT 21,526 Reputation points Microsoft Employee

    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.