For page scoped range names, =SheetName.RangeName does work, but =INDIRECT("SheetName.RangeName") it shows #REF!
Steps to Reproduce:
1.Open new Spreadsheet with sheets "Sheet1" and "Sheet2"
2.Set Sheet1.A1 =XXX
3.Define a new named range:
- Select Sheet1.A1
- Sheet > Named Ranges and Expressions > Define...
Range or formula expression: $Sheet1.$A$1
4.Verify that the named range works:
- Set Sheet2.A1 =Sheet1.MyNamedRange
The cell displays: XXX
5.Refer to the Cell using INDIRECT:
- Set Sheet2.B1 =INDIRECT("Sheet1.MyNamedRange")
User Profile Reset: No
Created attachment 149677 [details]
Test case that demonstrates the reported bug. Sheet2.B1 shows #REF! instead of XXX
The example file documented in the bug.
Created attachment 149679 [details]
i can see the problem, but i am not sure if this is a bug,
cause ms excel 2016 will show an error too.
*** This bug has been marked as a duplicate of bug 100818 ***