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,
Have you tried opening it without updating the links?
Workbooks.Open FileName:=fname, UpdateLinks:=0
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Yes, still not working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks