Recent Discussions
Practical use of row_delimiter with TEXTSPLIT
Let me be clear, I am not asking HOW to use the row_delimiter part of the TEXTSPLIT argument, I am asking WHY. Any use case I have come up with so far would be better addressed by Power Query. Even if there is a reasonable example, it still seems like it would have to be looped using VBA. Is material out there on what the developers had in mind for using it? If anyone knows, please share or share any example you have. (I'm in pretty much the same place with the ignore_empty and pad_with parts of the argument as well.) Thanks!
Excel not able to write to Documents Folder
Hello, I was asked to help a family member who was having trouble writing files with Excel, and I have to admit their problem has me totally flummoxed; so, I was hoping for some help myself. When they open any Excel file, it says it is Read Only. Looking at document info confirms this, but we can't turn it off. Trying a Save As on the file generates a 0-byte file in the Documents folder and we then get a message that the file already exists, and we can't overwrite it. I set up a new folder and added it to their Documents library. This works perfectly with Excel being able to Read/Write any file in there. I thought it might be user permissions in Documents, but Word and Notepad can Read/Write in there without issue. The permission settings look good, and the problem is limited to Excel. The problem started when they downloaded a CSV file, so the first thought was it was a virus. They sent me a copy of the file which I checked in an isolated VM environment, and it appeared OK. Both of us ran virus scans that came out clean. Key differences between our environments are: that they are using Microsoft 365 and Norton antivirus, and I'm using Office 2016 and Avast antivirus. But both can out of scans clean. They have done a full reinstall of Microsoft 365 but the problem with Excel persists. If worse comes to worst, then there might be a full PC rebuild (ouch), or migrate everything to the new folder I set up and delete the old Documents folder. Ideally, I would like to remedy the cause of this issue which is why I'm asking for help.
How to Account for Inflation
Attached I show an account balance forecast going out 20 years. But 20 years from now, $176,560 won't feel like $176,560 feels today. So how can I reflect a 3% annual inflation rate in each of the years? Each year's balance is based on many "ins and outs" of money, so I can't just calculate using a rate of return less inflation. Thanks in advance!
M365 Copilot Android Application Not Working
I am using a Samsung S24 FE phone, and the Microsoft Copilot app is not working. When I open the app, I only see a black screen. I cannot open any menus. I cannot create or search for anything. There is only an empty home screen with dead buttons. I cannot sign out of my current account, nor can I figure out which account I am signed into (it logs in automatically). Here’s what I have already tried, but the issue persists: Enabled all permissions in the app settings. Deleted and reinstalled the app. Cleared the app cache and reopened it. Cleared the app data and reopened it.Filter cells in stead of full rows by color
Hi, I have an excel that contains a set of columns with values where in each column each cell has a certain fill color. Now I want to see per column only the cells with a specific color e.g. red. I tried the filter option on the columns, but that filters complete rows. I only want to filter the cells in a column. So in the image below I want to see only the red cells. So in column B no cells, in column C C3, in column D D4 and D5. The regular filter option would show B3 and B4 as well, because it would show the full row for C3 and the full row for D4. Any ideas on how I can achieve this? Thanks!
Stockhistory data integrity risk
Excel’s STOCKHISTORY function is misleading investors by using Refinitiv’s unadjusted feed. On Nov 1, 2025, DuPont (DD) spun off Qnity Electronics, reducing DD’s price by a factor of 2.3912. Every brokerage and charting provider adjusted the prior history to maintain continuity, but Excel did not—producing a broken series that invalidates returns, volatility, and backtests. This isn’t a feature request, it’s a data integrity bug. STOCKHISTORY must default to the adjusted feed or at least provide an adjusted:=TRUE option. If you rely on Excel for analysis, please upvote this so Microsoft fixes it before more users are misled.i need the data from all the sheets in the workbook to link to one data sheet.
A colleague of mine made a data spreadsheet (lets call it SHEET 1), he no longer works for the company and over time the worksheet has been amended, so doesn't work like it should. There are several sheets in the workbook and all data that is copied into these needs to go into SHEET 1 (doing it itself, not manually). My question is when I download my data and paste into SHEET 2, how do I get it to automatically go on to the SHEET 1, taking only certain parts of the data, in this case B and F. The attached is just a small example of the data I need from SHEET 2. On SHEET 1 There is a list of numbers on the left and more, how can I get this data to filter itself onto SHEET 1 in the right column then adding the numbers on the left together. So, on SHEET 1, 160 -T will show 7 because there is 7 1's below for that Org. Sorry if i have made this sound long winded, I am awful at explaining. I have basic knowledge of excel but I cannot get my head around formulas. It should look something like this. Any advice would be great. Thanks
PowerPivot not returning correct data
Hello, In the following link you will find a PowerPivot that is referencing 2 specific tables with Inv# being the common field between the 2 tables. The PowerPivot is bringing in Troy Ounces and Revenue by Invoice #, Fiscal Period and Department. Unfortunately the total Troy Ounce amount is being repeated under each Invoice #. It should be showing the respective troy ounce by what the invoice is recording. Is there a specific reason as to why the PowerPivot is not bringing in the correct troy ounce weight? Hope you can point me in the right direction. Here is the link: https://docs.google.com/spreadsheets/d/1QSu-QluTTAZBPsHtXhmkGoTezkPJv4Qp/edit?usp=sharing&ouid=103354753371375324640&rtpof=true&sd=trueContext menu immediately closing after opening
When I try to open the context menu using my mouse, trackpad or keyboard button it opens and immediately closes again. It only happens when a certain workbook is open, also effecting all other excel instances. Other pop ups behave similarly, for example when i want to open the vba menu it always focuses on the workbook windows instead of the vba window, sometimes it changes so that the vba window gets focused and I cant return to the worksheet. Other pop ups arent effected, like for example any settings menu. When im in the VBA window the context menu works normally. When clicking on the windows part of the window e.g. the title bar, it works normally as well. In the trust center I disabled all vba macros, my vba code is disabled using Application.EnableEvents = False, even though I didnt have this problem with the code running before. Im having this problem for a few days now, so I have restarted my PC and excel multiple times. Its a really strange problem and I have no idea what the cause could be and it became weirder and weirder while I was trying out stuff before posting here, so im very happy about every possible solution :)changing working times on an existing Project file
I have a large MS Project that was prepared using the standard calendar, but that calendar uses different daily shift times than what we want to use. I created a new calendar with the correct shift (working) times, set the Project to use that new calendar, but the old calendar times are still being used for new tasks, and existing tasks still have the old calendar times. I even changed all the individual tasks to use the new calendar with no effect. How can I force an existing Project use the correct calendar?Inserted Excel spreadsheet in Word not updating with added rows
Hi, I have inserted an Excel spreadsheet into my Word document via Insert --> Table --> Excel Spreadsheet. The contents of this spreadsheet show up in my Word document. However, if I insert a new row in Excel, while the row's contents show up and save in the Excel file, they do not appear in the Word document. This seems to be happening particularly if the new rows are added towards the bottom of the table. I cannot figure out why this is happening and there is plenty of space in the Word document for the new rows to appear. I have tried expanding the size of the table in Word and still no luck. Any assistance would be appreciated. Thank you.Customize theme fonts Word
I cannot set custom font sets/theme fonts as this feature seems to be missing in my version. See attached screenshot where I compare the option on my computer to option that is showed on an online support. As you can see I don't have the "Customize Fonts" feature button. I have a Mac and and Office 365. Grateful for help.
Switching off comment notifications in word documents
Hi - is it possible to turn off email notifications for replies to comments in a word document? We seem to get a notification about new comments every time the document is saved, and as Word autosaves, this is getting to be fairly frequent on large documents with lots of discussion! We actually don't need to be emailed at all so if there's a way to disable the notifications altogether that would be great.Access Abfrage Schaltfläche Ausführen! deaktiviert
Seit Tagen ärgere ich mich in Access über den folgenden Sachverhalt: Ich habe eine DB erstellt. Ich habe eine Abfrage über den Abfrageentwurf erstellt. Dies funktioniert korrekt. Wenn ich jedoch im Abfrageentwurf die Schaltfläche "Ausführen!" betätigen will, ist diese deaktiviert. Microsoft Support ist nicht in der Lage oder Willens diesen defect zu beheben. Ich habe dieses Problem schon in der Tech Community aufgeschaltet, erhielt die verschiedensten Antworten. Ich erhielt den Rat im untenstehenden HKEY die Anpassung vorzunehmen. Schon der der Ordner Access Connectivity etc. fehlt auf meinem Rechner... HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office[Version]\Access Connectivity Engine\Engines\SandBoxModeHave you ever wished Excel could calculate faster — maybe even use your GPU?
I’ve run into performance walls with large Excel spreadsheets — especially ones with complex formulas or large datasets. For example, dealing with time series of market data where they don't all have the same set of holidays and trading days. Even with only 20 years of daily data, having more than a few tickers can make changing one cell take 30 seconds while it all recalcs. I’m wondering if others have hit similar limits. - Have you ever wished Excel could use your GPU to speed up recalculation? - What kinds of sheets or formulas caused the slowdown? - Did you find any workarounds, or just live with it? I’m looking to hear what kinds of spreadsheets people struggle with most, and tips for how they got past them if they did.
Search for a date in a row does not work in VBA with ".find" when column is too narrow
I have a row with dates (row 3) and a cell with a date (C7) I want to get the column where this date (C7) is in that row3 This is my code: Sub find_date() Dim datum As Date Dim zoekrij As String Dim cel As Range datum = Range("C7").Value zoekrij = "A3:Z3" Set cel = Range(zoekrij).Find(DateValue(datum), LookIn:=xlValues, LookAt:=xlWhole) If Not cel Is Nothing Then MsgBox ("Date found in column: " & cel.Column) Else MsgBox ("Date not found") End If End Sub This works when the row 3 is formatted as date and the column is wide enough, but when the column is too narrow and shows "####" the date is not found. I also tried to use Clng(datum) and formatted the row as numeric, but with the same result (works only when column is wide enough)
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- We’re excited to introduce a wave of new capabilities that help you surface rich insights from your enterprise data and unlock new levels of productivity.Nov 21, 2025
- 3 MIN READMany of you have asked for the ability to choose the length and tone of your presentation. We listened!Nov 18, 2025
