Microsoft Office Tutorials and References
In Depth Information
Opening Files—with a Twist
Why settle for the
command when you
have all these other
Here’s what these different choices do:
• Open opens the file in the normal way.
• Open Read-Only opens the file, but won’t let you save changes. This option is
great if you want to make sure you don’t accidentally overwrite an existing file.
(For example, if you’re using last month’s sales invoice as a starting point for this
month’s sales invoice, you might use Open Read-Only to make sure you can’t
accidentally wipe out the existing file.) If you open a document in read-only
mode, you can still make changes—you just have to save the file with a new file
name (choose File ➝ Save As).
• Open as Copy creates a copy of the spreadsheet file in the same folder. If your
file is named Book1.xlsx, the copy will be named “Copy of Book1.xlsx”. This
feature comes in handy if you’re about to start editing a spreadsheet and want to
be able to look at the last version you saved. Excel won’t let you open the same
file twice. However, you can load the previous version by selecting the same file
and using “Open as Copy”. (Of course, this technique only works when you have
changes you haven’t saved yet. Once you save the current version of a file, the
older version is overwritten and lost forever.)