Unable to paste in tables

[default_name]

Hello,

I have a large table inside Excel (J1:BZ4597)
The data is in an actual Table (it is not just a range of data) (if you click anywhere in the table the Table Tools tab appears in the top ribbon).
Even though it is a large table I have never had issues before now.

All of the sudden I am unable to copy and paste any data within the table.

For example, if I want to copy data from cell M5 into M45:
I select and copy the M5 cell (the little green dashes dance around the cell).
I go to M45 and I paste it.
Nothing happens. No data is copied at all. It is as i I copied over blank data.

What is going on here?
Thanks

 

[Yongle]

I seem to remember seeing a very similar problem posted a few months ago
- but I did not follow the thread
- I will do a bit of searching to see if I can track it down

Which version of Excel and Windows are you using ?

In the meantime here is code, for you to test, which avoids copy\paste

To keep things simple it assigns the value of only one cell
Formatting should not be an issue inside a table
The code assigns the value of the active cell (or the first cell if more than one cell is selected) to the target cell (which is selected via input box)

Put the code in the sheet module
right click on sheet tab \ View Code \ paste code into the code window \ exit by clicking the X in top right of screen

To run the macro with shortcut {CTRL} q
{ALT}{F8} brings up list of macros
select the macro\ Options \ enter q next to ctrl+ and confirm

Sub CopyPaste()
    Application.InputBox("Select target cell & click ok", "", , , , , , 8).Cells(1, 1) = Selection.Cells(1, 1)
End Sub

 

[default_name]

Thanks Yongle.
It seems to be some sort of Excel glitch.
The next day it all copied over just perfectly....not really sure what's going on...it almost seems as though Excel was just tired and needed to reboot.