Show workbook edit link of Excel 2007

Do you know that Excel 2007 placed functions/tools in a new tab? Pulldown menu has replaced by the Ribbon. In Excel 2003 and before, pulldown menu provide EDIT tab. This tab consists of various commands related to file editing, such as edit link. Choose this command will release the wizard.

The edit link wizard provides command to update value, change source, break link as well as check link.  This wizard also equipped with the link list. You really need to know this feature if you have to maintain several excel files in a time.

Excel 2007 put the edit link command in Connection group of Data tab. Just move the Ribbon to Data tab, you’ll find connection group right to get external data group. By the way, shortcut of Excel 2003 still works! The Edit link wizard popups as we press ALT, E + K  at the linking workbook.

Reblog this post [with Zemanta]
  • i don’t have Ms. Office 2007 just simple Open Office on my computer..

  • I am trying to a create a link in excel to a power point. The problem is that the file may be located in 4 different folders. Is there a function that I can use to do this? Or do I need to create some sort of macro?
    .-= Smart Tags in Excel 2007´s last smart idea ..Showing or Hiding a data table or chart legend =-.

  • Very nice tools but i don’t have Ms. Office 2007 just simple Open Office on my computer