#Ref Error while Referencing Formula from one sheet to another

#Ref Error while Referencing Formula from one sheet to another

Posted by: Shalini89garg on 23 April 2018, 10:49 pm EST

• 

  Shalini89garg

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

  SpreadJSExportIncludeHeaders.zip

• 

  alex.risch

  • Post Options:
  • Link
    Copy

  Posted 24 April 2018, 2:25 am EST

  Hello,

  This was a bug of the initial v 11 release but has since been fixed. (Tested on build 11.0.6)

  You can download the newer builds through your “My Licenses” page or from the Spread DevChannel.