1,446 questions with Microsoft 365 and Office | Excel | For business | Other tags

Sort by: Updated
5 answers

How can I correct the #calc error for this formula?

Hi. I am getting the #calc error with this formula. Can you help? Screenshot 2025-09-23 144838.png =LET(f,FILTER(A2:C39371,A2:A39371=F2),c,CHOOSECOLS(f,2),1/LOOKUP(2,1/FILTER(TAKE(f,,-1),c=TAKE(SORT(c,,-1),1))))

Microsoft 365 and Office | Excel | For business | Other
asked 2025-09-23T18:49:38.6566667+00:00
Patricia Stephenson 0 Reputation points
answered 2026-04-13T14:58:40.86+00:00
Dana D 5 Reputation points
2 answers

POWER PIVOT

Fiz o upgrade para a versao Microsoft 365 Business para ter acesso ao Power Pivot para Excel, mas nao estou tendo acesso a instalar o Suplemento do Power Pivot, alguem pode me ajudar?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-04T19:55:03.1533333+00:00
Francisco Matos 0 Reputation points
commented 2026-04-07T20:46:46.9933333+00:00
Ryan-N 12,025 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Help with a DAX query for PowerBI

I am trying to use a DAX query for PowerBI shown in a video and I think DAX has been updated or something since they made the video because it doesn't seem to work. Can you tell me if anything here is incorrect syntax or illogical? EVALUATE VAR…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-07T19:01:19.8033333+00:00
Seymour, Dawn E 20 Reputation points
commented 2026-04-07T19:15:19.88+00:00
Seymour, Dawn E 20 Reputation points
1 answer

Using Stockhistory and Stock functions to pull dividend history / data

I have just recently purchased a license for MS Office, i am trying to use the Stockhistory and Stock functions to extract Dividend data. For whatever reason, I am not able to view these fields and manually typing "Dividend" returns a value…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-07T14:47:26.1966667+00:00
G T 0 Reputation points
edited an answer 2026-04-07T16:44:09.3033333+00:00
Hendrix-C 14,325 Reputation points Microsoft External Staff Moderator
1 answer

I have a line chart with year and value and it is getting sorted by the year , i want to sort the lines with the values descending order

I have a line chart with year and value and it is getting sorted by the year , i want to sort the lines with the values descending order

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-07T08:43:57.01+00:00
Samantara, Simran 0 Reputation points
commented 2026-04-07T11:37:19.4633333+00:00
Jayden-P 19,065 Reputation points Microsoft External Staff Moderator
2 answers

How do I create an IF function to pull from another tab?

I would like to create "IF" functions to pull information from columns from another tab.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-02T16:31:49.0166667+00:00
Myra Jose 0 Reputation points
commented 2026-04-06T23:02:55.2933333+00:00
Hendrix-C 14,325 Reputation points Microsoft External Staff Moderator
1 answer

Updating a date field via Excel Online clears Originating Lead – expected behavior or configuration issue?

In Microsoft Dynamics / MSX, I am experiencing the following behavior: When updating only the Estimated Close Date of an Opportunity via Excel Online (Export to Excel – Dynamic Worksheet), the Originating Lead / Lead Source field is automatically…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-02T11:20:08.4966667+00:00
Enrique Fleischmann 0 Reputation points Microsoft External Staff
answered 2026-04-02T12:31:31.6533333+00:00
Gabriel-N 15,715 Reputation points Microsoft External Staff Moderator
2 answers

gantt chart

How to create a gantt chart. Arrange the data see the outcome. looking for a single bar chart with mutliple strips

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-27T00:34:42.3166667+00:00
Paul Erickson 0 Reputation points
edited an answer 2026-03-31T09:55:59.8033333+00:00
Griffith N 0 Reputation points Microsoft External Staff Moderator
2 answers

Linking cells together

I am not well-versed in the more difficult things you can do in excel and I am not sure what I want to do is even feasible, but here goes: I trying to link cells together once info populates in the first cell. The first cell is populated when a drop down…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-19T20:11:54.2833333+00:00
YWPFSC Accounting 0 Reputation points
commented 2026-03-30T23:24:00.47+00:00
Kai-L 12,310 Reputation points Microsoft External Staff Moderator
2 answers

Blocked macros by Microsoft

I created macros on an Excel file and saved the file in the company server. There are no restrictions on the server regarding macros but once I open the file in the server, the following message appears "Microsoft has blocked macros from running…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-25T16:40:54.1333333+00:00
Ricky Correia 0 Reputation points
commented 2026-03-27T03:21:09.5733333+00:00
Doris V 1,375 Reputation points Microsoft External Staff Moderator
1 answer

