Support Board
Date/Time: Wed, 27 Nov 2024 08:27:41 +0000
Post From: References Between Spreadsheets
| [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." |