Unable to paste multiple cells, individually

[Fos605]

Hi,

I have excel 2007 workbook.
My problem is that I cannot copy a cell, and then paste it into multiple locations.

I can, if I select all the cells I want it pasted into, and do it in one action,
but if I copy a cell, paste it into a single cell, and then move to another cell, it seems as though it has lost the previous copy data.

This does not happen in all workbooks,but certainly does in one.

Has anyone any idea of what is causing this?

Thanks

[oldchippy]

Hi,

When you paste it are you hitting the enter key after? If you are don't, just go to the next cell and paste.