Microsoft Excel

We kindly request that you confirm whether the Microsoft Excel application can be considered a specialized program/software for project management, in accordance with professional standards in the field, and whether we may use Microsoft Excel to create a…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-23T10:11:45.0566667+00:00
EPMC 20 Reputation points
commented 2026-03-24T08:08:26.12+00:00
Rin-L 17,805 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Help with excel formula calculated by name and credits.

I am trying to generate a formula that will multiply the number of credits for a course by the price per course, but the total amount owed will be different for some students taking 1 course, 2 courses, 3 courses, etc. I would only want the formula to…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-18T14:21:58.3933333+00:00
Mark 20 Reputation points
answered 2026-03-19T06:32:54.2166667+00:00
IlirU 2,176 Reputation points Volunteer Moderator
1 answer

Some Excel (.xlsx) files which open fine in Office 365 fail to open in Excel 2024 LTS (32Bit) and need to be repaired

I have certain excel (.xlsx) files which open fine in Excel 365 but not Excel 2024 LTS(32Bit) When I try open the file in 2024, I get a message saying Excel found a problem with some content and offers to recover the file. If I say yes then the…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-12T17:50:24.09+00:00
Mark Stevens 0 Reputation points
edited a comment 2026-03-17T02:42:59.05+00:00
Sophie N 13,580 Reputation points Microsoft External Staff Moderator
3 answers

Copilot is missing from my excel

Hi everyone, Copilot is missing from my excel but it's present in word and powerpoint. Please can someone help me? Thanks. Fabrizio

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-12T11:03:40.9033333+00:00
Fabrizio Anzalone 0 Reputation points
commented 2026-03-15T14:19:03.71+00:00
Jess-Q 9,670 Reputation points Microsoft External Staff Moderator
2 answers

How to create a VBA yes no question msgBox

I like to ask if a Name is correct. Yes continue No change Namefield

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-06T22:32:18.8133333+00:00
Jan Aberkrom 0 Reputation points
commented 2026-03-13T06:30:15.8633333+00:00
Alina Le 1,065 Reputation points Independent Advisor
2 answers

Exporting CRM opportunities into excel

How can I export CRM opportunities into excel? I have searched for specific opportunities and they have come up. Now I want to export them into excel into a table so that i can work with them there.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-09T12:50:15.59+00:00
Lynn Kauffman 0 Reputation points
answered 2026-03-09T14:21:07.4766667+00:00
Daniel-Vo 5,165 Reputation points Microsoft External Staff Moderator
2 answers

Some but not all images are displaying on a shared excel file

Some but not all images are displayed on the shared excel file. I've done all the initial suggestions with no avail. The only way I can see all images is to download a copy and open the file in the app. The problem is this is a shared file between…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-03T17:34:10.09+00:00
JoEllen Sarich 0 Reputation points
commented 2026-03-06T06:19:55.45+00:00
Darren-Ng 9,180 Reputation points Microsoft External Staff Moderator
2 answers

Dynamic Array Functions FILTER and UNIQUE not working in Monthly Enterprise Channel

Hello I have an office 365 subscription, Monthly Enterprise Channel and I am trying to do some dynamic filtering and, according to Copilot my Filter and Unique functions are not actually present even though they do show up as formula options. I am up to…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-03T21:41:59.7666667+00:00
Ian Smith 0 Reputation points
commented 2026-03-05T09:01:43.6466667+00:00
Nam-D 3,395 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Project Coordinator

I am currently a Project Administrator with 9 years of experience in the telecommunications and construction industries. I would like to know which certification would be best for my career. I am planning to pursue the Microsoft Excel Expert…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-03-05T05:29:29.7833333+00:00
Remelyn Galon 20 Reputation points
accepted 2026-03-05T05:31:27.2766667+00:00
Remelyn Galon 20 Reputation points
1 answer

Como resolver o problema do excel online que não carrega um arquivo específico?

Estou tetando há dias abrir uma planilha que eu criei no excel online, mas não consigo. Aparece a seguinte mensagem: "Algo não deu certo A página solicitada está temporariamente indisponível. Pedimos desculpas pelo inconveniente. Verifique…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-02-25T16:30:57.6933333+00:00
João 0 Reputation points
edited a comment 2026-03-01T22:58:20.84+00:00
Hendrix-C 14,325 Reputation points Microsoft External Staff Moderator