Hyperlink Does Not Work on Tabs Referencing the Cell with the Hyperlink

		Microsoft Office Forums > Microsoft Excel > Excel
Hyperlink Does Not Work on Tabs Referencing the Cell with the Hyperlink

FAQ

Thread Tools

Display Modes

07-11-2024, 04:18 PM

Guessed

Windows 10 Hyperlink Does Not Work on Tabs Referencing the Cell with the Hyperlink

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,187

The contents of a cell and the hyperlink associated with the cell are independent variables.
If you copy/paste a cell that has a hyperlink then you get both the value and the hyperlink in the paste location. If you subsequently change the cell value to a formula "=SheetName!A1" then the value will update but the hyperlink address won't change unless you manually make those updates for each location.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering text next to hyperlink copies the hyperlink style	abeneschan	Word	0	07-23-2018 02:36 PM
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore	quanghuynguyenhua	PowerPoint	0	10-10-2015 06:17 PM
Hyperlink Format varies, depending on whether Target file was saved or unsaved on Hyperlink Copy	RichardDavey	Word	0	05-26-2015 05:26 PM
Insert the Hyperlink and hide all sheets except clicking Hyperlink	PRADEEPB270	Excel	1	02-22-2013 09:47 AM
Hyperlink Does Not Work	bosmun	Outlook	0	09-19-2011 06:48 AM