Links from other sheets are not updating

Avinash Chandra · 05/22/24

Links from other sheets or schedules are not updating, do we have an issue? I had to relink the cells to get updated information.

Stefan · 05/22/24

Hi @Avinash Chandra,

I assume internet connection is ok at your place?!

As we cannot see what sheets and maybe functions you use let me say, that Smartsheet has limits

https://help.smartsheet.com/articles/506775-system-requirements-for-using-smartsheet

and if you get close or beyond these limits, issues like cells connected to other sheets via cell links or cross sheet formulas not updating can happen.

If this is the case reconsider your use of formulas and maybe divide big sheets into smaller sheets.

Hope this helps!

Stefan

Avinash Chandra · 05/22/24

Thanks Stefan, Over here I shall provide you with a scenario:

Schedule have updated dates that flow into a master sheet using links. when we click the link, old data shows up, whereas if you open the schedule its all updated. Basically: update data is not flowing but why do we see two schedules, one with old data and other with updated data.

Stefan · 05/22/24

https://community.smartsheet.com/discussion/comment/437258#Comment_437258

Hi @Avinash Chandra,

are your links individual cell links, or cross sheet formulas using VLOOKUP or INDEX & MATCH?
How many links? Did you check "manage references" in your sheet?

Greetings

Stefan

Avinash Chandra · 05/22/24

Thanks, I did check, is there a way to bulk refresh the references?

Stefan · 05/23/24

Hi @Avinash Chandra,

so, what type of links are you using and how many?

Bulk refreshing should work by reloading the browser without cache.

Greetings

Stefan

Links from other sheets are not updating

Answers

Categories