Excel: How to make a hyperlink that excel has no way to change ?


  1. DonMurray
    Posts : 252
    os build 17143.950
       New #1

    Excel: How to make a hyperlink that excel has no way to change ?


    If you try to tie a image to a cell in excel and then you link that image to its file. Excel because the image was embedded in the cell it will change the hyperlinks on you. but if you just link a image to text in a cell I do not believe excel will change the hyperlinks.
    in windows 7 or windows 10 with office 365 i think this is true? I am still trying to find a way to make a picture stay in its cell and not change its size and be able to sort and have the image stay put in its cell.
      My Computer
    Quote Quote

  3. sygnus21
    Posts : 5,899
    Win 11 Pro (x64) 22H2
       New #2

    I'm not sure what you mean by "changing links" but, if you say link an image in Excel to one on a local PC, and you transfer the spreadsheet to another PC, without the linked file(s), the link(s) will be lost because Excel has no idea where those files are.

    If you link to any local items, and intend to share or move the docs around, it's best to place everything in a single folder (including the spreadsheet) so that transporting folder has all the linked files. Of course the easier thing to do would be to place the items online and then link to them. This way Excel will always know where to find the files. Think of this as a permanent address that never changes.

    As to images being resized, I've never seen Excel resize any images placed there unless told to do so.

    Let me know if I've misunderstood anything?
      My Computers
    Quote Quote

  4. DonMurray
    Posts : 252
    os build 17143.950
    Thread Starter
       New #3

    Ok so I could make a webpage on our website and load all the images on their and then link to them. Yes then the picture price sheet might work with excel on the ipad. MAYBE !
      My Computer
    Quote Quote

 

  Related Discussions
command button name change in excel 2016
in Microsoft Office and 365

I have introduced a command button for running a macro in windows 10 excel 2016. the name of the button is shown as button 2. I want to change this. how to do it
On some Excel forum user would like to have a 'test Excel-sheet' so as to avoid confusion and provide the right answer(s) to a question. This is quite okay. However, such 'test' sheets by default include the name of the author and email address...
Hello - I have one computer on build 17763.475 version 1809, the rest are version 17763.437. On this particular computer whenever you click on an external hyperlink, excel closes. I have read several forums where it says to remove the "god-mode"...
I know how I'm supposed to do it, SETTINGS==>DEFAULT APPS==>CHOOSE THE DEFAULT APP BY FILE TYPE, but Excel 2016 is not an option. Instead, it tries to send me to the App Store. I think I have tried everything except reinstalling Office.
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 08:30.
Find Us




Windows 10 Forums