Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 15:34:29 +0000



Post From: References Between Spreadsheets

[2021-11-15 17:39:46]
User337568 - Posts: 59
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."