Sign in to submit new ideas and vote
Get Started

Cross-sheet reference error for which sheet?



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.

1 votes

Idea Submitted · Last Updated