Multi-line Text Box misleading text and cursor display
Starting with 365 Version 2603 on 4K monitor, in a multi-line text box, typing multiple words followed by line feeds (Enter key) then moving cursor back up to previous line causes trailing characters to disappear, entering characters at the end of the line shows the new character with the cursor in front of it, and other bizarre behavior. Selecting all the text shows it is all there but trailing characters at the end of a line can disappear depending on cursor position. If I change the monitor resolution to 2K, the issue goes away. If I rollback to version 2602 the issue goes away. This is an issue with version 2603 on 4K monitors. We have many customers reporting the same issue.
Upgrading 365 Personal bought from Google Play
I previously bought OneDrive 365 Personal from the Google App Store and now want to upgrade to 365 Family purchased from Microsoft (to take advantage of the Workplace Discount Programme available from my employer). It seems that I can't do a simple upgrade however - Microsoft Support states If you bought Personal via Apple/Google Play, cancel it there first and wait for it to expire before purchasing the Family plan on the web. How can I do this without losing the 800gb of photos and files currently saved on OneDrive?
OneDrive personal account not signing in 0x800704cf
OneDrive app (Windows 11) personal account has stopped working. Stuck on signing in. After unlinking PC and attempting to sign in again as part of troubleshooting it comes up with a message about not being connected to the internet. 0x800704cf. But the sign in works on a business account on the same PC. Does anyone have a fix? I have tried the following: restarting OneDrive reinstalling OneDrive clearing cahed credentials reseting OneDrive firewall/antivirus disable check check date and time settings web sign in worksMicrosoft Excel Update Changed Formula
I've used Excel for the last 2-3 years to track changes in a sheet by month the data listed is added or changed. The formula I've used worked fine until today, when I started receiving an _xlfn in the formula. It now reads as follows: =IF(ISBLANK($A6),$A2,IF((_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0))>=$A$2,_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0),"")) My goal was to have Excel look if there were updated values in D6 and enter the most recent date associated with that value from A6 to A41. Does Excel no longer support MAXIFS?Increasing Microsoft Graph Per-Mailbox Throttling Limits (PUT/POST/PATCH & Concurrency)
I am referring to the per-mailbox throttling limits documented here: https://learn.microsoft.com/en-us/graph/throttling-limits#limits-per-mailbox Specifically: 150 MB limit for PUT/POST/PATCH requests within a 5-minute window 4 concurrent requests per mailbox In a multi-tenant SaaS application scenario, these limits can become restrictive when processing large volumes of mailbox data. I would like clarification on the following: Is it possible to request an increase in these per-mailbox limits through Microsoft (e.g., via support or a formal quota increase request)? Are there recommended architectural patterns or best practices to efficiently handle high-throughput scenarios while staying within these limits? Can tenant administrators (our customers) configure or influence these limits through Microsoft 365 admin settings? Any official guidance or recommendations would be highly appreciatedHelp with Excel pop out window
I found a free spreadsheet online that I wanted to use. I am able to manipulated it for my use case. But the original creator added these call out fields that I cannot seem to find out how to delete or change the syntax. I can't even find out what they are called. Any suggestions?? In the attachment, I select a filed and a little yellow box pops up. How do I change or delete these??
Edge Browser Control stealing Focus
I am facing an issue with the Microsoft Access Edge (WebView2) browser control in VBA Office 365. I have two forms displayed side by side: The first form contains a grid/list of records. The second form contains an Edge browser control that loads an HTML file. When a record is selected (or navigated using arrow keys) in the grid, I dynamically delete and recreate an HTML file with details of the selected record, and then call the Edge browser control’s Navigate method to load that file. The problem is: Arrow key navigation works correctly in the grid when the Edge browser control is not used. Once I add the Edge browser Navigate call, the browser control takes focus. After that, arrow key navigation in the grid stops working because focus shifts to the browser. Attempts to manually set focus back to the grid (SetFocus, timers, etc.) are not reliable. Tried this in documentcomplete event also, but not working. The issue seems to be related to the asynchronous behavior of the Edge browser control, which keeps reclaiming focus. What is the best way to reliably prevent or reclaim focus from the Edge browser control so that keyboard navigation in the grid continues to work smoothly?
Printing/exporting messes up the document
I have a 67-page document with a lot of pictures too, and I use multilevel headings. When I try to print or export to .pdf, it messes up the whole document, I have now 102 pages, sometimes 92, the approx. 5000 word count is now 7000, and the order of the headings is messed up, so some parts of the document are moved across the document. What on Earth is this? I changed all the fonts to Arial. Tried every kind of printing setting. Nothing works.
Look up two parts of a string in a cell
Hello All, I know all about the XLOOKUP() but at times I need a special type of a look up. if I have a cell with the text “Apples and Oranges” how can I write an XLOOKUP to evaluate the “Apples” and then evaluate the “Oranges” parts. for example if I have a list of fruits in a column, then in the next column I have true if the fruit has seeds and false if the fruit does not have seeds. now normally the XLOOKUP will look for the whole string, so if there is no fruit called “Apples and Oranges” it will fail and not return anything. But I do have “Apples” in one cell and it has true for having seeds, AND I do have “Oranges” and it has false for seeds (these are Naval oranges 🤪) so the XLOOKUP will not return false. how can I write an XLOOKUP to return “Apples”, “Oranges”, AND “Apples and Oranges”? I thought of replacing the part after the And but then I’ll lose the fine parts, then I tried splitting the string on “AND” and that did not work at all. I guess you can’t run an XLOOKUP on an array part??? any help will be greatly appreciated!VBA concern: support for macros or controls not installed
Background: installed Zotero, a citation manager, to use on Word but it uses macros My Word doesn't seem to have VBA installed. Every time I open the app, error boxes appear. Screenshotted below: I have tried a few things to fix this but without benefit: Macros enabled in the trust centre VBA enabled in the trust centre Rapid and online repair completed I have attempted to 'change' the program in the Control Panel in order to access the 'expand/add features' option but this does not exist as an option for me. When I press 'change' only repair options appear for me. Screenshotted below: My impression is that somehow VBA was not installed when I downloaded Office form my account. I appreciate VBA is downloaded automatically but this has not been the case for me. Please advise on next steps. Thanks in advance.
