Date/Time: Sun, 22 Jul 2018 07:04:19 +0000
Post From: References Between Spreadsheets
|tomgilb - Posts: 1877|
I have built a few spreadsheet systems that reference other spreadsheet Windows. Here are two examples:
1) I color bars in Region 1 with one spreadsheet study, based on formulas in another spreadsheet study that draw lines in Region 2. Even though all study outputs appear in both spreadsheets, not all user columns of each of the 3 spreadsheet studies appear in the all of the other 3 spreadsheet studies so if there are not enough spare user columns I have to reference the other spreadsheet. Expanding the user columns up to 40 has really opened up possibilities (thank you!), but I'm already pushing this limit. So, two questions:
1a) Will the new spreadsheets studies allow more than 40 user columns?
1b) Will the new spreadsheets studies output all user columns to all 3 of the spreadsheet studies?
2) I use the standalone spreadsheets to consolidate user inputs to spreadsheet studies, and sometimes to display spreadsheet study outputs, so inter-referencing spreadsheet Windows is important to me. Several of my clients have systems that use this functionality.
Date Time Of Last Edit: 2013-06-06 00:04:45