Forum Discussion
Excel column showing with #ADR
Hello, I have an issue on a user's computer where the same Excel file works fine on mine but on the user's side it shows with "ADR! instead of the actual text. The Office version is the same as o...
426_hemi What formula is in those cells?
- =@IF(@INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE)="","",INDIRECT("Characteristics!r"&(ROW(B16)-13)&"C5",FALSE))
426_hemi I've never seen the #ADR! error code in Excel, and Google doesn't give me any leads either. Perhaps I'm looking in the wrong places. Initially, I get a #REF! error.
Beware that the use of INDIRECT with the FALSE argument in the end creates R1C1-style references. Be sure to change the relevant setting if you want to work with R1C1-style references. When I did that I no longer got the #REF! error.
- Thanks for the suggestion, I appreciate it. I tried on the user's end with the R1C1 ticked and it's still not working.
