title: How do I create a hyperlink from Word to Excel specific cell, without macros/vba?
body: <p>In reference to <a href="https://stackoverflow.com/questions/10436591/creating-hyperlink-from-excel-flowchart-to-ms-word-heading/10436699#10436699">Creating hyperlink from Excel FlowChart to MS Word Heading</a></p>
  
  <p>I would like to know the correct syntax to hyperlink to a specific cell in an Excel Workbook <strong>from</strong> a Word document.</p>
  
  <p>For example: Say I am in word document "Explaining" and I want to insert a hyperlink to the Excel file DataStuff, but to <strong>Cell ZX200</strong>. How would I do this manually, without VBA/MACROS?</p>
  
  <p>I already know that to hyperlink to DataStuff I would type</p>
  
  <pre><code>    File:///c:\users\Win7User\desktop\DataStuff.xlsx
  </code></pre>
  
  <p>Then hit ENTER. (It then becomes an underlined hyperlink. Clicking on it opens DataStuff)</p>
  
  <p>However, I want to add the fact that it should goto cell ZX200, not just open DataStuff at cell A1. The following does NOT work. Can someone fix the syntax for me?</p>
  
  <pre><code>    Does not work:
      File:///[c:\users\Win7User\desktop\DataStuff.xlsx]Sheet1!ZX200
  </code></pre>
  
  <hr>
  
  <p>I don't get how the Excel to Word question was answered in about 10 minutes, and my Word to Excel question accumulated crickets and tumbleweed. No MS Word experts??</p>
  
  <p>I've figured it out after browsing many useless, and one useful document. The correct syntax is:</p>
  
  <pre><code>    File:///c:\users\Win7User\desktop\DataStuff.xlsx#Sheet1!ZX200
  </code></pre>
  
  <p>That should be typed into your word document, and will go to cell ZX200 in worksheet Sheet1 in Excel. Using the information fro the hyperlink I had in my question, you now have a wonderful BIJECTION between Word and Excel hyperlinking. So that when you send people somewhere, you can also send them back!</p>
  
  <p><a href="http://www.shaunakelly.com/word/word-and-excel/excelhyperlinks.html" rel="nofollow noreferrer">http://www.shaunakelly.com/word/word-and-excel/excelhyperlinks.html</a></p>