Support Board
Date/Time: Sun, 11 May 2025 15:24:09 +0000
Post From: New Spreadsheet Error After Conversion
| [2014-11-02 03:14:09] |
| hft168 - Posts: 31 |
|
Just ran more tests on the spreadsheet. 1) Remove chart 2 (using sheet 2 as spreadsheet trading system) and other charts, with sheet 1 (spreadsheet trading system) and sheet 5 (spreadsheet alert) active. 2) Fixed the #ref! in sheet 1 K3 (formula =AND(Sheet5!BI3>0,Q3) ) by changing the case of "s" in "Sheet5!BI33>0, to get the right true/false result. Then save the spreadsheet alone first. 3) Close the Chart and click on Yes to save the chart but "NO" to save the spreadsheet on exit. If done this way, when I reopen the chart, I do not have the #Ref! on the K column. 4) If I click "Yes" on exiting the Chart to save the spreadsheet, then reopen the chart again, I will have the #Ref! on K column with =AND(Sheet5!BI3>0,Q3) in K3, I have to type lower case "s" to get rid of the #Ref!, and can not click on "Yes" to save on exit. It seems like on the Chart Close, there may be a glitch to save the spreadsheet formula referencing other sheets within the spreadsheet. Hope this would help to reproduce the problem on your side. |