Sunday, December 25, 2011

Now where on the network did I save my workbook?

I ask myself that question a lot, especially since I typically save my workbooks to SharePoint team sites on our corporate servers. If you, too, save and share files on your network, you can make your life easier by adding the Document Location box to the Quick Access Toolbar.  

Document Location box on Quick Access Toolbar

The Document Location box shows you exactly where your file is saved. If you need your coworkers to review or edit your workbook, just paste the link from this box into an email message and send it to them. Trust me—sending a link is way better than sending a file attachment!

Here's how to add this box to the ribbon:

Click the arrow next to the Quick Access Toolbar, and then click More Commands

Arrow that opens shortcut menu

In the Excel Options dialog box, in the Choose commands from box, click Commands Not in the Ribbon.
Scroll down to the Document Location command and double-click it to add it to the Quick Access Toolbar.

Document Location command in Excel Options dialog box

Click OK. At this point, you should see the Document Location box on your Quick Access Toolbar. (If you ever want to get rid of it, right-click the border of the box, and then click Remove from Quick Access Toolbar.)

This procedure applies to Excel 2010, but it works pretty much the same way in Excel 2007. To quickly open the Excel Options dialog box in Excel 2010 or earlier, press ALT, and then press T, O.

-- Anneliese Wirth

View the original article here

No comments: