Continuous error messages when entering any formula in a cell.

Whenever I enter a formula into any cell, I first get the error message, "Can't find project or library." which is then immediately followed with another message titled "References-VBAProject." This lists the first 6 references which are supposed to be missing. However, after receiving the error messages the formulas are always computed correctly once the enter key is pressed. Is there any way to get rid of these error messages?

KAD

these errors occur when it is reference to objects which have either been removed or version downgraded. if you have say excel xp and have a workbook with is referend to outlook xp and then open the workbook on a 2000 it trys to find outlook xp instead of outlook 2000.

a way to stop some of these errors do the following

go to tools/macros/visual basic editor or just press alt + f11. This should open up microsoft VBE. no click on tools/references (if it is grey out then click on run/reset and then try again) you should see a list of items right at the top you should see a line/s saying "MISSING:...." untick that try look down the list to see if there is another version ie. outlook 9.0 could be outlook98 object library so check for that. click ok
close the MS VBE.

you should now be back in excel press save and try what you were doing again. you should not get the "Can't find project or library." error and perhaps the other errors as well. depending what the "MISSING:" ones were.

Thanks be to funkymonkUK.

I tried your cure for the errors and it worked perfectly. Thank you so much for the help.

KAD