I have a spreadsheet that I’m trying to use INDIRECT within and it just won’t work. This is a spreadsheet that I started over the summer of 2021 and has a bunch of different sheets. So, to make sure I was using INDIRECT correctly I started a new blank spreadsheet to test it out. In the new spreadsheet I can use INDIRECT no problem. Made a copy of my old spreadsheet, deleted out all the sheets except two sheets, named the same as the new spreadsheet, and INDIRECT still won’t work.
The two spreadsheets should be identical now. They both have 2 sheets each (Sheet1 & Sheet2). They both have data in only three cells and the data is exactly the same:
Sheet1.A1: ="$sheet2.a1"
Sheet1.A2: =INDIRECT(A1)
Sheet2.A1: test
Old spreadsheet, Sheet1.A2 gives me #ref
New spreadsheet, Sheet1.A2 gives me “test” - which is what it should.
I’m sure the most likely cause the issue is operator error on my part, I’m just too close to the problem to figure out what’s wrong! Can someone take a look at these two spreadsheets and tell me why INDIRECT works in one but not the other? I would love to know the reason so if I have this issue again in the future I can fix it.
I’m running Linux 64-bit, 7.2.5.2.
Thank you
indirect-no-work.ods (11.0 KB)
indirect-works.ods (7.6 KB)