Hi,
So I have linked a workbook 1 to workbook 2. The problem is that the second half of the worksheet shows up cells that say #REF! and the other half shows up normally. The #REF! goes away once I open up the second workbook. All the cells are linked to workbook 2 so I don't know why its showing #REF! for only half the cells.
I have attached a picture for reference.
ref issue.jpg
Please help!
Thank You,
Bookmarks