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...
=@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.
426_hemi Well, without a file to play with I cannot help you. Share a link to it via Onedrive, Dropbox or similar.
Riny_van_Eekelen I appreciate your interest, unfortunately since it's company data, I cannot share it. What I did, was to send the issue to the owner of the file and let's see maybe he has some ideas.
Thank you