Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2012, 02:01 AM
hanvyj hanvyj is offline Referencing something that isn't numbered (eg table, figure etc) Windows XP Referencing something that isn't numbered (eg table, figure etc) Office 2003
Advanced Beginner
Referencing something that isn't numbered (eg table, figure etc)
 
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
  #2  
Old 04-10-2012, 03:07 AM
macropod's Avatar
macropod macropod is offline Referencing something that isn't numbered (eg table, figure etc) Windows 7 64bit Referencing something that isn't numbered (eg table, figure etc) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi hanvyi,

You can bookmark whatever it is, then insert a cross-reference to the bookmark.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-10-2012, 03:30 AM
hanvyj hanvyj is offline Referencing something that isn't numbered (eg table, figure etc) Windows XP Referencing something that isn't numbered (eg table, figure etc) Office 2003
Advanced Beginner
Referencing something that isn't numbered (eg table, figure etc)
 
Join Date: Feb 2012
Posts: 33
hanvyj is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
Reply

Tags
word reference

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple referencing SPRITEtoo Word 3 01-29-2012 07:39 PM
Referencing something that isn't numbered (eg table, figure etc) How to Start from 1. automatically after copying/pasting a Numbered Bullet or Table drlili Word 2 07-25-2011 09:38 AM
Table/Figure Captioning trhindc Word 0 04-15-2010 08:25 AM
Referencing Previous Numbered List QUL001 Word 0 03-18-2010 12:14 AM
Cross-referencing figure in Word 2003 - Problem ultimateguy Word 0 07-30-2009 12:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft