ExcelBanter - RE cell wont update with new link

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - RE cell wont update with new link (https://www.excelbanter.com/excel-worksheet-functions/131001-re-cell-wont-update-new-link.html)

pano

RE cell wont update with new link

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

Desmond

RE cell wont update with new link

What is the format of your typed link?

"pano" wrote:

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

All times are GMT +1. The time now is 04:34 AM.