Formulas changing cell references for not apparent reason

Hi,

I have a spreadsheet with the following formula used in one column.

=((C10*3)+(E10*2)+(J10*5)+(F10*3)+(G10*3)+(I10*3))/('Projected Time'!AA6/100)

'Projected Time' is another worksheet in the same workbook. For some reason, some of the cell references change for no apparent reason. For example, today I opened the spreadsheet and the cell L15 read:

=((C15*3)+(E15*2)+(J15*5)+(F15*3)+(G15*3)+(I15*3))/('Projected Time'!AA11/100)

After I had finished entering data into the workbook, the cell had changed to:

=((C15*3)+(E15*2)+(J15*5)+(F15*3)+(G16*3)+(I15*3))/('Projected Time'!AA11/100)

This then replicated from cell L15 down to the end of the formulas in the column (L32). Cells L1 to L14 were still correct (had not changed).

I had not deleted any cells on any of the worksheets of the workbook so I have no idea why it would have changed.

I am using Excel 2003 (version 11.5612.5606).
Has anyone encountered this problem before?
Does anyone have any idea on how I can prevent this from happening?

Thanks

Psycho_chook

The change in your formula from g15 to g16 indicates a cell was inserted in column g in possible row 15

I hadn't inserted or deleted any rows, cells or columns. That is the frustrating thing. There is no apparent reason for the change in the formula......

me too!! Did you solve this issue? I appreciate this is a really old thread, but I could really do with the solution!!