Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,142 questions
2 answers
How to calculate averages using power query in excel
I want to calculate the average of the grades for each student across all their modules. (This data is psuedonymised). But I want to make it so that a new line is inserted under each set of the same student, like this: Is this possible? Many thanks!…
asked 2025-02-04T10:08:14.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 39%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Paula Sutcliffe
0
Reputation points
answered 2025-02-07T11:07:29.6466667+00:00
riny
260
Reputation points
1 answer
Copying conditional formatting down a column in excel and the reference cell does not change
When I attempt copy a set of formatting rules established for Cell F48, down a column the reference cell does not change. In this example the rules created apply to Cell F48 as being equal to 0, less than or greater than Cell G48. When I copy with…
asked 2025-02-02T06:59:25.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 36%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hugh Secomb
0
Reputation points
commented 2025-02-07T09:17:21.5933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
1 answer
csv file not saving problem
After creating a csv file with python using read + option, open the file and edit it directly, and do not press ctrl+s or click the save button, but click the X mark on the top bar to save, a message asking "Do you want to save the changes to this…
asked 2025-02-07T02:04:38.3366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESO%3C/text%3E%3C/svg%3E)
seungyun oh
0
Reputation points
answered 2025-02-07T08:15:12.9033333+00:00
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to add cells together in Excel that arent numbers
Hello, I am just wondering if there is a similar function to 'SUM' in excel that instead counts the cells that have any kind of value in them? For example, I have a list of employees, however, some cells in the column are blank. I want Excel to be able…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 91%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to change access to files in teams
Hi, I was wondering if there was a way to change access to a single file on a teams channel? I have a single file that I would like even owners of the channel to only have viewing access. I have tried going through advanced settings and removing all…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,824 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,142 questions
asked 2025-02-03T16:17:29.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 0%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
Julia Oberhofer
20
Reputation points
accepted 2025-02-06T17:23:19.45+00:00
Julia Oberhofer
20
Reputation points
1 answer
Is there any usable way to copy Microsoft Excel sheets using the Graph API only?
Scenario I am developing an RPA integration application that automates several services, including Microsoft services via their APIs (specifically Microsoft Graph). I want to copy sheets in Microsoft Excel, but the Graph API does not fully support this…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,989 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,142 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,226 questions
asked 2025-01-30T03:44:09.9133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 67%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Juan Jimmy
0
Reputation points
edited a comment 2025-02-06T10:17:41.0733333+00:00
Juan Jimmy
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Known file getting tagged as malicious
I have a single macros enabled excel file, every time I make changes and save it with different name Defender MDE flags it as malicious and file gets corrupted. Every time I make changes, SHA value changes and hence submitting it to Microsoft as clean…
asked 2025-02-04T14:22:31.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 63%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Aishwarya RM
20
Reputation points
accepted 2025-02-06T10:01:19.05+00:00
Aishwarya RM
20
Reputation points
1 answer
VBA editor displays gibberish after IME selection
Hi Everyone, I am developing some scripts in VBA Editor using Excel (365) on Windows 11. Reinstalled Japanese Language Pack, checked Windows IME settings, changed VBA Editor Fonts, installed unicode fonts, changed system locale to Japanese, set Regional…
asked 2025-01-30T02:31:09.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 57.00000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Anthony B
0
Reputation points
commented 2025-02-06T09:47:34.88+00:00
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
1 answer
Error when accessing data from Web via APIs
How do I fix the error that I am getting when trying to get data from web. The username and password is correct and I am using API key but I am getting this error in the preview window “We were unable to retrieve the contents of the web page”
asked 2025-01-28T09:44:17.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 86%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Aashima
0
Reputation points
commented 2025-02-06T09:36:50.42+00:00
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
1 answer
Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.
Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…
asked 2025-01-25T00:57:29.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI8%3C/text%3E%3C/svg%3E)
IniobongNkanga-8038
936
Reputation points
edited the question 2025-02-06T07:57:01.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AllenXu-MSFT
23,426
Reputation points Microsoft Vendor
1 answer
Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.
Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…
asked 2025-01-25T00:57:29.9366667+00:00
IniobongNkanga-8038
936
Reputation points
edited the question 2025-02-06T07:57:01.8433333+00:00
AllenXu-MSFT
23,426
Reputation points Microsoft Vendor
1 answer
I have an old Mac with old software 12.7.6. even though ı download office 16.88 which The old version application in the link you suggested does not fix the problem.
in your reply to a similar complaint, you said Then for Mac OS Monterey "12.7.6., you can download 16.88 compatible version of Office: Office suite (with Teams) (with Teams) Office suite (without Teams) (without Teams) Please understand that our…
asked 2025-02-05T17:07:00.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 12%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
eda atay
0
Reputation points
answered 2025-02-06T07:37:53.59+00:00
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
0 answers
How to fix 0x8002802B Excel issue without repair Microsoft 365?
I have develop a tool which is using Microsoft.Office.Interop.Excel.Application and Microsoft.Office.Interop.Excel.Workbook to operate Excel. It can work well, but when my office get update from IT, my tool will get…
asked 2025-01-24T11:37:25.95+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZX%3C/text%3E%3C/svg%3E)
Zhang, Xiaona
0
Reputation points
commented 2025-02-06T02:50:51.2266667+00:00
Zhang, Xiaona
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Using IFerror with Left formula to separate numbers from text
I have an excel spreadsheet connected to an MS form and the MS form has options to choose for each question which pulls through into an excel table for example: - 1 - Doesn't understand Excel Each answer always starts with either 1, 2, 3, 4 or Absent,…
asked 2025-02-05T10:01:12.54+00:00
Emma Leigh
20
Reputation points
commented 2025-02-06T01:00:33.6066667+00:00
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Using IFerror with Left formula to separate numbers from text
I have an excel spreadsheet connected to an MS form and the MS form has options to choose for each question which pulls through into an excel table for example: - 1 - Doesn't understand Excel Each answer always starts with either 1, 2, 3, 4 or Absent,…
asked 2025-02-05T10:01:12.54+00:00
Emma Leigh
20
Reputation points
commented 2025-02-06T01:00:33.6066667+00:00
Jiajing Hua-MFST
14,420
Reputation points Microsoft Vendor
15 answers
One of the answers was accepted by the question author.
Excel Automate Office Scripts not working
I've been using Office Scripts in Excel to automate some tasking. Yesterday, I tried to add a new script and it gives me the following error. Oops, something went wrong An unexpected error occurred. Click 'Refresh' button to retry. I also tried 'Record…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,142 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,226 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 49%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
1 answer
Macro file not running on different devices!
I have been trying to open a macro file but the data won't load. I can open the file itself but the information I am selecting isn't showing. I’ve tried the following on the other computers: Unblock the file from Properties Saved the second Document as…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 55.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
1 answer
Autosave Onedrive and Sharepoint Online files option missing completely
Hello, I can't seem to be able to enable the Autosave button. It doesn't show up at all in the Quick Access Toolbar in Excel. But it also doesn't show up as an option to check in Excel->File->Options->Save. I am logged on my OneDrive Account…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 83%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
2 answers
Cannot generate embed view for excel workbook to allow guest access
Hi Team, The project I'm working on requires to display an embed view of our excel workbook on one of our web pages so that when a visitor lands on the site, they can use the excel sheet to do some basic budget calculating. In the excel workbook we…
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,173 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,273 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,755 questions
asked 2021-11-18T07:57:03.427+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Charles Huang
31
Reputation points
commented 2025-02-05T17:00:03.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 49%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
wade-pro
10
Reputation points
2 answers
Weird kerning in the formula bar Excel
Excel just started doing this: Expanding the space between the letters when I'm typing in Excel. (Notice the exaggerated space between the "S" and the "L"). When I press Enter, the spacing is corrected, but when I'm editing a cell,…
asked 2024-09-18T13:40:31.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Parker Beck
5
Reputation points
commented 2025-02-05T16:39:12.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 74%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Daniel Copeland
0
Reputation points