ExcelBanter - Why lose hyperlink when copying and pasting?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why lose hyperlink when copying and pasting? (https://www.excelbanter.com/excel-discussion-misc-queries/100103-why-lose-hyperlink-when-copying-pasting.html)

Infidel70

Why lose hyperlink when copying and pasting?

When copying hyperlinks from one excel spreadsheet to another, the hyperlink
is being lost in the pasting. Any ideas why and how to combat this?

Anna

Why lose hyperlink when copying and pasting?

You may use paste special instead of paste and make sure the check box of
'all' is checked.

"Infidel70" wrote:

When copying hyperlinks from one excel spreadsheet to another, the hyperlink
is being lost in the pasting. Any ideas why and how to combat this?

All times are GMT +1. The time now is 02:21 AM.