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

Sort by: Updated
1 answer

Best practices for structuring web data metrics in Excel Power Query

Hi everyone, I am building an automated retail tracking template using Microsoft Excel Power Query to pull live product layout data.I am studying successful online setups to model our dashboard structure efficiently. I am currently looking at how the…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-15T09:27:29.19+00:00
Muhammad Umer 0 Reputation points
commented 2026-07-16T13:29:54.4866667+00:00
Vergil-V 16,630 Reputation points Microsoft External Staff Moderator
1 answer

excel not showing Automate Work option

I am unable to see the "automate work" option in my web excel

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-13T18:11:39.4033333+00:00
Hingle, Angela 0 Reputation points
commented 2026-07-14T21:54:34.54+00:00
Kristen-L 14,820 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Pivot table linking to non-existent data source

Hi I had to edit a spreadsheet created by another person, so I saved the file under a new name by adding my initials. The pivot tables point to the same Excel table as the data source. When I try to refresh all, I get an error message saying it can't…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-11T17:01:46.9233333+00:00
Steve Bavis 60 Reputation points
commented 2026-07-13T21:03:07.1266667+00:00
Kristen-L 14,820 Reputation points Microsoft External Staff Moderator
1 answer

how to remove the ctrl options popup from excel on the web

I am tired of a small popup obscuring the adjacent lines in the spreadsheet every time I paste something into a cell. I don't need a ctrl options to pop up, I'm using ctrl already, that's how I pasted in the first place. There is no options or settings…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-13T19:09:03.9733333+00:00
Madi S 0 Reputation points
answered 2026-07-13T20:35:14.85+00:00
Hendrix-C 18,965 Reputation points Microsoft External Staff Moderator
2 answers

Unable to Excel and other Microsoft application

I am experiencing a recurring issue with Microsoft Excel. Whenever I try to use Excel, I receive the following error message: "We're sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-11T12:06:49.28+00:00
Reynard Enterprise 0 Reputation points
commented 2026-07-13T08:45:05.0666667+00:00
Rin-L 22,875 Reputation points Microsoft External Staff Moderator
5 answers One of the answers was accepted by the question author.

How to disable Copilot in Excel

How do I make this go away? Any time my cursor passes over it a menu pops up and disrupts my work flow.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-05-08T13:26:42.0433333+00:00
LEng 30 Reputation points
edited a comment 2026-07-09T12:43:43.1633333+00:00
Dan Dascalov 0 Reputation points
1 answer One of the answers was accepted by the question author.

Formula based on criteria..

Hello I have one conditions I have values in column W & X, They needed to be coompare these values with each other based on criteria as shown in boxes Once it fulfilles the criteria the coumun y must say Feild, Feild II, Fiel II or Field IV see in…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-25T14:02:49.12+00:00
Chaturvedi, Santosh 240 Reputation points
commented 2026-07-06T14:47:52.8666667+00:00
Chaturvedi, Santosh 240 Reputation points
2 answers

I need to write a formula in excel

I need to write a formula that if an employee has 30 years in ERS and is 55 show as true or show as yes. I don't care how it shows as?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-06T13:12:33.96+00:00
Ellis, Jessica 0 Reputation points
edited an answer 2026-07-06T13:29:55.4166667+00:00
Senthil kumar 1,720 Reputation points
1 answer

CSV - Parse to JSON fails with "contentBytes cannot be selected" — attachment content missing from Get attachment content

Hi everyone, I've built a flow called CSV Attachment to Excel Sync and I'm stuck on an error I can't figure out. Hoping someone here can point me in the right direction. What the flow is supposed to do: Trigger: When a new email arrives (V3) List rows…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-05T16:19:18.36+00:00
James Riaz 0 Reputation points
answered 2026-07-05T23:40:56.48+00:00
Darren-Ng 12,595 Reputation points Microsoft External Staff Moderator
4 answers

Missing stocks in Excel

In Excel, the “Stocks” command is missing from the data types. Where did it go?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-16T09:19:56.9566667+00:00
Levente Ungvári 0 Reputation points
commented 2026-07-03T14:54:35.4466667+00:00
Michelle-N 20,050 Reputation points Microsoft External Staff Moderator
5 answers

