Microsoft Office Forums - [Solved] Referencing something that isn't numbered (eg table, figure etc)

Microsoft Office Forums (https://www.msofficeforums.com/)

- Word (https://www.msofficeforums.com/word/)

- -

Referencing something that isn't numbered (eg table, figure etc) (https://www.msofficeforums.com/word/12150-referencing-something-isnt-numbered-eg-table-figure.html)

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.

Hi hanvyi,

You can bookmark whatever it is, then insert a cross-reference to the bookmark.

Quote:

Originally Posted by macropod (Post 32252)

Hi hanvyi,

You can bookmark whatever it is, then insert a cross-reference to the bookmark.

Thank you, that's what I'm looking for.