Opening/Closing a Workbook(s) in Excel 2007

To add a new workbook:

Press Ctrl+N.

To open a recently saved workbook:

Select File – > Recent Documents section.

To open a linked workbook:

Select the cell with the linked formula, and press Ctrl+[.
1. Select Data -> Edit Links to Files dialog box (in Manage Connections Group)
2. Select the linked workbook and click Open Source.
? To prevent a macro from running while opening a workbook:
Press the Shift key while opening a workbook.

To close a workbook:

Press Ctrl+F4.
Select File -> Close.

Leave a Reply

Your email address will not be published. Required fields are marked *

5 × two =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>