Support Board
Date/Time: Sun, 22 Dec 2024 20:04:12 +0000
Spreadsheet | An overview sheet not correctly updating referenced cells
View Count: 818
| [2015-06-01 12:15:35] |
| User10875 - Posts: 42 |
|
Hello, I have one big spreadsheet with around 90 sheets (not using excel). In each of this sheets basic calculations are done. I have one "Overview" sheet within the spreadsheet where all the results are sent to via simple references (e.g. Overview Sheet A3 = SheetXY!A3). Now the problem is that the values in this Overview sheet are not corresponding to their source values. Some do correspond whereas others don´t. If I click in of those cells with wrong values and press enter nothing happens. But if I change the formula slightly (for istance: from Sheet40!J3*100 to Sheet40!J3*50)then press enter and then back to the original formula (i.e. Sheet40!J3*100) and pressing enter, the correct value is shown. Is this an updating problem and how can I fix this? Thanks. Kind regards Sh. |
| [2015-06-01 20:47:35] |
| |
|
Are you using New Spreadsheets or Old Spreadsheets?
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 |
| [2015-06-02 08:29:00] |
| User10875 - Posts: 42 |
|
New One.
|
| [2015-06-02 09:18:58] |
| |
|
OK there has been a lot of work done on New Spreadsheets since the versions we see you are running. Update your copies of Sierra Chart that are using Spreadsheets to the latest version by selecting Help >> Download Current Version. After updating, if you still see a problem, let us know and attach one of the Spreadsheets you are working with so we can test it. It can be privately attached. 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: 2015-06-02 09:19:25
|
To post a message in this thread, you need to log in with your Sierra Chart account: