
1,123 questions with Microsoft 365 and Office | Excel | For education | Windows tags
From last 15 days words or excel final file i want to work is showing corrupt and need to repair. why this happen
Any word or excel file I am opening for work, showing that 'word/excel has run into a error that is preventing it from working correctly. word/excel is need to be close as a result.' request you to resolve the same since i am facing very difficulty in…
Microsoft 365 and Office | Excel | For education | Windows

my excel is not working it says repair now
Microsoft 365 and Office | Excel | For education | Windows

Macro Runtime error 1004 "autofill" issue
So, i have a macro on a certificate generator, it adds rows to the "as found" table, as seen in the attached picture the "testpoint","set point" and "deviation" columns have formulas for the data. Below is the…
Microsoft 365 and Office | Excel | For education | Windows

Finding an item and times used and subtracting it from a quantity.
As I add units and their quantities to the columns on the right(ex Columns H and I) I want to subtract the quantity of matching units from the quantity in column A. With the result(my available) showing in the B column. Basically how many say Pierce…
Microsoft 365 and Office | Excel | For education | Windows

I am getting a notification that something went wrong and I need to troubleshoot.
i got this notifaction: Correlation Id: 0857882c-2d58-4acc-9124-d005f4f6c20e Timestamp: 2025-08-24T20:55:46.000Z DPTI: 2d0e6e27f30209971c667e6873a9976626bbdd397ca93cd900a5fe935ccd56c4 Message: The credential is invalid. Unexpected sub status (6008). Tag:…
Microsoft 365 and Office | Excel | For education | Windows

How do I add a link in an Excel cell AND have other text in same cell?
I would like to be able to add a link in the top line of a cell and have related text below the link that is not associated to the link. Ie when you click in the cell, it does not automatically access the link. Is this possible?
Microsoft 365 and Office | Excel | For education | Windows

Unable to Access Copilot in Excel
Experiencing issues accessing Copilot in Excel while using a university subscription that is currently active. Is there a way to resolve this access problem?
Microsoft 365 and Office | Excel | For education | Windows

Excel Only Opening in a Safe Mode
I cannot open excel except in safe mode. I have tried doing an online repair which did not remedy the issue. Then I tried removing the office 365 apps and reinstalling--still no luck. I believe the issue is in one of my add-ins "ChemDraw". I've…
Microsoft 365 and Office | Excel | For education | Windows

how to unblock macros from running
A professor sent me a spreadsheet to download with macros. Excel blocked macros because it came from an untrusted source. How do I unblock macros? I have already tried using the Trust Center and File Explorer.
Microsoft 365 and Office | Excel | For education | Windows

how to open a shared excel file in the app
I have a shared linked to an excel file but it only open to the browser I need it in the excel app and also be able to work together with my team on the sheet. I have tried everything but I either dont have access to it because of my school or its just…
Microsoft 365 and Office | Excel | For education | Windows

DATEVALUE and VALUE function is not working
DATEVALUE and VALUE function is not working in string formatted as "03.03.2025". Neither it is being convert to other date format too. What could be the cause? And how to fix this?
Microsoft 365 and Office | Excel | For education | Windows


The link for Excel Associate Exam schedule is not working
When I try to schedule an exam for Exam Associate on the Microsoft Learn site, the link to schedule does not work. Here are a couple screenshots:
Microsoft 365 and Office | Excel | For education | Windows

13-digit number in Excel
I need a to format my Excel spreadsheet to display my 13-digit number as follow: 000000 0000 000 The spaces in between. Even if the number is seen as text. No calculations are needed. It is South Africa's Identity Number format.
Microsoft 365 and Office | Excel | For education | Windows


Excel Returns the average salary of employees who:
You have the following dataset in Excel (columns A to D): ABCDNameDepartmentJoin DateSalaryNameDepartmentJoin DateSalaryAliceHR01/03/202038000BobIT15/06/202142000CarolFinance10/01/201947000DavidHR22/07/202236000EmmaIT04/09/202039000............--- How do…
Microsoft 365 and Office | Excel | For education | Windows


Why do some sheets have a fuzzy/blurry view and erratic cell selection until a slight scroll is done?
Craziest thing. I have never seen this happen before, and I'm not sure what is causing it. I copied some sheets from another workbook that was emailed to me from a colleague. I have run the Document Inspector and cleaned some things out but it still…
Microsoft 365 and Office | Excel | For education | Windows

MS Excel dynamic array formula
What formula can sum up all the budget amounts between months that I specify for the Expense by Group (Column A) - in top image? I tried the above but got the dreaded value error message
Microsoft 365 and Office | Excel | For education | Windows

How can I replace a macro in a workbook?
I create a workbook to be updated for an external user each month, keeping the month and accumulating for the next month; after I deliver the template, I don't control it anymore; I just receive the information every month to analyze. The macro block…
Microsoft 365 and Office | Excel | For education | Windows

Which Excel certification is most recommended for someone applying for virtual assistant jobs?Should I take the Associate exam first and then the Expert exam later?
Hello Microsoft Team, I am planning to apply for virtual assistant jobs, and many clients require strong Microsoft Excel skills. I want to get officially certified by Microsoft to prove my Excel proficiency. I am not sure whether to take the Excel…
Microsoft 365 and Office | Excel | For education | Windows

Convert Monthly values in to weekly and opposite.
Hi, could you please help me with the formulas? I have some employees who are paid weekly and others who are on fixed monthly salaries. How can I convert weekly salaries into equivalent monthly costs (calendar months)? And how can I convert fixed…
Microsoft 365 and Office | Excel | For education | Windows

How to configure office 365 to integrate Excel to solidworks?
Can I downgrade the Excel to integrate ir to solidworks, once the office 365 does not integrate automaticaly anymore , and we are obligated to accept all the latest updates? I need to TOTALLY CLEAN any blind portion of the Office to downgrade it to the…
Microsoft 365 and Office | Excel | For education | Windows
