Support Board
Date/Time: Tue, 04 Mar 2025 15:09:47 +0000
Post From: What causes J41 to update?
| [2021-11-29 23:40:12] |
| j4ytr4der_ - Posts: 946 |
|
In a Spreadsheet, what exactly causes cell J41 to update or not? I keep having problems where it doesn't update for up to many seconds - 10 or more sometimes - and it's making it very difficult to build what I'm trying to build. Everything I'm doing works perfectly if I happen to catch J41 when it's updated, but way too often it just doesn't. I'm using ISSAMETIMETOSECOND() to make certain things happen only when an order has been moved, which means I need to compare J41 to other things and it fails way too often. I can of course use ISSAVETIMETOMINUTE and it will always work, but only once in any give minute which isn't ultimately acceptable for my purposes. Is there in fact any way to force J41 to keep up with real time? I've also tried adding the Chart Recalculation Periodic study and it didn't seem to make a reliable difference. |