1,123 questions with Microsoft 365 and Office | Excel | For education | Windows tags

Sort by: Updated
1 answer

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
asked 2025-08-25T07:45:51.9566667+00:00
Prakash Pandey 0 Reputation points
commented 2025-08-29T08:04:40.27+00:00
Demi-N 2,485 Reputation points Microsoft External Staff Moderator
1 answer

my excel is not working it says repair now

Microsoft 365 and Office | Excel | For education | Windows
asked 2025-08-29T03:46:28.3866667+00:00
hanuman perla 0 Reputation points
answered 2025-08-29T04:10:35.2466667+00:00
Darren-Ng 1,425 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-18T11:59:38.8366667+00:00
Jake Guy 0 Reputation points
commented 2025-08-28T08:24:44.8266667+00:00
Rin-L 3,045 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-08-25T03:16:06.56+00:00
Nate G 0 Reputation points
commented 2025-08-27T23:35:09.7466667+00:00
Huy-K 2,790 Reputation points Microsoft External Staff Moderator
3 answers

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
asked 2025-08-24T20:59:14.8833333+00:00
Mulvey, Ruth Ann 0 Reputation points
answered 2025-08-27T20:56:22.36+00:00
Hendrix-C 2,050 Reputation points Microsoft External Staff Moderator
3 answers

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
asked 2025-08-20T22:00:31.1833333+00:00
ShawnnaBee 0 Reputation points
commented 2025-08-27T19:47:29.8866667+00:00
Jay Tr 1,295 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-24T05:40:37.2466667+00:00
Akbany, Adnan 0 Reputation points
commented 2025-08-27T00:31:53.8566667+00:00
Huy-K 2,790 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-07-23T21:24:52.14+00:00
Moira Lauer 0 Reputation points
answered 2025-08-25T13:24:22.51+00:00
William Thomas 0 Reputation points
1 answer

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
asked 2025-08-17T06:21:14.9333333+00:00
Masamery,Kira Gabriela 0 Reputation points
commented 2025-08-20T06:18:36.1233333+00:00
Vivian-HT 3,055 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-09T07:09:44.4566667+00:00
Zulfiqar Muradi 0 Reputation points
edited a comment 2025-08-14T13:38:45.16+00:00
Henry-N 1,675 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2025-08-12T01:30:30.1533333+00:00
Dheeraj Singh 20 Reputation points
answered 2025-08-12T23:10:44.6633333+00:00
Ashish Mathur 99,595 Reputation points Volunteer Moderator
2 answers

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
asked 2025-08-07T18:22:40.36+00:00
georgia copenhaver 0 Reputation points
commented 2025-08-12T15:14:33.96+00:00
Vy Nguyen 3,165 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2025-08-10T08:23:47.4166667+00:00
Rayman Blackz 20 Reputation points
answered 2025-08-10T23:20:27.9766667+00:00
Ashish Mathur 99,595 Reputation points Volunteer Moderator
4 answers One of the answers was accepted by the question author.

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
asked 2025-07-27T16:24:24.3533333+00:00
Michael Hilland 20 Reputation points
answered 2025-08-09T23:35:02.88+00:00
Ashish Mathur 99,595 Reputation points Volunteer Moderator
3 answers One of the answers was accepted by the question author.

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
asked 2025-08-02T02:00:21.48+00:00
Craig Gerdes 40 Reputation points
commented 2025-08-07T10:18:28.18+00:00
Craig Gerdes 40 Reputation points
3 answers

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
asked 2025-08-05T12:51:59.52+00:00
CUTAJAR,Phillip 0 Reputation points
answered 2025-08-07T00:22:30.9966667+00:00
CUTAJAR,Phillip 0 Reputation points
1 answer

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
asked 2025-08-03T20:43:08.85+00:00
Lu Ca 0 Reputation points
commented 2025-08-06T19:53:30.84+00:00
Jay Tr 1,295 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-07-29T02:06:30.76+00:00
mayra lozada 0 Reputation points
edited a comment 2025-08-03T23:32:08.39+00:00
Jeanie H 2,645 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2025-07-31T16:22:37.47+00:00
D Bruvere 20 Reputation points
commented 2025-08-01T15:26:33.4966667+00:00
D Bruvere 20 Reputation points
1 answer

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
asked 2025-07-25T00:16:56.55+00:00
Altibano Ortenzi Junior 0 Reputation points
commented 2025-07-31T04:14:33.8566667+00:00
Darren-Ng 1,425 Reputation points Microsoft External Staff Moderator