Links to cells of other worksheets take time to be updated

Shinya

I have run into the following situation multiple times:

I have cells on a worksheet (let's call it "destination sheet") that has links to cells on another worksheet ("calculation sheet"). Cells on calculation sheet are formulas aggregating some cells on another sheet ("source sheet"). After the source sheet is updated, the calculation sheet recalculates immediately, however, the links on the destination sheet to the calculation sheet won't update the final result on the destination sheet immediately. It takes some hours to update the result. I am not sure how many hours it takes, in some occasions, it is 5 hours, in some other occasions it takes a couple of days.

Has anybody run into this situation before too? What is the issue here?

Thanks,

Sean

Paul Newcome

It also depends on the sizes of the ranges in the formulas and how complex the formulas are. Conditional formatting also adds up pretty quickly towards slowing a sheet down.

I have a sheet that I use that has a 10x15 grid with formulas in them. There are no cross sheet references or cell links, but the complexity of the formulas and the fact that they are referencing other complex formulas has noticeably slowed the sheet down.

Paul Newcome

Have you tried refreshing the sheet? Do you have the destination sheet open when you make the changes?

Shinya

Yes, I refresh them multiple times, with all destination, calculation and source sheets open at the same time.

Paul Newcome

Try making the updates with the destination sheet closed. Save all updates. Then open the destination sheet.

Do you have a lot of formulas/calculations/cell links/cross sheet references/conditional formatting going on? All of those things can slow down a sheet.

Cee Johnson

I linked cells from one sheet to another but when I update the source sheet the cells in the destination sheet don't update. Any idea what I 'm doing wrong.

Shinya

I run into the same situation multiple times. So far I didn't get any answer on why it happens and how to prevent it from happening again. I refresh the destination sheet with the source sheet open and the source sheet closed, it doesn't work. I log out of Smartsheet and log in again (after I made the update on the source sheet). It doesn't work. However, What I find out is that the destination sheet will get updated eventually. You just don't know when! Sometimes it takes a couple of minutes, sometimes a couple of hours, and sometimes a couple of days!

Very frustrating!

Paul Newcome

The only time I have run into this issue is when I have very "busy" sheets with a lot of complex formulas, cell links, cross sheet references, and/or conditional formatting.

Shinya

Yeah, probably my sheets are a bit "busier" than ordinary sheets, with about 300 cell links to other worksheets and formulas.

But com' on, 300 cell links/formulas Smartsheet cannot handle?

Sean

Paul Newcome

It also depends on the sizes of the ranges in the formulas and how complex the formulas are. Conditional formatting also adds up pretty quickly towards slowing a sheet down.

I have a sheet that I use that has a 10x15 grid with formulas in them. There are no cross sheet references or cell links, but the complexity of the formulas and the fact that they are referencing other complex formulas has noticeably slowed the sheet down.