Hi,
I keep facing this issue as below:
But I am unable to tell if this error specifies about the sheet I am working on or the sheet from where it is pulling data ?
So, for example, if I am applying formula in sheet 1 to extract data while referring to sheet 2. And I see cross-sheet reference error, the error does not mention which sheet has many cross-sheet references. Is it sheet 1 or 2? As a beginner, it took me a lot of hit and trials to understand that.
In my understanding, it should be mentioned on the error log.