[OPEN] Formulas using hidden sheets in excel show as “#REF!” in DocViewer


Engineers are currently investigating the issue.


If using a hidden sheet in an excel formula docviewer fails to render the cell with the right value

Expected Behavior

Allow formula values to render that reference cell data in hidden sheets


No workaround exists at this time.

Steps to Reproduce

  1. Create an excel file with at least two sheets

  2. On one sheet show a list of values (I just used a list of numbers)

  3. On the second sheet reference a cell from the first sheet (=<sheetname>!<cell>)

  4. Notice it renders the value

  5. Right click the first sheed in the bottom and select ‘hide’

  6. Save and upload to Canvas

  7. Notice now that the value shows as ‘REF!'

Additional Info


Known issues indicate notable behaviors that have been escalated to the Canvas engineering team. Known issues are not a guarantee for an immediate resolution. This document is for informational purposes only and does not replace the Support process. If you are encountering the behavior outlined in this document, please ensure you have submitted a Support case (per your institution's escalation process) so Canvas Support can adequately gauge the overall customer impact and prioritize appropriately.

Labels (1)