Login Page - Create Account

Support Board


Date/Time: Sun, 27 Sep 2026 06:55:43 +0000



Spredsheet

View Count: 207

[2026-08-11 16:25:13]
User841161 - Posts: 351
I cleared the values from Column E in my Quotes sheet. However, I have a formula on another sheet that references the Quotes sheet, and it is still calculating using the previous value from Column E.

When should the formula recalculate and recognize that the value in Column E has been cleared? Is there something I need to do to force the spreadsheet to recalculate?

Thanks,
Greg
imageScreenshot 2026-08-11 110236.png / V - Attached On 2026-08-11 16:24:53 UTC - Size: 19.65 KB - 50 views
imageScreenshotQuotes 2026-08-11 110431.png / V - Attached On 2026-08-11 16:25:02 UTC - Size: 11.14 KB - 43 views
[2026-08-11 22:14:26]
Sierra_Chart Engineering - Posts: 24983
We need to look into this.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2026-08-14 20:49:41]
Sierra_Chart Engineering - Posts: 24983
We were unable to reproduce this with a quick test. Everything is working as expected when we tried it. We need to get your original spreadsheet, with values in the cells before they were deleted.

Instructions to attach:
Support Board Posting Information: Attaching a File (Optional)
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account