Chart from dynamic array challenge
Hi (Excel 365 v2512 b19530.20144 Current Channel / Windows 11 25H2) Charts are definitively not my thing. Spent hours on the following, searching, testing… to no available The below chart data range is a dynamic array (could be wrong for the desired chart) - named GRAPH_Series on sheet GRAPH_Ranges - similar to the array on the left side of the pic. The arrays dynamically resize according to the 'START Year' & 'TOPN Cat' variables - so far so good Setting the Chart data range as =GRAPH_Ranges!GRAPH_Series and changing nothing else, the chart updates as expected according to 'START Year' & 'TOPN Cat'. On the other hand if I change anything in the Select Data Source dialog box the chart won't update properly anymore The expected chart is the same as above with 2020, 2021...2025 (instead of 1, 2,...6) horizontally & D, F, B, A as legend Thanks & any question please let me know Lz.
Excel pads dynamic array output with #NV values
I have come across a couple of instances, where Excel 365 pads the output (of lambdas) or in this case of a specific formula within a lambda with #NV values (or errors if you like to treat them so.) The following snippet: = LAMBDA(assemblyName; LET( filteredParams; {"a";"b";"c"}; mappedValues; {1;2;3}; transposed; MTRANS(HSTAPELN(filteredParams; mappedValues)); return; WENN(filteredParams = ""; "NV"; transposed); return ))("fake") Gives me the following output: a b c 1 2 3 #NV #NV #NV At the same time, the following slightly different code (letting alone the output of WENN): = LAMBDA(assemblyName; LET( filteredParams; {"a";"b";"c"}; mappedValues; {1;2;3}; transposed; MTRANS(HSTAPELN(filteredParams; mappedValues)); return; WENN(filteredParams = ""; "NV"; transposed); transposed ))("fake") Spits out: a b c 1 2 3 This is not the only case, but is the simpliest, I can reconstruct this kind of error with. Do not mind the logic, it is an edited excerpt, just for illustration. P. S. It is German syntax. English would have TRANSPOSE, HSTACK, IF,... instead. Maybe a little difference in punctuation.
Slow UI update for deleted events
I've built an integration that continuously syncs events between an external scheduling system and Exchange Online using Microsoft Graph. I'm observing a recurring issue when deleting calendar events via Graph: A DELETE request to Graph returns success (204 No Content). A subsequent GET /events/{id} returns 404, confirming the event is deleted server-side. However, the event continues to appear in the Outlook UI (both Outlook Web and desktop) for an extended period (sometimes hours), even after page reloads or app restarts. The odd behaviour The event is still displayed in the user interface for up to several hours The event persist through page reloads If the user clicks the event it opens briefly and immediately closes, the event disappears from the UI afterward. Additional details Delete endpoint: /users/{id}/events/{id} Graph response: 204 No Content Verified deletion via GET → 404 Reproduces in both Outlook Web and Outlook desktop Questions Is this a known Outlook client caching or calendar view indexing issue? Is there a way to force client reconciliation after deletes? Are there Graph or Exchange constraints around rapid create/update/delete cycles that could cause this UI inconsistency?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
Corrupted VT+ transaction files
We are a small accounting company using VT+ Transaction on a local drive synchronized with OneDrive for backup and file storage. A few days ago when we tried to open the application, we suddenly started receiving the following error messages: Run Time Error 0 and Run Time Error 440, and the program does not start. According to VT+ support the program files are corrupted and the data can only be restored up to the year 2022, as the more recent backups are also affected. Somehow the system is overriding our backups, which makes the latest ones unusable. Any advice what could cause that and how to resolve the issue. Thanks
Autocomplete not working
I have Microsoft 365 Version 2512: January 13, which is the latest update. I am operating Windows 11 Home Version 25H2. When I try to use the autocomplete facility in Excel it does not work. The 'Enable autocomplete for cell values' tick box & the one below in File; Options; Advanced are both ticked. I have tried this in all existing worksheets and IMPORTANTLY in a new blank worksheet. I have asked a friend to try it on his Windows 11 laptop with the same Excel and his does not work on his either. HOWEVER, it does work on my MacBook which is operating system Monterey Ver 12.7.6 & Excel Version16.89, which is an older version. There it works in both a new blank worksheet AND also if I copy the relevant file and paste into the Apple iOS system. I have posted questions on Q&A but have not had any response that indicates a valid reason for the problem or more importantly how to solve it. I would obviously like to speak to someone but I think this is likely to be impossible. It appears that autocomplete does not function in Excel in Windows 11? Can someone help?Outlook changing styles/colors of incoming email?
HI friends - I recently got an email from a research org named ORCid and I noted when I received the email that it was hard to read - the text was a lightt grey on white, or light grey on dark grey in dark mode: I emailed ORCid back and explained that this was going to fail any WCAG/Accessibility checks, and could they take a look. I spoke back and forth with their internal developer who insisted that it didnt look like that on being sent - he sent me examples from his own inbox as proof: And these look perfectly fine. Weirdly - when I forwarded this email to a colleague, they showed me on their screen it appeared as intended with the tetxt darker and more legible. They forwarded it back to me - and surely enough, it looks correct. This using the Outlook desktop app in both old and new mode - and dark or light profile - and also in the web outlook as well. Im really confused as to how/why when I receive it the first time it looks so unreadable? Any advice would be awesome.Organizing email account folders on PC
Since updating to the new Outlook, I am not able (on my PC or Mac) to drag and drop account folders to arrange them in a priority fashion. I have downloaded the classic version again, but the new version opens up anyway. I have tried on the app AND using a browser. Any help is GREATLY appreciated. I don't know if I am just not doing something correctly, or if that function is not available, except on my mobile devices. TYIAFeedback to users who report phishing
Hi, is it possible to create a power automate flow to find submissions from users and as soon as MS has added a verdict to a submission as real phish send a notification back to the user who has reported it? Trying to figure out what is needed for such integration and build a flow but I am stuck. Anyone who has built that and like to share learning?
