I have reviewed other questions which get 'close' but don't quite address my issue.

I have a range of cells like (which we will call A1,A2,A3)


within each cell I would like to embed a hyperlink in each cell in that range which would look something like: =HYPERLINK("http://www.myURL.com/user/" & A1,"Bob") so that the URL effectively becomes http://www.myURL.com/user/bob

This (understandably) creates a 'circular reference'...Is there anyway around this?

1 Answer 1


This (understandably) creates a 'circular reference'...Is there anyway around this?

You can get circular references to work by going to File > Spreadsheet settings > Calculation > Iterative calculation in your spreadsheet and switching that to "On".

You can also set the number of iterations the circular references will be calculated for. For your case, you might need to set this to 1 or 2 or something like that to get the exact behavior you're looking for.

  • 1
    It did require a number of iterations = 2 (on the first iteration the result was 0) but after that it worked perfectly. Thanks so much.
    – Cos Callis
    May 25, 2017 at 19:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.