Link from cell in other sheets not being updated

Shinya

Hi,

I recently repeated run into a situation that a cell (destination cell) which has a link from another cell (source cell) on other sheets (source sheet) was not updated automatically. I had to open the source sheet for the destination cell to update. This is driving me CRAZY! Why is this? Help!

Sean

Shinya

I do have a big number of cell links (around 150 cells on a sheet are linked to cells on various other sheets), but that's the very point. I can't reduce the number of links. I am sure the number of links is still well below the limit set by Smartsheet.

Thanks for your advice though.

Shinya

Bassam Khalil

Hi @Shinya 

Hope you are fine, could you please check if you have hi load of request and calculation in your sheet ( automation - big number of cell links - big number of complex formula) , my advice to you to speed up the update if you can use VLOOKUP instead of cell linking and minimize the number of automation by reconfigure it using conditions. please check the following article maybe it will help you

Cell Links: Consolidate or Maintain Consistency of Data | Smartsheet Learning Center

https://help.smartsheet.com/articles/861579-cell-linking

Cell linking is useful when you want to consolidate information from multiple sheets.

Bassam Khalil

Hi @Shinya 

Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Shinya

I do have a big number of cell links (around 150 cells on a sheet are linked to cells on various other sheets), but that's the very point. I can't reduce the number of links. I am sure the number of links is still well below the limit set by Smartsheet.

Thanks for your advice though.

Shinya