Copy/Paste formulas in merged cells

[Excel User 123456]

I have a spreadsheet that has merged cells in the following cells: A1&B1,
C1&D1, E1&F1,G1&H1,I1&J1 AND K1&L1. A1&B1 and C1&D1 have values, E1&F1
formula is =A1, G1&H1 formula is =C1. When I copy cells E1&F1 and G1&H1 into
cells to the right I1&J1 and K1&L1 the forumla stays the same such as it
treats it as an absolute but there are no $ in the formula. The formula
should change to I1&J1 =E1 and K1&L1 = G1. When I copy this into another
sheet within the workbook it works and when I copy it into another workbook
it works but within the existing sheet it does not. Sorry if this is
confusing - any suggestions?

 

[David Biddulph]

Tools/ Options/ Calculation
Set to Automatic, not Manual.

 

[Excel User 123456]

I forgot to mention that this workbook was originally created in an older
version of excel and this is happening in 2007 version.