Support Board
Date/Time: Sun, 22 Dec 2024 19:10:47 +0000
Post From: Spreadsheet | An overview sheet not correctly updating referenced cells
| [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. |