• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlinks

D

drewszone32

Member
I am trying to create a hyperlink between Test file and Bulk file. In Test file, PO # section is where I want the hyperlink to link to Bulk pick bins.xlsx file. Basically want to open up test file and click on PO # and the appropriate bulk pick bins excel file opens up with information.

Thank you
 

Attachments

  • Test.xlsx
    11.2 KB · Views: 4
  • Bulk pick bins.xlsx
    626.9 KB · Views: 3
I have download the Test book, but there are warnings about damaged worksheet and very little content.

Just what is your problem in creating a hyperlink, by using the hyperlink tool in the links section of excel it is pretty straight forward. Can you explain what is not happening. Because of the warnings I do not fancy downloading anything else.


.
 
Sorry for the file not working right. I understand the hyperlink section and have had it work many times. This time it is coming up with an error "No program is registered to open this file". I right click and click on hyperlink then use drop down box to go to file I want hyper linked to cell and error comes up. I am not sure how to fix.
 
Can you open the linked file manually, if not then you may need to associate a file type to it for the hyperlink to work
 
Hi ,

If you wish to be able to click on the PO # and open the relevant file , are your P.O. files named according to the PO numbers ?

For example , your first P.O. number is PC010914-01 ; suppose I rename the Bulk pick bins.xlsx file to PC010914-01.xlsx , then you can introduce a hyperlink to this file , as shown in the uploaded file.

Narayan
 

Attachments

  • Test.xlsx
    8.5 KB · Views: 2
  • PC010914-01.xlsx
    626.5 KB · Views: 3
You must log in or register to reply here.
Back
Top