Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

Excel 2010 does not update hyperlink references when previous rows to the destination are added or deleted unlike excel XP. I can create a reference as text by searching for the proper cell on another sheet but hyperlinks do NOT accept text as a reference. INDIRECT does not work since hypertext then takes the value at the destination as the reference.

share|improve this question
Is there a question in your statement or are you just venting frustration? This issue would be a lot easier to understand if you added a few examples to illustrate. For e.g. What are "previous rows to the destination"?? – teylyn Feb 8 at 5:28

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.