Forum Widgets
Latest Discussions
(Beta) Color issues with Dark Mode in Excel
I just downloaded the insider update that allows for a full dark mode in excel. A couple of things I've noticed: Black and white are inverted. If you select black for a font color, cell fill, or border color, you'll end up with white, and vice versa. If someone is in dark mode, they're going to get awfully confused when they try to change various colors of the cells they're working in and aren't getting the color they want to pick, especially for those who need to use specific colors in their spreadsheets for whatever reason. This isn't so bad with black and white; annoying as it is, you can still at least remember to choose black when you need white or white when you need black. But when you choose other colors, you often end up with a color that is vaguely in the family of the color you selected, but not really. Trying to select the standard yellow used for highlighting, and you end up with an almost pale gold-like color. An example of what happens with a few colors is shown in the picture, but every color is affected to some degree. This makes the dark mode feature almost entirely useless for those who rely on colored conditional formatting in some or all of their spreadsheets, as the colors selected in dark mode end up being completely different from the color you actually wanted to select, and it's nearly impossible to try to figure out which color you have to select to get something that even resembles the color you actually want. The colors of individual elements of a spreadsheet (Font color, highlighting, borders, etc.) should not be altered this severely based on whether or not dark mode is turned on.
GROUPBY aggregating more than one column of data
In the early versions of Excel beta, we were able to create a formula like this: =GROUPBY(Table[Code], Table[[Duration]:[Expense]], SUM, 3) and this worked just fine. But now, the lambda SUM function is coming up with a #NAME error, even when I use the formula builder. Excel version: Microsoft Excel for Microsoft 365 MSO (Version 2404 Build 16.0.17521.20000) 64-bit Example attached.
KeyTips now available in Office for Mac
Microsoft 365 Insiders, Happy Friday! Great news for Office for Mac users! KeyTip support is finally coming to Office for Mac, enhancing navigation and boosting productivity. Want to learn more about these popular keyboard shortcuts? Check out our latest blog post by Hugo Garcia, Product Manager on the Microsoft 365 team: KeyTips now available in Office for Mac KeyTips in Office for Mac are now available to Microsoft 365 Insiders, and they’ll be available to all Office for Mac users in the coming months. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | AndroidNew Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE
Hey Microsoft 365 Insiders, Great news for Excel enthusiasts! Excel now includes powerful translation functions, allowing you to translate and detect languages directly within your spreadsheets. The new TRANSLATE and DETECTLANGUAGE functions help break down language barriers, making your data more accessible and your workflow smoother. Discover how it works in our latest blog post by Gedion Alemayehu, Product Manager on the Excel team: New Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE NOTE: These are preview functions. Their signature and results may change substantially before being broadly released, based on your feedback. So, we do not recommend using these functions in important workbooks until they are generally available. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
PPT Presenter View preview slide not keeping up
Hi all, I'm trying to use Powerpoint to project supertitles (captions) live for an opera on a Macbook. Been a while since I've used the software and the current version of presenter mode is giving us some issues. We've got the current slide in the top left, the next slide in the top right and that's all great. Then we have the preview of the current slide at the bottom and every time we go to the next slide it's doing this sliding motion to the next slide even thought the slide show itself has no transitions. The slides at the top work the same as the slide show so we can work with it but it's a kind of really distracting having the slides at the bottom get way behind and glitch out because we're flying through some of these slides. Does anyone know a way to hide the bottom preview or disable the timing on it so it just snaps to the next slide like the actual slide show does? All timings of everything are disabled and set to manual or zero. I just can't find any option regarding that section of the Presenter View. TIA.Beta 2502. Issues with files from the internet, mail, etc.
When I try to open a Docx or Docm file that originated from the internet, I get the attached message and the file does not open. So far, I have only encountered this behavior with Docm files, which then open with a red warning bar but can still be edited with macros disabled. I have not seen this before with Docx files. The message is also misleading because it does not indicate the ZoneIdentifier, but rather implies that there are no file permissions. This is misleading and completely unnecessary for Docx files since there is no security issue involved. For DOCM files, neither a certificate nor listing as a trusted publisher helps.
Office Beta Channel Version 2502 Build 18516.20000
My beta channel Office suite updated to Version 2502 Build 18516.20000 this morning, and now Outlook crashes any time I select an email or open a calendar object. Not even opening the email, just selecting it crashes. Even when opening up in Safe Mode. I've also performed Quick Repair and Full Online Repair with no change in behaviour. In Word, just opening a document crashes out as well. Faulting application name: OUTLOOK.EXE, version: 16.0.18516.20000, time stamp: 0x6789eeaa Faulting module name: wwlib.dll, version: 16.0.18516.20000, time stamp: 0x6789ef67 Exception code: 0xc0000005 Fault offset: 0x0000000000342823 Faulting process id: 0x8220 Faulting application start time: 0x1DB6CF4DBDD3639 Faulting application path: C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE Faulting module path: C:\Program Files\Microsoft Office\root\Office16\wwlib.dll Report Id: aac213cd-b3fa-491c-950c-a7d2037d5e68 Faulting package full name: Faulting package-relative application ID: Faulting application name: WINWORD.EXE, version: 16.0.18516.20000, time stamp: 0x6789f0d8 Faulting module name: wwlib.dll, version: 16.0.18516.20000, time stamp: 0x6789ef67 Exception code: 0xc0000005 Fault offset: 0x0000000000342823 Faulting process id: 0x7AE8 Faulting application start time: 0x1DB6CF52B1B34CD Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\WINWORD.EXE Faulting module path: C:\Program Files\Microsoft Office\Root\Office16\wwlib.dll Report Id: 871a616d-7e30-4fac-8aae-19cf4a537e16 Faulting package full name: Faulting package-relative application ID:Transform photos with Restyle Image in Microsoft Designer
2/2/2025 UPDATE: The Microsoft Designer feature Restyle image is no longer available. Hello, Microsoft 365 Insiders, Unleash your creativity with the new Restyle Image feature in Microsoft Designer! Using this new feature, transform your photos into stunning, stylized images with just a few clicks. Explore this new feature and share your thoughts with us in our latest blog: Transform photos with Restyle Image in Microsoft Designer Thanks! Perry Sjogren Microsoft 365 Insider Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
