View Single Post
Old 04-10-2012, 02:01 AM
hanvyj hanvyj is offline Windows XP Office 2003
Advanced Beginner
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default Referencing something that isn't numbered (eg table, figure etc)

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.
Reply With Quote