Hi,
Maybe this is simple but I have a link in a cell A1 on sheet2! which
refers to sheet1! A1

When I goto manually change this link by typing the link in and press
enter it wont take in the cell. the formula shows.

How can I type the link in manually instead of copy paste link???

thanks