Results 1 to 2 of 2

Thread: Trouble Pasting Into a Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2018
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Trouble Pasting Into a Table

    I have an excel spreadsheet that has worked fine...until today.

    The spreadsheet contains a lot of data.
    Cells J1:BN3313 contain a large table (with a name, etc).

    I am having issues copying data (no matter how big or small) inside this table.

    If, for example, I copy a word from cell A1 and try to paste it in F1, it will paste just fine.
    However, if I try to copy the word from cell A1 into cell J1 (or any cell within the table range), nothing happens at all.
    No errors appear. Nothing.
    It is as if it is pasting blank information (even though there is clearly information being copied from cell A1).
    Does this make any sense? Up until today I haven't had any problems copying and pasting data in this table...it's just really odd that this is happening now.

    I have looked online for solutions to this but haven't found anything that has worked. (including making sure that excel is up to date, restarting the computer, resetting my computer's clipboard). The biggest 'solution' I have seen online is to copy all the data over to a new worksheet...but that didn't work either.

  2. #2
    Board Regular
    Join Date
    May 2018
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trouble Pasting Into a Table

    Solved it. I converted the data to a range. Then I converted it back into a table. This solved the issue. Not sure why, but it works.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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