Show workbook edit link of Excel 2007
December 10th, 2008 | Posted by in Spreadsheet tips
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]](http://img.zemanta.com/reblog_e.png?x-id=c5c6beae-ad15-4f81-8f9a-b70441ec1384)
You can follow any responses to this entry through the RSS 2.0 Both comments and pings are currently closed.
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