Hi I will try and be brief.
I have complex spreadsheets with some complex formulas.
In Excel 2013 recently installed, Windows 8, copying a formula to another set of cells, a fairly normal thing in Excel, wow, it looks like its done but it hasn't. It will copy the formula ONE CELL AT A TIME, however.
Is this:
1. A setting in Excel?
2. A faulty installation problem?
3. Something I don't know about in Excel 2013?

Opening the same file in Excel 2007 on a different machine and copy and paste behave predictably.

This is a disaster as one cannot assume cells have pasted and one has to check each cell.

This naturally makes my Excel 2013 unusable.

It seems to behave normally with cells without formulas.

My Excel 2013 is fully updated as far as I know.