I have links into an external reference in my current worksheet, when I insert a row into the external reference worksheet the formula does not track this change and leaves the reference in it's original position and so my figures are incorrect, please help.
Last edited by theheavi; 04-09-2008 at 10:46 AM.
If both workbooks are open when the row is inserted the references will automatically change.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks