Login Page - Create Account

Support Board


Date/Time: Fri, 07 Aug 2020 04:11:33 +0000



Spreadsheet study data does not update

[2015-07-17 07:57:04]
User386687 - Posts: 53 | Ending Date: 2015-11-19 [Expired]
I have attached a spreadsheet study to a chart and I receive the study quote to the Sheet1 without any problems (updates ok).

But when I try to use the quotes from Sheet1 on another sheets the data does not update. Please see attached picture about the situation. In the given example the Calcs!B2 should contain the Sheet1!E3 value but it does not update it. It is showing the intial value when formula was created.

I have checked the Autoupdate in the Spreadhseet menu.

So what I am doing wrong ?
Date Time Of Last Edit: 2015-07-17 07:59:11
Private File
[2015-07-17 08:07:19]
Sierra Chart Engineering - Posts: 88410 | Ending Date: 2021-04-05
Update Sierra Chart to the latest release and see if this solves the problem. You can update with Help >> Download Current Version.
Sierra Chart Support - Engineering Level

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

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-07-17 08:52:41]
User386687 - Posts: 53 | Ending Date: 2015-11-19 [Expired]
Now it does the update BUT now all the formulas which are using this value (except the cell where it is fetched) will give #REF! error (see attached pic).
Private File
[2015-07-17 08:58:28]
User386687 - Posts: 53 | Ending Date: 2015-11-19 [Expired]
I did not change anything but restarted the SC manually and now it works !

No #REF! anymore.

Thx.
[2015-07-17 09:00:53]
Sierra Chart Engineering - Posts: 88410 | Ending Date: 2021-04-05
We are working on solving the #REF! error.

We are putting out a new release in about an hour to solve this.
Sierra Chart Support - Engineering Level

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

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.

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

Login

Login Page - Create Account