Support Board

Date/Time: Sun, 19 May 2024 04:56:07 +0000

Post From: SPREADSHEET FORMULA DISAPPEAR AFTER SAVING AND CLOSING CHARTBOOK

[2019-11-01 19:50:42] Link To Thread - Link To Post [Go To First Post]
Chad - Posts: 231
Hi @SCE, I have a similar issue as OP - while I'd saved my modified SSfT under a new name along with the Chartbook which had it applied to several Charts (side note: did this March 2019), when I opened that Chartbook today, the formulas of the sheets as-loaded within the Chartbook were gone. If I open the spreadsheet by itself outside of that book, all's fine. So I re-opened the Chartbook & went to study settings for that SSfT, changed In: 55 (Always Set Formula Source Sheet To Chart Data Output Sheet) to 'Yes', and In: 70 to 'By Name'. After applying, the formulas are still missing, I presume due to general 'order of operations'. So question: should I remove the SSfT study then reapply it to fix this? Side note: I never noticed this happening when closing & reopening Chartbooks with my custom SSfT & formulas applied, in the release versions that were current this past spring.