Skip to main content
May 10, 2010
Question

Linking to specific cells in an Excel spreadsheet no longer working

  • May 10, 2010
  • 1 reply
  • 562 views

I use RoboHelp HTML version 7 and just upgraded to MS Office 2007.  I have project that contains hyperlinks to specific cells in an Excel spreadsheet using the following syntax: <a HREF="../file_name.xls#cell_name">  (a tip I found on Peter Grainge's website).  This worked fine with Office 2003.

With Office 2007, however, the hyperlink opens the Excel spreadsheet to the first cell on the first tab regardless of the the #cell_name suffix.  I've tried the following with no success:

  • delete the .xls baggage file, convert the .xls to the newer .xlsx format, add the .xlsx as a baggage file, rename the hyperlinks to .xlsx (in HTML view), generate new output
  • same as above but re-creating the hyperlinks (rather than just renaming)

When I preview the topic, the hyperlink is active but does not open the spreadsheet (topic cannot be found).  In the generated output, the hyperlink is not even a hyperlink (just plain old text).

Another unusual behavior (I have no idea if this is related) -- before I tried to fix this, when the original spreadsheet (.xls) opened in "compatibility mode," it was not maximized in Excel's window.  When I used to open this in Office 2003, it was always maximized.

Does anyone know if the #cell_name suffix works in Office 2007?  Is there another way to link to a specific cell?

    This topic has been closed for replies.

    1 reply

    Peter Grainge
    Community Expert
    Community Expert
    May 10, 2010

    I tried to contact Sheela who shared the method but it looks like she has moved on. Sorry.


    See www.grainge.org for RoboHelp and Authoring tips

    @petergrainge

    Use the menu (bottom right) to mark the Best Answer or Highlight particularly useful replies. Found the answer elsewhere? Share it here.
    May 10, 2010

    Thanks for trying