4,002 questions
4,002 questions with Microsoft 365 and Office | Excel | For business | Windows tags
2 answers
One of the answers was accepted by the question author.
Combine Index Match and MID formulas
Column X -- business name (Business 1, Business 2, etc.) Column AA -- job description (001 Contractor, 002, Sub Contractor, etc.) Column AG -- lead job supervisor (Joe Smith, Jane Doe, etc.) helper column: Column A = INDEX(AA:AA,MATCH(AG2,X:X,0)) = 001…
Microsoft 365 and Office | Excel | For business | Windows
![](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(243.2, 88%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL7%3C/text%3E%3C/svg%3E)
1 answer
excel vba creates error message after upgrade to windows 11
after a window 10 to win11 upgrade excel vba blocks access to oracle database. the vba runs without problems on windows 10.
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
Windows for business | Windows Client for IT Pros | User experience | Other
asked 2025-01-08T10:13:41.7233333+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(131.20000000000002, 15%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERE%3C/text%3E%3C/svg%3E)
Renée Sulaweyo
0
Reputation points
commented 2025-07-18T17:16:00.58+00:00
MotoX80
36,506
Reputation points
1 answer
Missing Coalesce function in Excel Power Pivot
I am trying to use Coalesce in a Measure in Power Pivot. It gives me this error: "Failed to resolve name 'COALESCE'. It is not a valid table, variable, or function name." I am using Office 365 for Enterprise, I have checked that my DAX engine…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-18T15:54:38.87+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(224.00000000000003, 27%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Brian Koo
0
Reputation points
edited an answer 2025-07-18T16:50:03.41+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(249.60000000000002, 17%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chris Duong
75
Reputation points Microsoft External Staff
Moderator
2 answers
Why is an Excel workbook not added as a trusted document when it is stored in OneDrive folder?
I have an Excel macro enabled file 'Workbook1.xlsm' stored in a folder in the 'OneDrive - Personal' location of my computer. When I access the file, I am presented with the security warning 'Macros have been disabled.' When I select the 'Enable Content'…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-06-30T19:50:45.25+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(137.6, 85%, 23%)' 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)
SLax
20
Reputation points
commented 2025-07-18T13:26:03.74+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(227.2, 9%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Michelle-N
2,400
Reputation points Microsoft External Staff
Moderator
3 answers
We are experiencing persistent Bloomberg/Excel/One drive sync issues causing large files to crash - Bloomberg believes the issue relates to OneDrive - is anyone lese experiencing this how do we fix it?
Our team uses shared Excel spreadsheets daily - many have multiple Bloomberg links to update fields in these spreadsheets - starting on the 18th oof June - these files have become increasingly problematic - crashing repeatedly - for all users. Bloomberg…
Microsoft 365 and Office | Excel | For business | Windows
4,002 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(28.799999999999997, 77%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
2 answers
Power query for excel loading data internally is sometimes very slow.
Hi, I have an excel workbook (xlsm) with lots of nested power queries that all take data from within the same workbook and transform it. While there's a lot going on , here's a specific example from one set of queries. It's stored on my C drive so no…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-16T07:48:57.8066667+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(76.8, 23%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Teresa Roberts
0
Reputation points
commented 2025-07-18T07:22:51.56+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(25.6, 60%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Phoebe-N
0
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How to fix "This file can't be previewed because of an error in the Microsoft Excel previewer" error message.
Can't preview Excel files in Windows Explorer. Have tried all the usual fixes. None have worked thus far. Happened before and went to Options/Add ins and then something else and worked but now that isn't happening. Tried the registry fix - no good. …
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-17T12:36:38.45+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(179.20000000000002, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Carla Wilkins
20
Reputation points
commented 2025-07-18T07:14:25.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(67.2, 30%, 16%)' 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)
Julie-Hu
230
Reputation points Microsoft External Staff
Moderator
1 answer
Not getting 'Format Comment' in my Excel
I want to enlarge the text in an Excel comment. Several places on the web tell me to select the comment text, then right-click and choose Format Comment. I've tried this several times, including with variations: e.g. selecting all the text in a comment…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-09T11:24:48.55+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(76.8, 95%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kirk Hansen
20
Reputation points
commented 2025-07-18T07:07:09.0566667+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, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Gabriel-N
2,995
Reputation points Microsoft External Staff
Moderator
2 answers
Excel not getting fully maximized. Seems to only '90%' maximize
Hello all, We are having an issue where the Microsoft Excel files are opening not fully maximized, i.e there will be small gaps on the top and the 'Maximize' icon will be enabled. The excel will be maximized to the full display only after clicking this…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-17T13:10:13.3+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(182.40000000000003, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Researcher
11
Reputation points
commented 2025-07-18T06:08:39.5533333+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(265.6, 79%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sting-Ng
475
Reputation points Microsoft External Staff
Moderator
1 answer
How to get my tabs back on my Excel spreadsheet
I have and excel spreadsheet, with multiple tabs, that was sent to me and looks fine. When I save it, all the tabs disappear. I have run a repair on my Microsort Office product but it did not fix the problem. I suspect there is a setting that needs to…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-15T17:45:08.4166667+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(67.2, 2%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Roseanne Surridge
0
Reputation points
commented 2025-07-18T02:30:05.5833333+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(278.4, 37%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Huy-K
0
Reputation points Microsoft External Staff
Moderator
4 answers
Excel question about converting data
I am working on a spreadsheet of data exported from a database. There is an inconsistency with the output that seems to be related to Excel. In the example below, most of the #NAME? - the data is =+DRUSEN. I thought it might be because the field did…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-02T19:13:27.26+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(35.2, 68%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jennifer Tucker
0
Reputation points
commented 2025-07-18T01:55:39.5633333+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(140.8, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Flora-T
1,445
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How can I pull only last names from a list containing two and three word names
I am working with a list of names in Excel. Some have only a first and last name, while others have a middle name as well. how can I pull out only the last names? Thank you
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-17T14:33:36.6833333+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(220.8, 40%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOL%3C/text%3E%3C/svg%3E)
Oren Lifshitz
20
Reputation points
accepted 2025-07-18T00:42:34.8633333+00:00
Oren Lifshitz
20
Reputation points
0 answers
Is it possible to change the Grand Total in a Pivot Table to % Difference?
Hi, Is the question in the title possible? I would like to show the week on week variation for my dataset. I tried to use the value field settings option but it changes all the data to show the % diff from the base item selected, see example below My…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2024-11-30T06:39:42.4433333+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(262.40000000000003, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tricia Tan
0
Reputation points
commented 2025-07-17T23:39:11.6466667+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(310.4, 73%, 40%)' 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)
Ashish Mathur
85
Reputation points
2 answers
Want to make it so that a Pivot will show how many days a vehicle is used monthly rather than total journeys
So the scenario I am in in that my company has multiple vehicles which can be taken as part of a car pool. Some cars are more popular to be taken than others. At the moment, on a spreadsheet we manually record the journey number, date of journey, time…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-05-20T15:43:08.29+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(304, 13%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MJ
0
Reputation points
answered 2025-07-17T23:25:57.95+00:00
Ashish Mathur
85
Reputation points
2 answers
comparing two sheets
I need to compare data in two sheets for differences. If any value in Sheet "Drive" column C is not found in sheet "daily" column a, I want it to highlight yellow. And if any value in sheet "daily" column A is not found in…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-05-30T11:52:56.73+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(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JH
0
Reputation points
answered 2025-07-17T23:22:03.6+00:00
Ashish Mathur
85
Reputation points
2 answers
How do you import data from one excel sheet to another sheet in the same workbook that auto updates?
I need to update a master sheet and have those updates auto update on 3 other sheets in the same workbook. I used the Insert link but it would not update when I inserted a new row in the master sheet. I am trying to keep an alphabetical list of names in…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-06-24T15:27:32.5266667+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(19.2, 98%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Haynes, Melanie
0
Reputation points
answered 2025-07-17T23:17:26.01+00:00
Ashish Mathur
85
Reputation points
3 answers
One of the answers was accepted by the question author.
Specific filtering in Excel
Hello all, In my line of work i get given Excel docs with 15,000+ entries for data regarding devices, info on there includes things like IP addresses, IMEI etc and i get another excel doc with 200+ entries with limited info, only the IMEI for example,…
Microsoft 365 and Office | Excel | For business | Windows
4,002 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(227.2, 66%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to Dynamically Carry Over & update Column Letters+Values with a Formula on one Sheet from a Reference Sheet
I'm working with two sheets: an input sheet and a reference sheet. The input sheet is for monthly forecasting has 12 tabs for each period in the year, and the reference sheet is a budget for next year. Each period, I reference cells from the budget sheet…
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-15T15:57:07.06+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(259.20000000000005, 97%, 35%)' 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)
Pasquarella, Stephen
20
Reputation points
edited an answer 2025-07-17T22:30:57.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(172.8, 49%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jay Tr
150
Reputation points Microsoft External Staff
Moderator
1 answer
the system detected an overrun of a stack-based buffer in this application
Excel.exe System Error the system detected an overrun of a stack-based buffer in this application. The overrun could potentially allow a malicious user to gain control of this application
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-15T20:04:19.91+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(108.80000000000001, 64%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alexander Dumas (Admin)
0
Reputation points
commented 2025-07-17T22:15:34.7366667+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(281.6, 26%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Killian-N
95
Reputation points Microsoft External Staff
Moderator
1 answer
Excel protected cells not working
Hello, I got my worksheet protected. I was able to edit unlocked cells as well as sort all columns but Everything else that I checked did not work. Your assistance is very much appreciated. Thanks
Microsoft 365 and Office | Excel | For business | Windows
4,002 questions
asked 2025-07-17T19:33:27.4133333+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(291.2, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Therence Valdez
0
Reputation points
answered 2025-07-17T20:22:20.8533333+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(51.2, 21%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vy Nguyen
385
Reputation points Microsoft External Staff
Moderator