+ Reply to Thread
Results 1 to 3 of 3

Linking excel cell to a specific onenote notebook/document

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    philly, pa
    MS-Off Ver
    2013
    Posts
    27

    Linking excel cell to a specific onenote notebook/document

    Attempting to link my client notes from onenote to a client tracking system in excel. Would like to have a specific cell assigned to each client that when clicked in excel, will take me to the updated onenote notebook.

    Is there a way to do this? Attempted to insert a hyperlink but failed...

    If not possible, is there a different option than onenote that will work?

    Many thanks!

  2. #2
    Registered User
    Join Date
    02-09-2011
    Location
    philly, pa
    MS-Off Ver
    2013
    Posts
    27

    Re: Linking excel cell to a specific onenote notebook/document

    Would appreciate if anyone has any ideas here. Thanks in advance everyone!

  3. #3
    Forum Contributor
    Join Date
    04-07-2009
    Location
    Rowley
    MS-Off Ver
    Excel 2007
    Posts
    326

    Re: Linking excel cell to a specific onenote notebook/document

    I do not use Onenote, so I created a new file and had no problems opening the file using the Insert Hyperlink from the Ribbon.

    Attempted to insert a hyperlink but failed...

    What exactly happened?

    I received Two security warning about opening unknown files, but otherwise it was a straight forward operation.

    Select Insert Tab
    Select Hyperlink

    In the Link to Box, on the left side of popup, Select Existing File or Web Page if it is not already selected.
    In the Look In box, navigate to the location of the file.

    You may need to double click several folders to get to the location of your file.
    My test files were located in the folder called: C:\Users\xxx\Documents\OneNote Notebooks\Test File
    Then Select the client file, IE Client A.one
    Click OK

    If you do not want the full path displayed in the cell, in the Text To Display box at the top of the Hyperlink window,
    change it to something more suitable, like Client A One Note

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How Can I: Link from OneNote to a Specific Sheet/Cell in Excel?
    By Sandcastle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-29-2015, 05:14 PM
  2. Need to open a OneNote notebook from Excel
    By Raennor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2013, 06:12 AM
  3. Linking specific Excel ranges within a work book into a Word Document
    By singerbatfink in forum Word Formatting & General
    Replies: 2
    Last Post: 01-21-2011, 05:13 AM
  4. Linking an Excel cell to section of a Word Document
    By CharlesEric in forum Excel General
    Replies: 4
    Last Post: 08-14-2009, 02:53 PM
  5. Replies: 0
    Last Post: 04-14-2009, 11:03 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1