Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '13 at 5:28

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.