When I make a change in an e-mail address in Excel it shows up visually but
when I click on it, it opens an e-mail with the old e-mail address. I can
fix this by scrolling over the cell and hitting enter and the new one
replaces (will this always work? It appears to) or by going to the dialog box
and changing it there but why would this happen. How do I prevent it in the
future. Help