Forum Discussion
Why does the #REF error remove formulas irretrievably? How to find lost references?
Dear Community, I am frustrated beyond measure over the infamous #REF Error. Up to now I was "only" frustrated over having my formulas turned from ='[Filename.xlsx]Sheetname'!CellReference into =...
interesting that you ask.
I definately have both kinds in my sheet, but those that I managed to recreate were all of the first kind, i.e. a link on its own, not part of a surrounding formula
update: it definately happens bit both kinds of formulas.
And it does so, if the referenced workbook is open.
I really hate Excel for this behavior.