2020-3-17  How do I recalculate in Excel for Mac? Ask Question Asked 5 years. This is driving me a little bit crazy. In my old PC days I used to press either F5 or F9 (I can't remember) to have Excel recalculate. What is the Mac equivalent? PS: Perhaps this is not the place to ask. If so, please redirect me. Where does Microsoft RDP 8 for Mac. 2017-7-9  It would only recalculate after I save and then reopen it. My Excel preferences is set to automatic recalculate. Skip to main content. Excel 2016 for Mac does not recalculate. Why does my formula not calculate in Excel? Instead the text of the formula itself appears in the cell directly. See example below. Microsoft Support. Excel 2016 for Mac Help. Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac More. Looking for something that’s not listed here? Use the Search box in the upper right corner of this window. Office 2016 for Mac Quick Start Guides. Recalculate style. 2017-7-9  Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number.

1. Excel 2011 Won't Open Microsoft Excel Quit Unexpectedly Mac 2019

Your home folder contains many files and folders that apps on your Mac have permission to read or modify. If you use Get Info or other methods to change those permissions, you could experience issues such as these:

The Database Utility is located under Applications – Microsoft Office 2011 – Office – Microsoft Database Utility.app. I had to shut down my computer manually first, then refuse to enter a password for any application that sounded like it might be related to Microsoft so that Outlook would not open in the background and freeze up again and refuse to quit so the database could.

• Changes that you make in System Preferences aren't saved after you quit System Preferences.
• Changes that you make to the Dock aren't saved after you log out of your user account.
• Windows that were open the last time you logged out or quit an app (before you changed permissions) open again after you log in or open the app.
• You're asked for an administrator name and password when moving certain items in the home folder.
• You repeatedly get a message that macOS needs to repair your Library to run applications.
• When saving changes to an item, you get a message that the file is locked or you don't have permission to save.
• Preview, TextEdit, or other sandboxed apps unexpectedly quit when opened.
• You get an alert that the startup disk has no more space available for application memory.
• Activity Monitor shows that Safari or SafariDAVClient is using a large amount of system resources.
• Your Mac performs slowly.
• iTunes says that your device cannot be synced.
• Photos and videos that you import into Photos or iPhoto don't appear within the app, but do appear in Finder. Or your library needs to be updated or reselected each time you open Photos or iPhoto.

Nov 10, 2019 The other common cause of an app not working is a corrupt file used by the app in question. In many cases, the most likely candidate for a corrupt file is the app's preference file, also known as a plist. Plist files can become corrupt when your Mac shuts down or restarts unexpectedly, or an app freezes or crashes. 2020-4-4  Fixing Mac App Store Apps Crashing on Launch in Mac OS X. Quit all open apps that are from the Mac App Store (assuming some opened successfully in the first place) Open the “App Store” application by going to the Apple menu and choosing ‘App Store’. 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.

High Sierra leaves Microsoft Office for Mac 2011 behind, 2016 edition needs updating. By Mike Wuerthele Tuesday, June 13, 2017, 09:21 am PT (12:21 pm ET) A support document published by Microsoft. Feb 21, 2020 Microsoft Word cannot be opened because of a problem. Check with the developer to make sure Microsoft Word works with this version of Mac OS X; As Microsoft Word is widely used among people, owning some basic Word troubleshooting is recognized as an essential skill. Today you're going to learn three tricks in solving Word not opening on Mac. If the problem still occurs, quit Microsoft Word, 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.Word.plist file to the trash. Quit all Microsoft Office for Mac programs. On the Go menu, click Home. Open Library.

Reset permissions

If the issue started after changing the permissions of items in your home folder , use these steps to reset permissions.

1. Turn on or restart your Mac, then immediately press and hold Command (⌘)-R to start up from macOS Recovery.
2. You might be prompted to enter a password, such as a firmware password or the password of a user who is an administrator of this Mac. Enter the requested password to continue.
3. When you see the macOS Utilities window, choose Utilities > Terminal from the menu bar.
4. Type repairHomePermissions in the Terminal window, then press Return. The Repair Home app opens.
5. Select your user account, click Next, then enter your administrator password. Click Next unlock the volume and begin resetting permissions on your home directory.
   
6. When done, click Exit to return to the macOS Utilities window.
7. Select Reinstall macOS, then click Continue and follow the onscreen instructions to reinstall macOS.
   

If the issue persists

If resetting permissions doesn't resolve the issue:

1. Make sure that you have a backup of your Mac, then erase your startup disk.
2. When done, reinstall macOS.
3. After installation completes and your Mac restarts to the setup assistant, create a new user account using a different name than the one you were using before. Any difference in spelling is enough.
4. If you made a Time Machine backup, use Migration Assistant to restore all your files from the backup.

By Mike Wuerthele
Tuesday, June 13, 2017, 09:21 am PT (12:21 pm ET)

A support document published by Microsoft, and some AppleInsider testing, shows that while the newer versions of the office productivity suite will mostly work with High Sierra now, the current version does not —and older versions are getting left behind.


In the support document, published shortly after the reveal of High Sierra, Microsoft declares that while the Office 2016 suite of applications from unreleased version 15.35 and later do work, users will still have to endure problems while waiting for a future update. According to Microsoft, 'not all Office functionality may be available' and stability problems may manifest where 'apps unexpectedly quit.'
Without delving into specific reasons why, Microsoft strongly recommends that users back up existing data before trying the software. The company is requesting that users send feedback if they choose to test High Sierra and Microsoft Office products.
Versions 15.34 —the current version —and earlier are not supported on High Sierra, and users may not be able to launch the apps at all, according to Microsoft. The 15.34 update was released on May 16
Microsoft notes in the same memorandum that Office for Mac 2011 'have not been tested' and 'no formal support for this configuration will be provided.' Office for Mac 2011 will also cease all support from Microsoft on October 10, 2017 and no further updates in any form will be provided after that date.
AppleInsider tested the 15.34 version and found that they appear to launch and run for a period of time, but with notably slower speeds across the board. Furthermore, the apps quit unexpectedly fairly often during use.
The same issues manifested in a Mac with High Sierra that was not migrated to APFS, eliminating that as a primary source of the errors and crashing.
The latest Office for Mac 2011 from April, version 14.7.3, was examined, and was found to be in a worse state following the High Sierra update. Crashing was even more frequent than in the Office for Mac 2016, not even accounting for a number of other user interface oddities spanning the entire suite. A standard troubleshooting step for Microsoft Office applications is to uninstall and reinstall the suite. Neither the 2011 nor the 2016 versions were any better after a complete delete and reinstall.
Both the 2011 and 2016 versions of Office were usable prior to the High Sierra update. AppleInsider

Excel 2011 Won't Open Microsoft Excel Quit Unexpectedly Mac 2019

's testing found the 2016 suite to to be functional for the cautious under 15.34, and 2011 to be not reliable at all under High Sierra.