Issue: Users may occasionally encounter #REF errors in specific cells within various active workpapers.
​
​

Cause: This issue may arise due to named ranges being deleted or formula linkages not functioning correctly.

Resolution: Attempt to resolve the problem by deleting the workpaper record from the side pane and the corresponding Excel sheet. Afterward, re-add the workpaper.

If the issue persists, ensure you are using Excel 2019 or a later version, or Office 365, and confirm that your Excel software is up to date.