i am looking up suppliers in another workbook that contains the category/sub category in which they sit. both files sit in the same folder on the network. all data is in text format. I am getting N/As where i should be getting results. everytime i change a cell, or try to Refresh, it kicks off the file open input box. Even if i start to click ok and remap the links, the pop up won't go away and the lookup values don't refresh.
what can be done to correct this?
what can be done to correct this?
