Forum Discussion
Referencing cells from excel workbook to another showing #Ref when master workbook is closed
It's because of the structured table references. See Links to data tables residing in external files display #REF!
This will work:
=IF('[p6 test without dalas connection.xlsx]Sheet1'!C2="",2,'[p6 test without dalas connection.xlsx]Sheet1'!C2)
When you close the other workbook, the formula will still work.
It's because of the structured table references. See Links to data tables residing in external files display #REF!
This will work:
=IF('[p6 test without dalas connection.xlsx]Sheet1'!C2="",2,'[p6 test without dalas connection.xlsx]Sheet1'!C2)
When you close the other workbook, the formula will still work.
but can please clarify what changes do you made to make it work?
I can see that we are not referring to the table but to the sheet. What changes should I make next time when I`m working with tables ?
Thanks again bro HansVogelaar
As the article I linked to in my previous reply states, structured table references to another workbook only work if that workbook is open. So you cannot refer to the table name and column name in the formula. Instead, you have to refer to the worksheet name and the cell reference.