Spurious #Value Errors

[Gonzoa99]

I have a workbook where I get what seems to be spurious errors when simply pressing enter in a cell. In this particular case, the cell being edited is zero. If I hit enter in the cell, #Value error pop up not only in edited cell but several other locations. If I edit the cell with 0 again and simply hit enter, the errors are resolved. I use alot of named ranges and the use of the @ has been inserted by excel and I admit I don't understand the implications.

 

[J.Ty.]

Hi,

Welcome to the Board!

Can you post a fragment of the affected spreadsheet? Please use XL2BB (you have a link on the toolbar of the editor of posts here).

J.Ty.