I have a Word document describing a Microsoft Excel document. There is a section that goes through the formulae and describes the dependencies etc for when people might want to make changes in the future.

Now, I have often wanted to insert a row in the spreadsheet, this instantly ruins most of the word document as the formulae (eg "=M12+2") are now invalid (its become "=N12+2").

I use references all the time for figures and they are brilliant - is there any way I can use them for something that isn't a numbered page etc? Each column has a row in the table with the column letter, if I can make every formula reference to that letter, when a change is made all I have to do it update that cell and everything would work fine.

If anyone can help (or have any other ideas) thank you.