Recent Discussions
Date entered is changed to a different date
This issue has just started as far as I can tell. On an existing worksheet with the column formated to "date" 01/01/2025 format - when I enter a date of 01/01/2025 as for an example and hit "enter", the date is changed to 10/29/70! If I enter a date of 01/19/2026 it is changed to 08/27/63! and so on,..... it changes the field every time. if I enter those same dates by physically entering 01 slash 19 slash 2026 slash it will stay as I typed it - and will look like 01/19/2026 (or 01 slash 01 slash 2025) My husband is able to create a spreadsheet on his laptop that works correctly. When he sent it to me, the date fields did what I have stated above. So there must be something corrupt on my laptop? or Excel? I am running on the latest build (to my knowledge) Anyone? I am at a loss.. When entering a lot of data and dates - this is a real PIA. Plus - it was working just fiine - not sure what has changed. Thank you
Python in Excel is enabled but the runtime never downloaded
Hi, Python in Excel is enabled but the runtime never downloaded. Excel returns `/app/officepy/bin/python`, but the runtime folder is missing and HTTPS fails inside the sandbox. This is the ghost-runtime state. Please escalate to the Office engineering team to reset rollout flags and push the runtime package to my device. Excel build: 16.0.17231.20182 (Current Channel) ODT repair: fails with “couldn’t install” AppContainer: registered but empty Runtime folder: missing under %LOCALAPPDATA%\Microsoft\Office HTTPS: 400 errors inside Python sandbox I tried everything possible with Co-pilot's help. I tried reinstalling office full repair and ODT reinstall attempted. The runtime package never downloads. Apparently, This requires a rollout flag reset. Please help thanksHow Do I Target the Azure VPN Client in a Conditional Access Policy?
I am using the Azure VPN Client to connect users to an Azure VPN Gateway using their Entra ID credentials to authenticate. I want to target this application with a CA policy that requires MFA every time it connects. The problem is that I don't see the applications in my Enterprise Apps and all of my searching says that it won't appear because it was "pre-certified" by Microsoft. In the Gateway setup I used the Audience GUID of c632b3df-fb67-4d84-bdcf-b95ad541b5c8. And this is working as expected. The only solution that I have found for targeting the Azure VPN Client app is to create a Service Principal using that Audience GUID. This seems like a bit of a hack, so I am posting here to see if there are any other methods that I am missing to target this app when it doesn't appear in my Enterprise Apps list.
msoFileDialogFolderPicker compiler error
I have searched the net and not seen this issue. I developed a stand alone program in Excel Vba using msoFileDialogFolderPicker. It runs no problem. The function is as follows: Function PickFolder() As String With Application.FileDialog(msoFileDialogFolderPicker) If .Show = -1 Then PickFolder = .SelectedItems(1) End With End Function This was then added to a larger program with exactly the same code on the same PC and I get 'compile error' variable not found with 'msoFileDialogFolderPicker' highlighted.Excel Challenge - Pivoting poorly structured data
This is from an ExcelBI challenge. I thought it may be worth while posting my solution here as a demonstration of modern Excel methods. Challenge Like many of such challenges, the natural solution approach is to use BYROW but that creates the usual 'array of arrays' error. Solution: Gradually I am moving to a point at which I have no formulas showing in the workbook other than calls to Lambda functions. In this case, the worksheet formuloa is = PIVOTBYCATEGORYλ(OrderTbl) The function works row by row apportioning the amounts against the listed categories PIVOTBYCATEGORYλ // Groups and pivots table by category = LAMBDA(table, LET( normalised, BYROWλ(table, APPORTIONλ), // Identify fields from normalised table dimension, TAKE(DROP(normalised,,1),,2), category, TAKE(normalised,,1), partCost, TAKE(normalised,,-1), // Pivot by category return, PIVOTBY(dimension, category, partCost, SUM,,0,,0), return ) ); The function APPORTIONλ divides the amount between categories so each record within the source data returns a number of rows APPORTIONλ // Splits by category and assigns costs = LAMBDA(record, LET( category, TOCOL(REGEXEXTRACT(INDEX(record,4),"\w+",1)), amount, INDEX(record,3) / COUNTA(category), year, YEAR(INDEX(record,1)), region, IF(LEN(INDEX(record, 2)), INDEX(record, 2), "Unknown"), broadcast, B∕CASTλ(HSTACK(region, year, amount), category), return, HSTACK(category, broadcast), return ) ); /* FUNCTION NAME: B∕CASTλ DESCRIPTION: Broadcasts the terms of a vector over the shape of a second array */ B∕CASTλ = LAMBDA(vector, array, IF({1}, vector, array)); The key to making the formula work is the function BYROWλ that I wrote to generalise the inbuilt but over-restrictive BYROW function. The PIVOTBY function returned the required crosstab from the normalised data array
Microsoft Places desk declined despite check-in
Each We've just started using Places in our office and a few users have reported recieving a desk decline email due to no check-in on the desk, despite them using the check-in button on the Places app to check-in on arrival to the office. Has anyone seen this previously? Each desk has two monitors, which I have associated with the desks in the Teams Pro Management portal to enable detection and check-in. Reservation settings for all desks are as below.How to Create SharePoint Sites with the Graph API
Microsoft released the beta version of the SharePoint Online create Site API for the Microsoft Graph in late November 2025. Since then, Microsoft has dropped one of the three site templates. Playing with the API, we’ve discovered that the API can certainly create sites but that the SharePoint Graph API misses a heap of features, like adding members to the new site. Oh well, one step forward… https://office365itpros.com/2026/01/19/create-site-api-spo/Issue with Outlook (Microsoft 365)
Hello. I've an issue with Outlook when it's synchronising with server (receiving with pop.proximus.be). When I do Send/Receive, I show the mails but the synchronisation never finishes. It's stay blocking at last mail. However, I can see others mails synchronized and can open open them. I recreate my profile without success. What do you suggest ? ThanksCurrent Date and time per cell
I have a table with one column listing rows with a dynamic text box (open; closed) in the next column I would like to display the date and time when the status changes. The purpose is to show when a task was completed, I have used the now() function but it keeps refreshing, I need it stay the date The snip of the sheet below shows how is is currently working, so can any one help with some code for column J please. thank you LeeWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Hyperlinks not working on Macbook air
I have had an issue with permissions for accessing files with excel, in my Macbook Air (Apple M4 - Tahoe 26.2) for almost a year now. When I insert a link to a pdf and then I try and open the link, excel does one of three things. It either warns me that some files may have viruses etc etc and when I click open it opens the file it tells me that opening the file may cause issues etc etc and when I choose to open the file, it goes into the message above (1) and eventually opens the file it asks me to grant access to the file and it shows the file path and I need to click select, then it goes to the folder where the pdf is located and I need to click grant access - but when I do, it says that the file cannot be opened. I have gone into my system settings and excel has access to my full disk and files and folders. I have googled the issue and it was suggested to give excel access to the particular folder where the files are located but I don't know how to do this, other than in system settings. I have tried clicking on the folder where the files are located when option 3 above has come up but when I click on the folder, the grant access button at the bottom is greyed out. Can someone please suggest something, as it is driving me crazy now. I have inserted the links through the 'insert', 'add a link' button on the excel menu. Thanks.
Those 'annoying' page breaks
I use Word, as well as other programs, to put the final polish on my manuscripts. I am considering changing publishers, and one of the candidates wants me to use page breaks only on chapter ends. Is there any way that I can tell Word 365 (Win 11 Pro) to let me put the breaks in where I want them? This would also mean finding a way to suppress the automatic page breaks. Is this even possible, and if so, how do you do it? Regards Jo
Autosave makes Excel unresponsive every 2 mins
I have a XLSB file about 1MB in size. It is stored in OneDrive. AutoSave is ON. If I work with it (change data, apply filters, change tabs) - everything is fast. But as soon as I stop (sometimes I have to think about my next move). After about 5 seconds of inactivity - I see the blue circle spinning, Saving... words in the Excel title bar. Excel is frozen for the next 5 seconds. I get it. It is syncing my recent changes to the cloud. But hey... I am trying to work here... It is very disturbing to see the application frozen. And it is happening often. Like pretty much every time I stop making changes to Excel file. If I turn off AutoSave - then no issue. But I like AutoSave. If I could control how often it syncs it to the cloud. I've tried changing Excel Options in the Save section. Like Save AutoRecover Information every XX minutes. It does not seemed to effect how often the AutoSave is triggered. Any advice is very much appreciated.
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- 4 MIN READClipchamp reached new levels of innovation and enabled increased productivity in 2025!Jan 16, 2026
- There are now two faster, more intuitive ways to bring text-based data directly into Excel.Jan 15, 2026
