A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,503 questions with Microsoft 365 and Office | Excel | For business | Other tags
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
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
"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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Exporting Dynamics Opportunities to Excel
How do I convert the Opportunities Window to an Excel format
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data