Posted 23 April 2018, 10:49 pm EST
We are intermittently facing issue while Referencing Formula from one sheet to another sheet.
It is Giving #Ref Error.
PFA Sample
Steps to reproduce:-
1.Click on sheet 2 and add formula in column TourInMth1 as(=SUM(Sheet1!F3:G3))
2. now drag and fill to next column ,it will give #Ref error.
Can Anyone help on this