When I create links to cells in other worksheets either by manually typing the information in the =Worksheet!Cell Reference format, or by doing a Copy->Paste Special->Paste Link, everything works fine. But if I try to manually edit the cell formula, to change either the cell reference or the worksheet name, it destroys the link and just shows the entire formula =WorkSheet!Cell Reference as text. This happens even if I just delete a single character of the formula and retype the same character. Is there something special I need to do to preserve the link information after a manual edit?
Bookmarks