1,624 questions with Microsoft 365 and Office | Excel | For business | MacOS tags
persistent "Sign-in Required" loop
Im running Office 365 (Version 16.9x) on macOS Sequoia. After our recent mandatory password rotation, several users are stuck in a "Sign-in Required" loop. Even after entering credentials and seeing the "Success" message, the yellow…
Microsoft 365 and Office | Excel | For business | MacOS
Excel 365 freezes all other apps work
my 365 apps work except Excel it freezes up immediately - how do i talk to support or quick answer?
Microsoft 365 and Office | Excel | For business | MacOS
How do I turn on spell check on Excel on a MacBook?
How do I turn on the Spell checker for excel on a MacBook?
Microsoft 365 and Office | Excel | For business | MacOS
Excel formula for COUNTIFS and Date is + or - 1 day
Please help with the following excel formula. Need to compare column A to G which is a date column. Date may be off + or - 1 day then highlight the cell if column E and L match. I made this formula for the conditional formatting, but it didn't get…
Microsoft 365 and Office | Excel | For business | MacOS
Office apps on macOS stuck on “Updating…” and won’t launch after AutoUpdate
I’m using Microsoft Office on macOS, and after a recent Microsoft AutoUpdate run, Word, Excel, and PowerPoint no longer open properly. When I launch any Office app, it either gets stuck on “Updating…” or closes immediately without showing an error.…
Microsoft 365 and Office | Excel | For business | MacOS
Restoring Lost Sheets from a File When Saved Locally in Mac
Hello, I use excel for my business records, and yesterday the app wanted to update but i saved my progress before i clicked to update. once the update was done the progress I had made was reset to what i had months ago. progress was deleted and I dont…
Microsoft 365 and Office | Excel | For business | MacOS
Sending a large Excel for Mac file with all the images still embedded
Hello, I am using Excel for Mac, and I followed the "Insert Picture" process like this - Select a cell, Go to "Insert" in the top row menus next to the Apple symbol, Scroll down to "Picture >" , Then "Place in…
Microsoft 365 and Office | Excel | For business | MacOS
Unable to use Word and Excel
Why can't I log into Excel and Word? The error message says 'cannot connect to server' but I can use PowerPoint and Outlook?
Microsoft 365 and Office | Excel | For business | MacOS
Why am I all of a sudden unable to save Excel documents ?
I don't understand why all of a sudden I cannot save my Excel documents. The save option is greyed out. I wondered whether my 365 license had expired, but I can still save my Word documents under the same license. When I click About Excel, my license is…
Microsoft 365 and Office | Excel | For business | MacOS
MAXIFS works but not MINIFS on the same column of data in separate tables
Hoping someone can help with this issue: The MAXIFS formula works as below, where O3 is a value from a dropdown in the cell. Dropdown values can be either 'Project1' or 'Project2". =MAX(MAXIFS(Project1[Transaction / Accounting…
Microsoft 365 and Office | Excel | For business | MacOS
Why can't I copy from excel online anymore?
Up until late last week, I could copy from excel online to any other platform. Recently, my clipboard no longer copies from excel online. This is the only online microsoft office product that I have this problem with. I also can still copy from excel for…
Microsoft 365 and Office | Excel | For business | MacOS
I cannot open files on my Mac and the subscription is up to date
The file is not opening. Since when do only some excel files open and others will not?
Microsoft 365 and Office | Excel | For business | MacOS
3 versions of an excel spreadsheet. The wrong one was saved. Can I access the previous version?
I just went to open an important excel spreadsheet. I received a prompt that there were three versions saved and I needed to choose which one to save. I chose the one that appeared to be updated most recently. Unfortunately, it was a very old…
Microsoft 365 and Office | Excel | For business | MacOS
Is it possible to automatically sync Excel Tables to PowerPoint on macOS
We have a user using a Mac device who wants an Excel table that they update to automatically update in their PowerPoint deck. Is this possible on a Mac? If not, what are the options to achieve this? It’s redundant to update both files manually since…
Microsoft 365 and Office | Excel | For business | MacOS
How to use Excel formulas to dynamically calculate values based on changing criteria?
How can I use Excel formulas (such as IF, SUMIFS, COUNTIFS, XLOOKUP, or dynamic arrays) to automatically recalculate results when criteria or source data changes, without relying on VBA?
Microsoft 365 and Office | Excel | For business | MacOS
Can't stop excel from opening hundreds of windows for pdfs and spreadsheets
After restarting my laptop, I clicked to open excel. Immediately hundreds of windows started opening with questions of if I wanted to still open the file or telling me it's unsafe. I've tried: ~ the command and comma key trick but I can't get…
Microsoft 365 and Office | Excel | For business | MacOS
How to track and audit changes made by multiple users in a shared Excel workbook?
How can I identify who changed specific cells, when the changes occurred, and what the previous values were in a shared Excel file, especially when co-authoring through OneDrive or SharePoint? And can we do it in offline version ?
Microsoft 365 and Office | Excel | For business | MacOS
I cannot open two windows of one excel document at the same time
Hi, I am using Excel on my macOS laptop but unfortunately when I want to open an excel document in two windows, so I can work on both, the excel suddenly freezes and starts loading. I have tried it multiple time and even waited 10 minutes but…
Microsoft 365 and Office | Excel | For business | MacOS
I keep getting this error although I'm subscribed
Microsoft 365 and Office | Excel | For business | MacOS
INDEX vs MATCH??
Dearest Wizards, Sheet 1: A11-60 has the names of the states B5-E5 has the values; Tom, Mary, Harry, Jane B11-E60 has the amount of money each person spent while visiting the associated state Sheet 2: A11# is a VSTACK (by the 4 individuals)/FILTERED (to…