Microsoft excel formulation unstable

  JohnM. 05:50 01 Dec 2003

I have a large spreadsheet with 30 columns and over 700 lines. One section has to be added up down 6 columns. I am making constant alterations by adding new lines. Problem this seems to affect the addition formula which is always losing the top range of the columns. ie x2:x700 becomes x25:x700 how do I stop this.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Shadow of the Tomb Raider review

Julian Glander recreates your art school experience in quirky video game Art Sqool

iPhone XS vs iPhone X: What is the difference?

TV & streaming : comment regarder la Ligue des Champions 2018-2019 ?