linked MS Excel cells containing only short texts returning #N/A?
I have several linked cells in my report file that contains text. 80% of them work OK but few of these linked cells are returning #N/A? Some of them got just two words. What puzzles me is the adjacent linked cells with longer text returning correct information! I am using MS Excel 2010 now but I had this problem even with previous versions too. Please help.