I am trying to use INDIRECT to reference another worksheet and get the #REF error code.
The worksheets have all been made from scratch in Libreoffice 7.0 and still I get the issue.
When opening the formula checker I get only green tickmarks for the individual elements in the formula but still theresult is #REF.
JAN.IN is the name of worksheet where to pick up the date needed.
Can anyone help out.
The Problem is the .dot'in Sheetname, because .dots are reserved for delimit between Sheet- and Celladdress.
Replace the .dots in your Sheet[s] -names with _underscore.
… or use =INDIRECT("'" & G7 & "'.D65") (putting the sheet name into single quotes)
Thanks. Sorry but none of the proposed corrections work. Is there a setting somewhere that is critical for Calc to perform these type of operation?
Could it have anything to do with the fact that the sheet named JAN.IN is a copy of a sheet named JAN in the same workbook?
When copying a sheet and renaming it, are there something one needs to be aware of in terms of settings etc.?
Sorry, that it doesn’t work for you, but I’ve tested with exact the same JAN.IN sheet name in a test document before proposing. Please provide an exact copy of your formula.
Hi. Thanks. I found the error.
Hi guys. Sorry my brain seems to be full of cobwebs.
Karolus. You are right. Took me a long time to understand what you meant. You are talking about the naming convention for sheets in a workbook. So when I change the name of the sheet from JAN.IN to JAN_IN the formula works. And it does.
Thanks to both of you and sorry to have taken your time.