"SPCX" is not recognized in Data

Space X symbol SPCX is not available on Data Stocks. Please correct as it is the only missing stock symbol on my spreadsheet and also happens to be the largest IPO ever. Why the delay?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-17T17:21:50.3533333+00:00
Warren 5 Reputation points
commented 2026-07-03T10:13:29.8033333+00:00
Warren Ridings 0 Reputation points
1 answer

copy and paste a value from a formula in excel

trying to copy and paste from formula to value in excel - continues to copy the formula. anyone else having this issue

Microsoft 365 and Office | Excel | For business | Other
asked 2026-07-02T17:39:49.5433333+00:00
P Camara 0 Reputation points
commented 2026-07-03T04:54:45.1866667+00:00
Senthil kumar 1,720 Reputation points
2 answers

Unblock Macros

I'm trying to unblock macros (being blocked my Microsoft) and the Unblock option isn't available in the document properties.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-05-31T20:38:17.3366667+00:00
Adam Lesmeister 0 Reputation points
commented 2026-06-30T12:18:55.4066667+00:00
Ana Le 1,515 Reputation points Independent Advisor
1 answer

Exporting Dynamics Opportunities to Excel

How do I convert the Opportunities Window to an Excel format

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-25T19:56:14.9333333+00:00
Mike Curley 0 Reputation points
answered 2026-06-25T20:38:14.9+00:00
Hendrix-C 18,965 Reputation points Microsoft External Staff Moderator
1 answer

How do I unblock macros within a single Excel Spreadsheet

How do I unblock a single Excel file's macros

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-23T23:13:19.0066667+00:00
RMT4160 91 Reputation points
commented 2026-06-25T13:27:50.99+00:00
Gabriel-N 20,050 Reputation points Microsoft External Staff Moderator
2 answers

How to display the duplicate values in an excel table using office script

I am working on an Office Script in Excel where I need to identify duplicate values within a table. However, I do not want to remove these duplicates—I only want to highlight or detect them using conditional formatting. The table already has filters…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-18T09:29:00.1533333+00:00
Varghese Rohit Monson 0 Reputation points
commented 2026-06-23T14:18:03.0066667+00:00
Michelle-N 20,050 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Repeat same Macro for all sheets in same cell

hello I have made one macro to insert the formula in sheet S1 in cell F6. This is same from F6 to the end of F column. This macro is shown below is well working Now --> I do have the sheet from S2, S3, S4.....S 150 I want --> to repeat the same…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-23T12:19:38.43+00:00
Chaturvedi, Santosh 240 Reputation points
edited a comment 2026-06-23T14:05:01.3533333+00:00
Jayden-P 25,325 Reputation points Microsoft External Staff Moderator
1 answer

How to make Macro for all 20 sheet that excute in one step

Hello I have made one macro to insert column and execute one formula. see below I want to make this common for all 20 sheet in one workbook. Means this marco shall happen for all sheets in one run. The macro for one sheet is as below.. function…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-16T14:40:58.09+00:00
Chaturvedi, Santosh 240 Reputation points
commented 2026-06-17T23:10:41.43+00:00
Hendrix-C 18,965 Reputation points Microsoft External Staff Moderator
2 answers

Unblock Macros from VPN server

I have tried a variety of things, including: Trust Center - Trusted Locations- adding the server folder and checking the subfolders (and even adding to the specific folder that one of my sheets in for good measure) Trust Center Trusted Documents -…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-06-15T13:47:45.17+00:00
Meyer, Cassandra 0 Reputation points
commented 2026-06-16T14:30:42.4733333+00:00
Michelle-N 20,050 Reputation points Microsoft External Staff Moderator
9 answers

Comparing two columns vales from filtered table and original table and decide the values are present or not.

Hello all Here is one situation: I have to make a check cell of comparing two columns of filtered table (red & blue columns) with its its mother data table (red & white). And want to make decision that the two columns value from mother table is…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-05-27T16:09:28.03+00:00
santosh chaturvedi 0 Reputation points
edited a comment 2026-06-15T19:12:00.0066667+00:00
Hendrix-C 18,965 Reputation points Microsoft External Staff Moderator