- Microsoft Excel Mac 2011 Why Does My Page Turn Grey Paint
- Microsoft Excel Mac 2011 Why Does My Page Turn Grey Hair
- Microsoft Excel Mac 2011 Why Does My Page Turn Grey And White
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
2009-10-31 I use Microsoft Word and my page numbers are on grey as if they'd been highlighted and you can't see the number clearly. How do i get rid of the grey behind them? How do you stop page numbers in header being on grey in Microsoft Word, because you can hardly see them.? I use Microsoft Word and my page numbers are on grey as if they'd been. Jul 14, 2017 When working on Microsoft Excel issues, I commonly come across an the issue of Microsoft Excel sheets opening to a blank grey screen. Typically, this occurs when you double-click an Excel in File Explorer, it “opens” but only to a blank grey screen. Probably have sheet protection turned on which will turn off several options. Make sure you are not in Edit mode by hitting Esc (Escape key), as edit mode will gray out a lot of menu options - notably most Edit options (except cut & paste). Excel for Mac crashes and slow performance FIXED Excel does not respond when using 'Save as Picture' WORKAROUND Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the.xlsx file because the format or extension is not valid. Known issues, changed functionality, and blocked or discontinued features.
Summary
Microsoft 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.
More Information
How to configure the AutoRecover settings
Microsoft Office Excel 2007 and Excel 2010
The controls to configure the AutoRecover feature are in the Save settings in Excel Options.
Note To open the Save settings, click the Microsoft Office Button in Excel 2007 or the File menu in Excel 2010, clickExcel Optionsin 2007 or Options in Excel 2010, and then click Save.
To configure the AutoRecover settings, follow these steps:
Under Save Workbooks, click to select the Save AutoRecover info everycheck box to turn on the AutoRecover feature.
In the minutes box, you can type any integer from 1 through 120. This box sets the number of minutes that will occur between saves.
The default is 10 minutes.
In the AutoRecover file location box, you can type the path and the folder name of the location in which you want the AutoRecover files to stay.
The default location is as follows:
drive:Documents and Settings*user_name*Application DataMicrosoftExcel
Notes
If the location that you type is local (on your hard drive) or is on a network drive, and if this location does not exist, you receive the following error message:
Cannot access directory path.
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
100100
If you click to clear the AutoRecover file location box but do not enter a new location, AutoRecover files will continue to be saved to the location that you cleared. This will occur until you type a new location.
The AutoRecover file location box remains empty until you type a new location.
You can turn off the AutoRecover feature in an individual workbook. To do this, click to select the Disable AutoRecover for this workbook only check box under the AutoRecover exceptions for box. Make sure that the workbook name is selected in the AutoRecover exceptions for box.
Microsoft Office Excel 2003 and earlier versions of Excel
The controls to configure the AutoRecover dialog box are on the Save tab of the Options dialog box.
Note To open the Options dialog box, click Options on the Tools menu.
To configure the AutoRecover dialog box, follow these steps:
Under Settings, click to select the Save AutoRecover info everycheck box to turn on the AutoRecover feature.
In the minutes box, you can type any integer from 1 through 120. This box sets the number of minutes that will occur between saves.
The default is 10 minutes.
In the AutoRecover file location box, you can type the path and the folder name of the location in which you want the AutoRecover files to stay.
The default location is as follows:
drive:Documents and Settings*user_name*Application DataMicrosoftExcel
Notes
If the location that you type is local (on your hard drive) and if the location does not exist, you receive the following error message:
Cannot access directory path.
If the location that you type is on a network drive, you will not receive an alert until your first AutoRecover attempt. You receive the following error message:
Microsoft cannot save AutoRecover info to path. Please check the network connection or change the location on the Save tab of the Tools, Options dialog.
If you clear the AutoRecover file location box but do not enter a new location, AutoRecover files will continue to be saved to the location that you cleared. This occurs until you type a new location.
The AutoRecover file location box remains empty until you type a new location.
You can turn off the AutoRecover feature in an individual workbook. To do this, click to select the Disable AutoRecover check box under Workbook options.
When an AutoRecover event is triggered
When an Excel file is open and AutoRecover is turned on, AutoRecover does not save the file until the first change is made to the file, the AutoRecover save time interval passes, and Excel has been idle for some time (the default is 30 seconds). After AutoRecover saves the file, the file is only saved at subsequent save intervals if further changes are made.
When AutoRecover files are deleted
To keep from filling up your AutoRecover location with unneeded files, AutoRecover files are automatically deleted in the following situations:
- When the file is manually saved.
- The file is saved with a new file name using Save As.
- You close the file.
- You quit Excel, whether you choose to save the file or not.
- You turn off AutoRecover for the current workbook.
- You turn off AutoRecover by clearing the Save AutoRecover info every check box.
AutoRecover save timing
The AutoRecover timer checks for changed Excel files at the interval you set in the minutes box on the Save tab in the Options dialog box. The timer starts when you start Excel.
Note
In 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. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
Quit Excel if it is running.
Click Start, click Run, type regedit in the Open box, and then click OK.
Locate and then select one of the following registry keys, as appropriate for the version of Excel that you are running.
For Microsoft Excel 2002:
HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0ExcelOptions
For Excel 2003:
HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelOptions
For Excel 2007:
HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelOptions
For Excel 2010:
HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelOptions
On the Edit menu, click New, and then click DWORD value.
Type the following name for the new value:
AutoRecoverDelay
Press ENTER.
Right-click the AutoRecoverDelay registry key, and then click Modify.
In the Value data box, type a number between 1 and 600. This is the number of seconds before AutoRecover tries to save.
When you are finished, click OK.
Quit Registry Editor.
Note
Only 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 AutoRecover
AutoRecover 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 Excel
When 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.
Compatibility
All 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.
References
For 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:
Microsoft Excel Mac 2011 Why Does My Page Turn Grey Paint
271513 How to troubleshoot errors when you save Excel files
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
One or more toolbars are missing and cannot be added in Microsoft Excel for Mac.
Cause
There are two possible causes of this behavior:
- The oval button in the upper-right corner of the document was clicked. This button 'toggles' the display of toolbars on and off.
- There is an issue with Excel preferences.
Microsoft Excel Mac 2011 Why Does My Page Turn Grey Hair
Resolution
To resolve this issue, use the following methods in order.
Microsoft Excel Mac 2011 Why Does My Page Turn Grey And White
Method 1: Make sure that toolbar display is not turned off
In the upper-right corner of the Excel window, click the oval button.
Note
When this button is clicked, the toolbars are hidden (in any Microsoft Office for Mac application). A second click causes the toolbars to be displayed.
If the toolbars reappear, quit Excel, and then restart Excel to make sure that the appropriate toolbars are displayed.
If Method 1 did not resolve the problem, try Method 2.
Method 2: Remove the Excel preferences
Step 1: Quit all applications
To quit active applications, follow these steps:
- On the Apple menu, click Force Quit.
- Select an application in the 'Force Quit Applications' window.
- Click Force Quit.
- Repeate the previous steps until you quit all active applications.
Warning
When an application is force quit, any unsaved changes to open documents are not saved.
Step 2: Remove the Excel Preferences
To remove the Excel preferences, follow these steps.
Quit all Microsoft Office for Mac applications.
On the Go menu, click Home.
Open Library.
Jan 21, 2019 Microsoft Office for Mac 16.21. Microsoft has released version 16.21 of Office for Mac with added support in Word for macOS 10.14 Mojave’s Continuity Camera feature, enabling you to insert a photo from your iOS device into your document (see “ How to Take Photos and Scan Documents with Continuity Camera in Mojave,” 27 September 2018). Mar 19, 2020 I’m using Word 16.21 on a MacBook Pro running Mojave 10.14.1. Lately, a super annoying glitch/feature has arisen that is driving me nuts, which is that Spelling and Grammar options keep resetting. I switch them off and when I quit and restart the app, they have switched themselves back on. Form microsoft word 16.21 machine. Microsoft Word 2019 VL 16.21.1 macOS. Create, polish, and share beautiful and professional documents. The state-of-the-art authoring and reviewing tools in Word make the creation of polished documents easy. The new Insights pane shows relevant contextual information from the web inside Word.
Note
The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
Open the Preferences folder. Click View, click Arrange by, and then select Name.
Look for a file that is named com.microsoft.Excel.plist.
If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.plist file to the trash.
Quit all Office for Mac applications.
On the Go menu, click Home.
Open Library.
Note
The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
Open the Preferences folder.
Open the Microsoft Folder.
Look for a file that is named com.microsoft.Excel.prefs.plist.
If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and then check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.prefs.plist file to the trash.
Close all Office applications.
On the Go menu, click Home.
Open Library.
Note
The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
Open the Preferences folder.
Open the Microsoft Folder.
Open the Office 2008 or Office 2011 folder.
Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.
If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. If the problem seems to be resolved, you can move the Excel Toolbars (12) file or the Microsoft Excel Toolbars to the trash.
Note
If the problem still occurs after you follow these steps, the problem is not related to these files. If the problem no longer occurs, one of these files was causing the problem. If this is the case, restore the files to their original location one at a time. Test the application after you restore each file. Continue to do this until the problem occurs again. When the problem recurs, you can then assume that it is caused by the last file that you restored. Drag that file to the trash.