Support Board
Date/Time: Sun, 11 May 2025 15:32:19 +0000
Post From: New Spreadsheet Error After Conversion
| [2014-11-01 21:46:26] |
| hft168 - Posts: 31 |
|
Hi S.C. Support, I am getting errors on a spreadsheet converted from the old format before. It was intermittent and I do not know what caused it. 1) Was able to use without error while running some simulated trades in real time. But after the chart is saved and closed, then reopen, I would see "#REF!" and "#Syntax!" errors on cells. 2) These cells have references specifically to other sheets. In the past, after I change a character in the formula (like changing Sheet5 to lower case sheet5, the #ref! would go away, but it does not make sense to me why. 3)the one in my sheet 1 K3 cell is behind the #REF! error is just as simple as: =AND(sheet5!K3), and in Sheet 1's L3 behind the current #REF! is: =OR(And(sheet5!M3,$J$10>=8),$J$10/$J$26<=-sheet3!$J$337) These are simple formulas and I do not know why I get these #Ref! filled up in my K, L columns when I re-open a previous working .scss file. 4) When I open this existing chart with the .scss file, or close the chart file, I see something flashing as ss1, ss2 (like a empty spreadsheet window) along the way, not sure why I see those windows labeled with ss1,ss2. Running version 1205 non-clr. Thanks. |