Trouble Pasting Into a Table

default_name

Board Regular
Joined
May 16, 2018
Messages
170
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
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.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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. :)
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,027
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top