devabharambe
New member
- Joined
- Sep 16, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013
Sir,
I require your help to resolve data linking problem of two workbook sheet. I want to link data of one workbook sheet to one another workbook sheet, both Workbook kept in as same folder. After linking the data, when i close one of the workbook sheet, the data in other work book is shown error as "REF!". Kindly suggest some formula to link data of both sheet to each other permanently and with the provision of updating automatically in the case where one work book sheet is in close position.
Two workbook are attached for reference.
Always thankful,
Regards
Devendra
I require your help to resolve data linking problem of two workbook sheet. I want to link data of one workbook sheet to one another workbook sheet, both Workbook kept in as same folder. After linking the data, when i close one of the workbook sheet, the data in other work book is shown error as "REF!". Kindly suggest some formula to link data of both sheet to each other permanently and with the provision of updating automatically in the case where one work book sheet is in close position.
Two workbook are attached for reference.
Always thankful,
Regards
Devendra