1,552 questions

Sort by: Updated
2 answers

Excel sheet only shows first 1000 rows when filtering

In excel web browser on SharePoint my filter is limited. How do I get it to show all unique items in each column? Not just the first 1000.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-19T19:15:27.39+00:00
Phelps-Ward Angela E 0 Reputation points
edited an answer 2026-11-19T19:48:00.8+00:00
Ivory 2,900 Reputation points Independent Advisor
2 answers

I am not able to sort/insert as I have before

I have a spreadsheet that is sorted by A-Z also by color. I can no longer add a line in between certain cells and can no longer sort as I customized and it was always done. I receive a message for both stating it would involve many cells and would take…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-18T23:41:53.24+00:00
Medina, Carmelita 0 Reputation points
answered 2026-11-18T23:57:17.8533333+00:00
BabybooHN 4,310 Reputation points Independent Advisor
2 answers

Excel hanged up, stopped working

I asked Copilot to search and replace some data and fill the cells with orange color. The Copilot started working but after that Excel stopped working and the other files already opened at the moment could not accessed. Excel got stucked. So then I…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-16T05:29:36.42+00:00
Muhammad Ayaz 0 Reputation points
commented 2026-11-17T14:55:04.3933333+00:00
Ana Le 2,980 Reputation points Independent Advisor
2 answers

How to Fix

How to fix #N/A on the What if simulation. I ran the simulation correctly using the Data table function on the what if analysis and it still won't work.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-15T22:36:19.81+00:00
Morris, Tyler 0 Reputation points
commented 2026-11-16T21:58:03.7966667+00:00
Aetherin 4,500 Reputation points Independent Advisor
3 answers

Copilot in excel keeps failing

I know Outlook is currently having issues, but why is Copilot in Excel broken too? It just keeps loading and then throws an error every single time. What kind of terrible system is this?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-13T00:57:19.4166667+00:00
Roosevelt 0 Reputation points
answered 2026-11-13T16:47:56.52+00:00
Elena-VH 2,855 Reputation points Independent Advisor
0 answers

I would like to export all tracked changes in my excel sheet

I have an Excel spreadsheet in which I made changes and turned on track changes. I can do a 'Show changes', but I would like to export all those changes to a new Excel sheet. Do you have an code that can do that? Moderator note: Locking thread because…

Microsoft 365 and Office | Excel | For business | Other
asked 2024-04-13T12:54:27.94+00:00
Sultana 15 Reputation points
edited the question 2026-11-13T11:08:22.2133333+00:00
Stefan Blom 358K Reputation points MVP Volunteer Moderator
2 answers

how do i add a kpi

I have a power BI I am building a KPI I need to know how to sum the sum of all values of a field like total sales where each order has a total sales. I need total sales of total sales.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-12T16:02:58.55+00:00
Kenneth Borruso 0 Reputation points
edited an answer 2026-11-12T16:16:55.6366667+00:00
Chris-D 2,710 Reputation points Independent Advisor
1 answer

Excel for the Web Cursor and Drag-and-Drop Functionality Not Working Across Multiple Devices

Issue Description I am experiencing an unexpected issue with Microsoft Excel where my cursor is no longer functioning as expected. I am unable to effectively select, edit, and drag-and-drop cells. I need to restore the cursor to its normal…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-11T15:14:39.4733333+00:00
Parris M 0 Reputation points
answered 2026-11-11T15:47:33.8266667+00:00
Ryan-N 16,980 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How can I build a better sales & profit dashboard in Excel?

Hi, community! I am currently working on building an interactive Sales & Profit Dashboard in Excel, based on a dashboard design I found as a reference. My goal is to turn raw sales data into a clear and easy-to-use dashboard that helps me track…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-11-09T15:34:10.54+00:00
Noah S 20 Reputation points
commented 2026-11-09T17:29:07.6266667+00:00
Aetherin 4,500 Reputation points Independent Advisor
4 answers

Problems with excel backgrund!!

How to change color theme in excel online Background is all black

Microsoft 365 and Office | Excel | For business | Other
asked 2026-10-29T15:14:14.12+00:00
Santa Elina Kravale 0 Reputation points
commented 2026-10-31T20:08:03.6233333+00:00
Ryan-N 16,980 Reputation points Microsoft External Staff Moderator
2 answers

Security Notification regarding Macros being disabled. Does not provide option for enable selection.

