Menu dan Ikon Microsoft Excel 2007 Pada saat Anda memulai Excel 2007, akan muncul sebuah dokumen kosong. Mulai dari sini,Anda dapat menambahkan data, menguba Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. Catatan: Di Microsoft Office Outlook 2007 dan Microsoft Office Publisher 2007, peringatan keamanan muncul dalam kotak dialog, bukan di Bilah Pesan. Secara default, Office Outlook 2007 mengizinkan semua add-in yang diinstal untuk berjalan. Lakukan hal berikut dalam program Sistem Microsoft Office 2007 ini: Word, Excel, Access, dan PowerPoint.
Description of the AutoRecover functions in Excel. 7/25/2019. 7 menit untuk membaca.
![Free Free](/uploads/1/2/5/4/125484204/848378614.png)
Berlaku untuk: Excel 2010, Microsoft Office Excel 2007, Microsoft Office Excel 2003Dalam artikel ini SummaryMicrosoft Excel now has a built-in AutoRecover feature that has replaced the AutoSave add-in that exists in versions of Excel that are earlier than Microsoft Excel 2002. The AutoRecover feature saves copies of all open Excel files at a user-definable fixed interval. The files can be recovered if Excel closes unexpectedly, for example, during a power failure.This article contains an overview of the AutoRecover feature. NoteIn Excel 2007, the minutes box is in the Save category in the Excel Option dialog box. In Excel 2010, the minutes box is in the Save category under File, Options.When the first save interval passes, Excel checks to see whether any open files have been changed. If Excel locates changed files, an idle timer starts. The purpose of the idle timer is to make sure that the user does not make entries in the worksheet while the save operation occurs.
The idle timer restarts each time that the user makes an entry into the worksheet so the AutoRecover save file is not created until both the save interval passes and no entries are made for the duration of the idle time.The default idle time is 30 seconds. To change the default idle time, use the AutoRecoverDelay registry key. To do this, follow these steps.Important This section, method, or task contains steps that tell you how to modify the registry.
However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully.
For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. NoteOnly manually performed actions in the program affect the idle timer. Formulas that automatically update the file do not affect the idle timer. Excel saves the file when the idle time is reached, between the automatic updates to the formulas. File formats that are saved by AutoRecoverAutoRecover saves all file formats that can be opened in Excel. To maintain speed and simplicity, AutoRecover saves all files as the current Excel file format, regardless of the original file format opened.
The file is saved as a hidden file with an arbitrary filename with the extension.xar (for example, ar18a.xar).When you try to save a recovered file upon reopening Excel after it closed unexpectedly, the original file format and name is suggested as the Save file type. Excel stores the original file name and its related.xar file name in the registry for the purpose of recovery. AutoRecover and multiple instances of ExcelWhen more than one instance of Excel is running and one instance closes unexpectedly, a new instance of Excel is automatically started and the AutoRecover files are opened. If all instances of Excel close unexpectedly, but the computer is still running, a single instance of Excel is started and all AutoRecover files are opened. In the case of a power outage, all recovered files are opened when you start Excel again. CompatibilityAll AutoRecover settings, except the Disable AutoRecover workbook option, are stored in the system registry. AutoRecover settings are compatible with files from previous versions of Excel is not an issue.When the Disable AutoRecover workbook option is set, and the file is opened in an earlier version of Excel, saved, and then reopened in a later version of Excel, the Disable AutoRecover workbook option is not affected.
ReferencesFor more information about how to troubleshoot errors when you save Excel files, click the following article number to view the article in the Microsoft Knowledge Base:How to troubleshoot errors when you save Excel files.
Before printing a spreadsheet or pivot table, we are used to previewing and adjusting it for better readability. Many users who are accustomed to Microsoft Excel 2003/XP(2002)/2000 may feel it hard to find out the Page Setup function in the Ribbon.Now let us see where the Page Setup is in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365.If you have not installedMethod A:. Click the Page Layout tab in the Ribbon. Go to the Page Setup group, and then you will find that some common used setups, such as margins, backgrounds and size are listed in this group. For further setup, you should click the little square with an arrow in the right bottom of the group. (Which I have emphasized in the Figure 1).
Then a “ Page Setup” box appears, and you can choose the settings based on your need. Click OK to finish it.Figure 1Method B:Click the ' File' tab, choose Print, and then you will see a setting form in the right. Thus, you can configure many settings before printing.Figure 2If you have installedNo more hesitation and thinking. With Classic Menu, you can easily find out where Page Setup is. Click the Menus tab next to the Home tab, the familiar toolbars and menus show up, and then click File item, the Page Setup option stays in the same place you know in Microsoft Excel 2003.Figure 3Classic Menu for OfficeBrings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.Screen Shot of Classic Menu for Excel.