Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 16:38:37 +0000



Post From: version 1116 non CLR spreadsheet

[2014-04-08 20:48:10]
Sierra Chart Engineering - Posts: 104368
This is what we found in regards to this:
All of the formulas the user posted are fine and do not give any errors in the current version. The #REF! errors must be coming from one of the referenced cells that is not visible, such as AJ3. Or there may be some circular reference among the given formulas, but I cannot tell without knowing where those formulas were located. I may need a copy of the whole spreadsheet to see where the error is coming from.

One thing we can let you know is circular references are not supported at all.

Can you provide us a simplified example spreadsheet to demonstrate this #REF! error?
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2014-04-08 20:48:39