Intuit Quickbooks file is created in Excel for tax forms to be summarized in spreadsheet. This excel file spreadsheet has a security notification which stated macros are being disabled. There is no other option for enabling the macro. How can I get…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-10-23T22:48:52.9133333+00:00
Linda Shirk 0 Reputation points
commented 2026-10-25T21:54:09.8533333+00:00
Ivory 2,900 Reputation points Independent Advisor
2 answers One of the answers was accepted by the question author.

Help to find Microsoft Excel 365 technical books with formulas.

Good evening, everyone, I was wondering if you could help me. I’m looking for a technical book on Microsoft Excel 365. I’m trying to refresh some of the things that I learned in a course that I tooked a few decades ago. The course was “Microsoft Excel…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-10-15T21:32:19.6733333+00:00
Hugo Plácido 65 Reputation points
accepted 2026-10-17T21:13:55.5066667+00:00
Hugo Plácido 65 Reputation points
1 answer One of the answers was accepted by the question author.

Modify formula with indirect function

All data are not real as shown below.. In below formula: =LET(     Data, 'file:///Q:\Presentations\PE_31\O_Analysis and calculation\Fatigue\Backups_Marcros\Fatigue Assesment_as per 17949_Welded Joints\3_Fatigue Assesment_as per 17949_Welded…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-10-05T13:27:19.44+00:00
Chaturvedi, Santosh 650 Reputation points
accepted 2026-10-05T13:47:09.4633333+00:00
Chaturvedi, Santosh 650 Reputation points
4 answers

stop formulas from pulling wrong information

Hello! I have a data spreadsheet that I pull information from for an import spreadsheet that is a separate excel. They do have to be separate files. I need to be able to sort, filter, and add/remove lines on the data file without the formula data…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-24T19:08:42.3333333+00:00
Megan F 120 Reputation points
recommended 2026-09-29T21:14:23.9333333+00:00
Emily T 990 Reputation points Microsoft External Staff Moderator
3 answers

how to make adresse book in excel sheet to control the formula present in many sheets having filter formula buit init.

I have one situation I have two folders folder_1 and folder_2, Folder 1 ([DB_Data_Collectives_2.xlsm]) have one excel sheet_1 : S1 Folder 2 have differnt excel sheet_2 Excel 2 have Filter forrmula in one cell as below …

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-20T11:17:18.24+00:00
Chaturvedi, Santosh 650 Reputation points
commented 2026-09-26T20:00:17.14+00:00
Marcin Policht 113.6K Reputation points MVP Volunteer Moderator
2 answers

power automate in excel

how do i enable power automate in excel since i want excel to automate sending emails for me

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-10T21:19:40.49+00:00
Jessie Red 0 Reputation points
commented 2026-09-18T15:13:42.0366667+00:00
Lin V 2,135 Reputation points Independent Advisor
2 answers One of the answers was accepted by the question author.

how to collect the values from differnt sheets to one and sort them with simialr values.

(Note all values are fake not real) Hello -- I have one case. I need to paste the following content in sheet when is placed in starting seee below-. All the tabs (sheet, collective1,2,3,4...9)are in one sheet only. The values from tab Collective _1,…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-17T10:06:34.27+00:00
Chaturvedi, Santosh 650 Reputation points
commented 2026-09-18T15:01:20.53+00:00
Alina Le 5,985 Reputation points Independent Advisor
2 answers

How to fix this error and how can i start back my Microsoft Excel app?

This is the Screen shot of the error , please provide a solution to fix this?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-16T05:19:26.7366667+00:00
Kshitij Shirodkar 0 Reputation points
commented 2026-09-17T11:49:41.2866667+00:00
Ana Le 2,980 Reputation points Independent Advisor
1 answer

Copilot available in word, powerpoint, outlook but not in excel and teams

I can see the copilot icon on right bottom of word and powerpoint. I can also see copilot in the outlook ribbon. But unable to find copilot icon in excel and teams. It is neither available as right bottom icon nor in the ribbon.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-13T12:21:03.34+00:00
Jigisha Thakkar 0 Reputation points
commented 2026-09-15T10:27:20.5566667+00:00
Helen Luu 3,830 Reputation points Independent Advisor
1 answer

Excel Online functionality of Office Script buttons on protected sheets

Experiencing a problem with Office Script buttons in Excel Online. Previously, these buttons worked correctly on protected sheets, but now they only function when the sheet is unprotected. This change has disrupted my workflow, as I need to unprotect the…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-27T15:01:20.8966667+00:00
erinwhi 0 Reputation points
commented 2026-09-14T14:57:55.0866667+00:00