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,