1.4. Saving FilesAs everyone who's been alive for at least three days knows , you should save your work early and often. Excel is no exception. You have two choices for saving a spreadsheet file:
Tip: Resaving a spreadsheet is an almost instantaneous operation, and you should get used to doing it all the time. After you've made any significant change, just hit Ctrl+S to make sure you've stored the latest version of your data. 1.4.1. The Excel 2007 File FormatSince time immemorial, Excel fans have been saving their lovingly crafted spreadsheets in .xls files (as in AirlineSilverware.xls). Excel 2007 changes all that. In fact, it introduces a completely new file format, with the extension . xlsx (as in Airline-Silverware.xlsx). At first glance, this seems a tad over the top. But the new file format has some real advantages:
For all these reasons, .xlsx is the format of choice for Excel 2007. However, Microsoft prefers to give people all the choices they could ever need (rather than make life really simple), and Excel file formats are no exception. Along with the standard .xlsx, there's the closely related .xls m cousin, which adds the ability to store macro code. If you've added any macros to your spreadsheet, Excel prompts you to use this file type when you save your spreadsheet. 1.4.2. Saving Your Spreadsheet in Older FormatsMost of the time, you don't need to think about Excel's file formatyou can just create your spreadsheets, save them, and let Excel take care of the rest. The only time you need to stop and think twice is when you need to share your work with other, less fortunate people who have older versions of Excel. When you find yourself in this situation, you have two choices:
Often, the best thing you can do is keep your spreadsheet in the newer format and save a copy in the older format (using Office button Save As Excel 97-2003 Format). You can then hand that copy out to your backward friends . Some eccentric individuals have even older or stranger spreadsheet software on their computers. If you want to save a copy of your spreadsheet in a more exotic file type, you can choose Office button Save As, and then find the desired format in the "Save as type drop-down list (Figure 1-16). Excel lets you save your spreadsheet using a variety of different formats, including the classic Excel 95 format from a decade ago. If you're looking to view your spreadsheet using a mystery program, use the CSV file type, which produces a comma-delimited text file that almost all spreadsheet applications on any operating system can read (comma-delimited means the information has commas separating each cell ).
Tip: When you save your Excel spreadsheet in another format, make sure you keep a copy in the standard .xlsx format. Why bother? Because other formats aren't guaranteed to retain all your information, particularly if you choose a format that doesn't support some of Excel's newer features. 1.4.3. Saving Your Spreadsheet As a PDFSometimes you want to save a copy of your spreadsheet so that people can read it even if they don't have Excel (and even if they're running a different operating system, like Linux or Apple's OS X). In this situation, you have several choices:
To get the Save As PDF add-in, surf to www.microsoft.com/downloads and search for "PDF." The links lead you to a page where you can download the add-in and install it with just a couple of clicks. Once you install the Save As PDF add-in, all your Office applications have the ability to save their documents in PDF format. In Excel, you work this magic by choosing Office button Save As PDF, which brings up the "Publish as PDF dialog box (Figure 1-17). When you save a PDF file, you get a few extra options in the Save As dialog box. PDF files can be saved with different resolution and quality settings (which mostly affect any graphical objects that you've placed in your workbook, like pictures and charts ).
Normally, you use higher quality settings if you're planning to print your PDF file, because printers use higher resolutions than computer monitors . The "Publish as PDF" dialog box gives you some control over the quality settings with the "Optimize for" options. If you're just saving a PDF copy so other people can view the information in your workbook, choose "Minimum size (publishing online)" to save some space. On the other hand, if there's a possibility that the people reading your PDF might want to print it out, choose "Standard (publishing online and printing)" to save a slightly larger PDF that makes for a better printout. Finally, if you want to publish only a portion of your spreadsheet as a PDF file, click the Options button to open a dialog box with even more settings. You can choose to publish just a fixed number of pages, just the selected cells , and so on. These options mirror the choices you get when sending a spreadsheet to the printer. You also see a few more cryptic options, most of which you can safely ignore. (They're intended for PDF nerds.) One exception is the "Document properties" optionturn this off if you don't want the PDF to keep track of certain information that identifies you, like your name. Tip: Getting the Save As PDF add-in is a bit of a hassle, but it's well worth the effort. In previous versions of Excel, people who wanted to create PDFs file had to get another add-in or buy the expensive full version of the Adobe Acrobat software. The Save As PDF feature was originally slated for inclusion in Excel (with no add-in required), but anti-trust concerns caused ultra -cautious Microsoft to leave it out. 1.4.4. Disaster RecoveryThe corollary to the edict "Save your data early and often" is the truism "Sometimes things fall apart quickly before you've even had a chance to back up." Fortunately, Excel includes an invaluable safety net called AutoRecover. AutoRecover periodically saves backup copies of your spreadsheet while you work. If you suffer a system crash, you can retrieve the last AutoRecover backup even if you never managed to save the file yourself. Of course, even the AutoRecover backup won't necessarily have all the information you entered in your spreadsheet before the problem occurred. But if AutoRecover saves a backup every 10 minutes (the standard), at most you'll lose 10 minutes of work. AutoRecover comes switched on when you install Excel, but you can tweak its settings. Select Office Excel Options, and then choose the Save section. Under the "Save workbooks section, make sure that "Save AutoRecover information" is turned on. You can also make a few other changes to AutoRecover settings:
If your computer does crash, when you get it running again, you can easily retrieve your last AutoRecover backup. In fact, the next time you launch Excel, it automatically checks the backup folder, and, if it finds a backup, it opens a Document Recovery panel on the left of the Excel window. If your computer crashes in mid-edit, the next time you open Excel you'll probably see the same file listed twice in the Document Recovery window, as shown in Figure 1-19. The difference is the status. The status [AutoSaved] indicates the most recent backup created by Excel. The status [Original] indicates the last version of the file that you saved (which is safely stored on your hard drive, right where you expect it).
To open a file that's in the Document Recovery window, just click it. You can also use a drop-down menu with additional options (Figure 1-19). Make sure you save the file before you leave Excel. After all, it's just a temporary backup. If you attempt to open a backup file that's somehow been scrambled (technically known as corrupted ), Excel automatically attempts to repair it. You can choose Show Repairs to display a list of any changes Excel had to make to recover the file. |