Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
21,065 questions with Microsoft 365 and Office | Excel | For business | Windows tags
0 answers
Using SharePoint List as Excel data source
It is nearly 2027 and Microsoft still hasn't figured out a way to create an Excel file using a SharePoint list as a data source. Do I need a third party solution for this?
Microsoft 365 and Office | Excel | For business | Windows
asked
2026-10-14T22:41:20.65+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(96, 0%, 19%)' 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)
David Cummins
0
Reputation points
1 answer
Patch Regression: KB5002934 (October 2026) breaks copy/paste fix originally provided by KB5002665 in Excel 2016 MSI
Issue Description: The silent copy/paste failure in Excel 2016 (MSI) has returned immediately after installing the cumulative update KB5002934 (released October 13, 2026). Technical Analysis: Environment: Excel 2016 MSI (Traditional Volume License…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-14T16:11:30.66+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(73.60000000000001, 15%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Narciso Gonzalez
0
Reputation points
edited a comment
2026-10-14T20:14:07.1866667+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, 76%, 35%)' 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)
Hebert Shinzato
0
Reputation points
2 answers
Power Query "Expression.Error: Access to the resource is forbidden" when connecting to Exchange Mailbox on Excel Desktop client (Works fine on Web version).
Hello Microsoft Support Team, We are encountering a persistent authentication error across multiple user tickets within our organization when attempting to connect Excel Desktop Power Query to a Microsoft Exchange mailbox. Symptoms: Power Query fails…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-14T18:39:53.6766667+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, 34%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sandeep boudh
0
Reputation points
answered
2026-10-14T18:53:04.19+00:00
Baraniwala Chamali Lalanthi Liyanage
0
Reputation points
3 answers
Excel File > Open search bar is returning non-Excel results
When I try search for a recently used/opened file in Excel, it starts to show me the correct result but then it suddenly fills up with all sorts of other files, including non-Excel files. For example I am looking for a recently used spreadsheet with…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(124.80000000000001, 6%, 22%)' 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)
3 answers
KB5002914/KB5002665 — Conditional Formatting on a worksheet breaks Copy/Paste (all forms), Format Painter, and Move-or-Copy Sheet; Microsoft's documented Paste Special workaround does not resolve it
Build affected: Office LTSC 2024, Version 2408, Build 16.0.17932.20996 (also seen on 20976). Still present after KB5002665 (9/16/2026). Trigger: Presence of any Conditional Formatting rule anywhere on a worksheet — not limited to the specific range being…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-09-18T15:47:33.0366667+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, 42%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gothro, Matthew
0
Reputation points
answered
2026-10-14T16:01:51.66+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(73.60000000000001, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB1%3C/text%3E%3C/svg%3E)
BOB-1057
25
Reputation points
2 answers
Excel 2016 Copy/Paste Issue After KB5002934 Update – Recurrence of Previously Fixed Issue
Hello Microsoft Support Team, Following the installation of the KB5002934 security update released on October 13, 2026, we have encountered copy-and-paste issues in Microsoft Excel 2016 (64-bit) across multiple computers in our organization. Issue…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-14T14:19:12.38+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, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYI%3C/text%3E%3C/svg%3E)
Yiğit Selçuk
0
Reputation points
edited an answer
2026-10-14T15:53:55.48+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, 15%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Daniel-Vo
6,880
Reputation points Microsoft External Staff
Moderator
1 answer
How to Filter workook
When users filter columns in the workbook, the filters are being applied globally and update everyone's view of the file. Previously, users would get the option to create or use a personal view (e.g. "View for me" / Sheet View), allowing them…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(313.6, 88%, 40%)' 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)
2 answers
Excel - Links
Good day, I urgently need assistance with excel links, I did not change the links. We are currently running through SharePoint, we are more that user using the files, and time and again formulas and links changes, and honestly I did not change them,…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-13T06:31:37.5666667+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(307.2, 17%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mariaan Bester
0
Reputation points
commented
2026-10-14T07:08:51.4433333+00:00
Mariaan Bester
0
Reputation points
4 answers
How to filter out any client with specific products in their account
I have an Excel spreadsheet with a list of clients and products as well as account representatives assigned for each client. I need to identify all clients whose combination of products include specific products within that combination and identify…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-09T00:32:26.5766667+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(297.6, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lissette Roman
0
Reputation points
commented
2026-10-14T03:38:00.49+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, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Teddie Dang
1,620
Reputation points
Independent Advisor
2 answers
How to get excel to wrap a wide spread sheet to print on one page.
I have a very wide spread sheet but very few rows. Currently it prints on two separate pages. I can do a print to fit but then the text is unreadable. In the past, Excel was able to scale this and wrap the second page of the spreadsheet and print…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(153.6, 14.000000000000002%, 24%)' 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)
2 answers
How fix to copy and paste in excel
I am unable to copy and paste in excel and would like to know how to fix this.
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-05T15:24:16.9733333+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, 80%, 35%)' 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)
Allen Banner
5
Reputation points
edited a comment
2026-10-13T15:12:45.92+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, 33%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELV%3C/text%3E%3C/svg%3E)
Lin v
1,550
Reputation points
Independent Advisor
2 answers
how to fix notice when opening spreadsheets that says excel has run into a problem
when i try to open a excel spreadsheet it pops up the notice...we're sorry, but the excel has run into an error that is preventing it from working correctly. excel will need to be closed as a result. would you like us to repair now? but nothing happens…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(169.60000000000002, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
![](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, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
3 answers
Chronic "formula becomes text" issue in Excel Tables feature, when a GENERAL formatted formula refers to at TEXT formatted column
The title is a mouthful, but to me, there seems to be a bug in Excel under the following circumstances, that I haven't seen much written about. (Lots about how to fix, but I haven't seen anything on the cause of it). Using an Excel Table specifically.…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(188.79999999999998, 72%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
![](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(284.8, 89%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
problem to run excel marco with out ms office excel installation on wenserver
Hello, we are searching one solution for our business case: Server: window webserver Service: Webservice in IIS Function: we want to write one function to 1. open excel, 2. call excel marco, 3. save the result in the runtime. problem: we find few…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-09T07:43:11.12+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(204.8, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYH%3C/text%3E%3C/svg%3E)
Yu, Hai (CTDB1D)
20
Reputation points
accepted
2026-10-12T05:37:51.9266667+00:00
Yu, Hai (CTDB1D)
20
Reputation points
1 answer
COUNTIF formula does not work
this formula has worked before and now it does not. Is there something wrong with syntax? =COUNTIF('All eLearnings'!C:C,A2)
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-08T15:27:24.0133333+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(64, 96%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Elliott, Shelly (VDSS)
0
Reputation points
commented
2026-10-09T22:32:29.9766667+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, 83%, 24%)' 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-D
2,100
Reputation points
Independent Advisor
2 answers
How to fix Input Form copy & paste fail in excel
I have an input form in an excel workbook and I used to be able to copy cells from the workbook into the form text boxes using the normal copy and paste functions - ctrl + v or right click paste but neither of those work any longer, I have to use…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-08T17:33:57.6633333+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(134.4, 41%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Carolyn Butler
0
Reputation points
commented
2026-10-08T19:31:51.93+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, 56.00000000000001%, 31%)' 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)
Hendrix
2,075
Reputation points
Independent Advisor
2 answers
One of the answers was accepted by the question author.
XLOOKUP help
I have a master data tab called “Master FOF” and then one tab for each month of the year. I would like the data from Master FOF to be pulled into the month tabs by matching the names in column A on both tabs (the names match) and the fiscal year month…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(179.20000000000002, 65%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
5 answers
FREEZING SCREEN PROBLEM IN MICROSOFT EXCEL 2024 LSTC 17392.21000
Sometimes, when working in Excel 2024 LSTC , switching between sheets causes the colors and headers to disappear or no longer display correctly. Using the Filter tool can also make all open Excel files become unresponsive, leaving only the options to…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-05T07:21:16.5366667+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(144, 92%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mohsen Safari
0
Reputation points
commented
2026-10-08T11:04:38.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(38.4, 6%, 13%)' 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 Nguyen
2,285
Reputation points
Independent Advisor
5 answers
One of the answers was accepted by the question author.
totals for specific dates formula
Hello! I have been trying to figure out a way to pull specific dates for the month into a totals column but have not been able to figure out a formula that works. I keep getting a #value error. I've tried sumproducts, filter, etc. I want to add the…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 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(169.60000000000002, 94%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
2 answers
STOP READ ONLY ON ALL EXCEL FILES
SOME EXCEL FILES CHANGED TO READ ONLY. HOW CAN I MAKE THOSE FILES NOT READ ONLY AND HOW I DO I PREVENT FILES BEING CONVERTED TO READ ONLY
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
21,066 questions
asked
2026-10-06T19:21:54.78+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(198.4, 9%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Alan Phillips
0
Reputation points
commented
2026-10-07T19:39:57.7966667+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, 34%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Ryan-N
16,220
Reputation points Microsoft External Staff
Moderator