Paste formula: Excel 2013

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.

Hi. Thanks Winon.
I can't find those specific settings to check.
I've done some more checks.
The problem seems at this stage to be limited to this kind of formula: =IF($KK3="";"";OFFSET(INDIRECT("[Filename.xls]Sheetname!"&$JF3);$JC3+$KK3+7;-4)). With Error checking on, Excel warns "Inconsistent calculated column formula". However the formula is(hopefully) correct. Have used it before. The formula results look/are correct. It just looks like Excel is trying to prevent an error. As I have stated above, Excel is happy to paste one cell at a time, but not more than one.

Hi Winon.
Thank you for your reply.
I thought I commented on your reply yesterday but my comment is not visible.
The formula is contained in an xlsm file and all is good as far as I know.
I have done some more tests.
I have activated the Excel clipboard pane in Excel 2007 and 2013. When copying this formula the Excel clipboard says in both cases "(preview not available)"
With other cells with formulas details show up in the excel clipboard in both versions.
I have opened an older file with the same formulas in and this file copies and pastes the formulas correctly.(although still"(preview not available)")
It would seem to me the file itself is affected.
Is there a way of doing a check on this or a good(not expensive) Excel file repairer?
Many thanks for those who have read my questions.

Hi all.
One last thing for thought.
If I edit a formula in a column and press enter, I get a small autocorrect options notification next to the cell. If I press this, I get an option "Replace all the cells in this column with this formula"If I select this Excel does just that, perfectly. The whole column fixed.
Why is Excel happy to do it but it won't let me decide?

Thanks Winon.
I didn't spot the ;
However this was a Windows setting from Region settings, Control Panel. Windows had set the "List separator" to ; I have now changed it to ,
I had some considerable trouble with these settings previously by the way and found that the settings for South Africa did not suit me at all and I have changed them bit by bit.
I will carry on checking but at this stage the situation remains the same.
Any thoughts on my previous post?(The autocorrect story)

Thanks again Winon.
A good idea.
I allowed autocorrect to "fix" my formula.
It changed it to the formula before the last edit, which was only changing the +7 close to the end of the formula to read +3. In other words changing the +7 back to +3. This was merely an edit to read the correct column in OFFSET.
After changing the +7 to a +3, the autocorrect notice disappears.??? However, Excel will still not copy the "corrected" cell.


Other possible questions:
The file is corrupted.(Is there an easy way of checking)
Is there a difference between the capabilities of Excel in "Microsoft Office Professional Plus 2007" and the Excel in the "Office Home and Student 2013" Version?
My Office 2013 installation is shaky and needs reinstallation.(Nightmare)
My Windows 8.1's operation is shaky for some reason.
I must give this problem a break. My brain is too tired of it at the moment.