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.
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.
- 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.
- 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.)
No comments:
Post a Comment