Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Hyperlink two workbooks (https://www.askmehelpdesk.com/showthread.php?t=694384)

  • Aug 16, 2012, 11:49 AM
    degiordani
    Hyperlink two workbooks
    I hyperlink two workbooks but ones I do that I am not able to make any changes to the hyperlink workbook (2). If I make changes to the master workbook it changes the hyperlink workbook which is what I want it to do but this hyperlink workbook (2) will be send to several different people in which they will need to fill out there section as needed. How can I make changes to the hyperlink workbook (2)?
    Anyone knows?
  • Aug 16, 2012, 08:08 PM
    JBeaucaire
    I am sorry, your scenario isn't really clear. How do hyperlinks assist with editing? That's not their functions. Are you using the right terms? Do you mean just "link"?

    What are the formulas in some of these cells?
  • Aug 17, 2012, 05:48 AM
    degiordani
    Sorry for the confusion. It is hyperlink, I copy one workbook and I special past and select the hyperlink feature. So any changes I make to the original workbook gets automatically changes in the hyperlink workbook. The workbook is a form that needs to be filled out by several different employees, so how can they fill it out? Since its hyperlink it does not allow me to make any changes to it. It doesn't have formulas its just a form

    I hope that makes more sense.
  • Aug 19, 2012, 03:45 AM
    JBeaucaire
    What you're describing is not a "Hyperlink", it's just a "linked cell". A hyperlink is a clickable cell or text string that when clicked brings up another document or web page onscreen.

    This is a hyperlink: Google

    You are correct, linked cells (cells with formulas in them that link back to an external workbook) cannot be edited manually without destroying the links. The point of a linked cell is to show edits made in the OTHER workbook. So, changes would need to be made in the source cells, not the cells with the formulas.

    What you're observing is correct designed behavior.

  • All times are GMT -7. The time now is 05:26 AM.