Support Board
Date/Time: Wed, 27 Nov 2024 08:41:48 +0000
References Between Spreadsheets
View Count: 14275
| [2021-11-15 17:39:46] |
| User337568 - Posts: 60 |
|
Hi: What is the correct reference information for the Master Spreadsheet? I want to create this Master spreadsheet idea, and I get a #REF error in my AGGregation spreadsheet. Here is the error: [ '[ES1439]Sheet1'!E3 ] '[ES1439]Sheet1'!E3 = #REF! (error) I have three spreadsheets: ES1439 NQ1439 AGGChart - intended Master Because the Study Summary Window does not allow text output, I am creating a Master spreadsheet with Text output. I looked on the web and found this excel Workbook reference information: [Workbook_name]Sheet_name!Cell_address I can post the chartbook if desired, but I am lost with how to reference the slave workbooks into the Master. In my case, the Master is "AGGChart." |
| [2021-11-15 17:56:34] |
| John - SC Support - Posts: 36309 |
|
Refer to the information here: Working with Spreadsheets: References to Other Sheets within a Spreadsheet For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-11-15 18:49:56] |
| User337568 - Posts: 60 |
|
Thank you and I couldn’t get that working. Perhaps I’ll just post my test Chartbook and someone might help get me started. Date Time Of Last Edit: 2021-11-15 21:15:34
|
| [2021-11-15 20:15:23] |
| John - SC Support - Posts: 36309 |
|
You can not reference data between different Spreadsheets. Refer to the information here: Working with Spreadsheets: References to Other Spreadsheets Windows For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: