Excel: How to remove hyperlink from cells in Excel 2007

[PVPSleightxlegend]

this is the long way just select a random cell cmd-a on mac right click remove hyperlinks

[YVAmmangen]

@PVPSleightxlegend I'm not Mac, I'm PC and on PC you can right click on one cell to remove the hyperlink but if you need to remove the hyperlink from a range of cells that option doesn't work. Does it on Mac?

[PVPSleightxlegend]

@YVAmmangen yea

[YVAmmangen]

@PVPSleightxlegend then that makes Mac better than PC! :)

[Steerpike07]

Yes - that worked! Via Control Panel and Admin Tools in System Maintenance you can assign a different letter which has made all the hyperlinks work again. I just don't think laterally enough!

[YVAmmangen]

@Steerpike07 Yeah! So glad to hear you got it working again. I'll have to try to replicate it too.

[Steerpike07]

Maybe there's a way to relabel the directory address from (H:) to (G:). That would be an easier way to do it. Thanks anyway.

[Steerpike07]

How do I change the base address for mutliple hyperlinks simultaneously? The base hyperlink address is supposed to default to the active workbook location but mine has ceased to do that (it's on a usb whose directory address changes according to which socket I put it in).

[YVAmmangen]

@Steerpike07 I have no idea to be honest. :( Sorry

[ajramirez123]

Thanks :)

[laceyfam]

Thank you!

[YVAmmangen]

You are welcome and thank you so much for commenting on the video as well.