Support Board

Date/Time: Fri, 26 Apr 2024 14:50:20 +0000

Post From: Keeping spreadsheets light

[2013-09-04 12:38:09] Link To Thread - Link To Post [Go To First Post]
Bedhog - Posts: 167
This is my workaround for the cell references. When adding new studies to a chart, move them down to the bottom of the "Studies to Graph" list. This has allowed my spreadsheets and defined cell references to remain intact because the new study outputs will appear in the unused cells far to the right in the spreadsheet. If you find that you don't want that study, but suddenly find out it will jazz your references, just hide the study so it no longer shows up on the chart. If you are using a low number of rows, the impact should be minimal on a capable computer.