Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.