+ Reply to Thread
Results 1 to 4 of 4

Issue pasting values from cells in one sheet to another

  1. #1
    Registered User
    Join Date
    08-12-2019
    Location
    Minnesota, USA
    MS-Off Ver
    2019
    Posts
    2

    Issue pasting values from cells in one sheet to another

    SCHEDULE ISSUE.png

    When copying cells from one sheet in a workbook to another sheet in the same workbook I am getting the attached error message. It still will paste the contents of the cell but once it does if I try to highlight other cells they don't show up as highlighted or selected.

    The cells are being selected as I can change fill color and it will apply to the cells that are selected I'm just not able to tell which cells are actually selected. While this is happening some of the features in the toolbar become grayed out and unusable as well. If I allow a few minutes or more to pass it will start functioning normally again.

    Any suggestions on what may be causing this strange behavior would be appreciated.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Issue pasting values from cells in one sheet to another

    Start Excel.
    Go to File in the upper-left corner.
    Click Options.
    Go to General.
    Under User Interface Options un-check Enable Live Preview.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    08-12-2019
    Location
    Minnesota, USA
    MS-Off Ver
    2019
    Posts
    2

    Re: Issue pasting values from cells in one sheet to another

    Error just happened as I was checking for a response on this. I turned off the live preview option as you suggested and it started working normally again right away. It usually took about 20 mins to start working normally again it seems this fixed it.

    Thank you for your help and quick response!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Issue pasting values from cells in one sheet to another

    You're welcome and thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Gather values from a sheet after pasting
    By zaibuojantis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2019, 02:04 AM
  2. Auto pasting values from a reference sheet when values entered in a separate sheet.
    By jorricha in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-04-2018, 04:37 PM
  3. Issue with Copy+Pasting cells with conditional formatting
    By egoldin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-17-2017, 02:12 PM
  4. [SOLVED] Pasting values into different sheet into one sheet in diffrent cells
    By vegaman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2015, 06:13 PM
  5. Simply Copy and pasting data from one sheet to another sheet but certain cells....
    By cory0789 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2014, 09:36 AM
  6. Pasting values not formulas from one sheet into a second sheet
    By nerdzkilla in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2012, 12:32 PM
  7. Replies: 10
    Last Post: 02-09-2010, 05:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1