I regularly get err:522 appear in the cells in Calc for the current file i have been working on. If I place the cursor over the cell with the error code, the formula in the cell appears correct. If i retype the formula again into the cell, or drags the formula from the adjoining cell if it is a row with the same formula, then the correct results appear in that error cell. Sometimes I notice the err code re-appear in the same cell, and i have to re-type the formula again. Please see the attached tif file for sample of the problem. How can I eliminate this problem? This is quite a large model and it is quite disconcerting for the audience to see error codes randomly peppering the model. Thank you for your help.
Edit: Hagar: changed the title and corrected the error code as said by OP (removed that post). |