432 questions with Microsoft 365 and Office | Excel | For education | MacOS tags
VLOOKUP formula is not working on a spreadsheet that used to work previously
The VLOOKUP formula isn't working the way it did before, even though the cell formats are the same. Getting #N/A on the result. This started happening recently on my macos Sequoia 15.7.2. This is the formula in question =VLOOKUP($A2,Sheet2!$A:$Z,4,0)
Microsoft 365 and Office | Excel | For education | MacOS
On my Excel, I cannot click the main max or value button on my solver. I use MacBook Air.
So I had an assignment to use solver I did everything exactly as it is my friend has a MacBook Air, which is running on old OS and it works perfectly. I have my new MacBook Air in which I cannot click any buttons. It is very frustrating. My exams are…
Microsoft 365 and Office | Excel | For education | MacOS
Excel taking too long on basic tasks and using 99,9% of CPU
Hello, I have a macbook air M3 with 8GB RAM. Lately, my excel has been taking way too long (like 10/15 seconds) doing some pretty basic tasks, like opening 'more number formats', 'more borders', 'custom format', and other stuff like that. It is happening…
Microsoft 365 and Office | Excel | For education | MacOS
MOS 200 Excel Associate Certification Exam 2019
Hello, when taking the at home proctored MOS 200 Excel Associate Certification Exam 2019, do you take it on the Windows Excel version only? Or is there a MacOS version as well? I currently use the MacOS Excel. Is this question able to be answered here or…
Microsoft 365 and Office | Excel | For education | MacOS
Excel Issse
Same question but doing online gives incorrect answer.
Microsoft 365 and Office | Excel | For education | MacOS
Urgent assistance required for IRR rates in excel
Hi Everyone! I have computed the following cashflows in excel: The pre-tax rate is correct. But the post-tax according to the answer key should be 5.06%. This is not the only question where I got the pre-tax IRR right but post-tax incorrect, hence I…
Microsoft 365 and Office | Excel | For education | MacOS
Excel Add-in Real Statistics Resource Pack not working on Mac Book Pro macOS Sequoia 15.6.1
Hello all, for my Six Sigma Green Belt training I have discovered today that the Real Statistics Resource Pack Add-in which I have downloaded from https://real-statistics.com/free-download/real-statistics-resource-pack/ is not working on my Mac Book Pro…
Microsoft 365 and Office | Excel | For education | MacOS
Data validation list values on excel worksheet for Mac OS not updating automatically
In an Excel worksheet for expense accounting, I have cells and columns with lookup lists that are located on another sheet within the same file. I have set this up using the "Data Validation - Lists" command, for example as in the following…
Microsoft 365 and Office | Excel | For education | MacOS
How to retrieve progress of weeks on Excel doc that has suddenly disappeared
Hi, I have been working on an Excel document for weeks, making sure to save from time to time. Last night my Mac asked me to force quit Excel so I did. I vaguely remember even saving the doc before closing. Today I opened the file again but it appeared…
Microsoft 365 and Office | Excel | For education | MacOS
my file is not letting me access
Microsoft Excel: it says my workbook is not available. It says: This workbook is either deleted or not currently accessible. I would not have deleted this. Please assist
Microsoft 365 and Office | Excel | For education | MacOS
restore a deleted file
I had an excel file with all of my important due dates and assignments. It was saved and I would always open it. It has been deleted without my consent. How to I recover this workbook?
Microsoft 365 and Office | Excel | For education | MacOS
problem when switching "bold" on and off
Hey, I'm using excel on Mac, and recently I've started to experience issues when switching "bold" on and off. For instance, when switching to bold while writing in any language that isn't english - the first letter would be english and…
Microsoft 365 and Office | Excel | For education | MacOS
How to fix Excel solver function buttons
There are no checkbox's to adjust for Max , min values , make unconstrained Variables Non-negative Mac OS - version Tahoe 26.0.1 Excel version - 16.102.1
Microsoft 365 and Office | Excel | For education | MacOS
I got charged $99.99 but I clicked free trial. How can I get a refund?
I selected a plan because it said there I could do a free trial yesterday but today when I checked my card, it was billed for $99.99. How can I get a refund?
Microsoft 365 and Office | Excel | For education | MacOS
Excel Won't Save As a PDF MacOS 15.7.1
Hi, I save my excel sheet as a PDF which allows the links in the spreadsheet to be clickable. Today I got this "Something went wrong and your file can't be saved now. Try again with the "Best for Printing" option." The problem with…
Microsoft 365 and Office | Excel | For education | MacOS
Visible Plus Sign in Cells
Hello - I am a Kindergarten teacher and am making a data page for each of my students to track their growth. I would like to have a visible + or - in a cell for parents to see if their child's score went up or down on a given assessment. How do I do…
Microsoft 365 and Office | Excel | For education | MacOS
How to transfer my Microsoft Office Specialist: Excel Associate (Office 2019) badge from Credly to my Microsoft account?
I passed the Microsoft Office Specialist: Excel Associate (Office 2019) exam with my college, and my badge was issued through Credly. I was wondering how I would transfer this badge from Credly to my Microsoft Learn account.
Microsoft 365 and Office | Excel | For education | MacOS
I accidentally unsaved an excel file when closing it is there any way to recover the original data I had in the file.
When I went to close my excel file I accidentally pressed "don't save", I was wondering if there was any way I could get the file with all the unsaved data I had in it before. If there was any recovery method to be able to get my old unsaved…
Microsoft 365 and Office | Excel | For education | MacOS
Pre made budget template sheet
Good day, I have found a few posts about this specific sheet already but nothing to fully answer my question, when using this premade template from excel for budgeting, the pie chart simply does not pull new data when the sheet is copied. It always pulls…
Microsoft 365 and Office | Excel | For education | MacOS
How to get quick analysis button on excel for mac
I was wondering if I could use the quick analysis button on mac because i cant seem to find it anywhere.
Microsoft 365 and Office | Excel | For education | MacOS