Conditional formatting
I'm making a rule to Highlight cells in Column AZ when the value is lower than Adjacent cells in Column P. For the most part it works except for two cells in AZ (1 shown as an example) that are higher than P but are being picked up by the conditional formatting. The two cells I'm focusing on here are P14 (£0.27) and AZ14 (£0.43). £0.43 should not be being highlighted pink as it isn't lower than £0.27. This has to be something obvious but I have looked at it too long. Please help if you can :)
SharePoint user adds random metadata to files
I have a SharePoint Library where we add procedures and documents. There is relevant metadata included (Owner, modified date, keywords, department, etc.), but for one individual contributor, every time she uploads it places oddly specific default values in these metadata fields. I have confirmed on the library settings that there are no column defaults (In this folder or the root folder) and the problem does not occur with any other user. We did have her clear cache and log out and back in, but she is still the only user with this problem. What are we missing?
OneDrive just opens JPG files others get error 0x80070185 cloud operation was unsuccessful
Hello everyone, we have a problem on a Windows Server 2022 RDS Server with OneDrive. I can login to OneDrive and see all my files. When I try to open the files (e.g. PDF/Word/TXT) I get an error 0x80070185 the cloud operation was unsuccessful When I try to open JPG files its working. I can create folders and move files to this folder. The sync to my local notebook is ok. I tried to reset OneDrive, no success I installed the latest version of OneDrive, we checked the firewall (sophos) no blocked connections, we disabled the local AV software (sophos) to make sure it does not block anything, no success. I reset OneDrive, deleted the App Data folder for OneDrive, deleted the OneDrive folder within my User Account. It is still the same situation, login works I can see all my files and folders I can open JPG files but now word or PDF documents. I can create new folders and TXT files, fill them with content and its synced to OneDrive. Suggested solutions found on the internet are all the same, using reset onedrive and re/install latest version. We had version 26.119.0622.0003 and updated to 26.145.0728.0011 Has anybody another solution for that? Best regards
OneDrive from Windows Server 2025 for remote users
I have a client that, when I started working with them, had a small staff that kept regular business hours. I set them up with a Windows Server with Active Directory and File and Print Services as well as secure internet access. Over the years, the staff has gotten smaller, and currently consists of the two partners who split their time between working in the office on workstations on their domain and from remote locations on laptop computers connected via WiFi or their cellular provider to the internet. Previously, I had their workstations using OneDrive to store the contents of the server's shared volumes in the cloud so they could be accessed from their laptops. Unfortunately, this didn't work very well presumably because the workstations in the office had to be on in order to update the contents in OneDrive. I upgraded their server to Windows Server 2025 and created an account for the server to directly use OneDrive to store the contents of its shared volumes, and shared those resources in OneDrive with the partners' laptops. Since the server is always on, I presumed that OneDrive would stay up to date. Unfortunately, the shared volumes in OneDrive are still not up to date with the contents of those volumes on the server. What am I missing? Can someone explain the nuts and bolts to me so I can compare them with what I've already done, so I can fix this lag?
Sketchy behaviour from Microsoft on MFA - what gives?
Recently, Microsoft has overwritten our Authentication Method Registration campaign settings, from 'Disabled' to 'Microsoft Managed' for dozens of tenants. Thanks guys. That's not super sketchy at all. /s This was ostensibly done for the Retiring of Voice and SMS based MFA or, as the article puts it 'To help enterprises adopt AI at scale,'.... what? Not because they're garbage MFA methods? But so Microsoft can market-capture MFA? Regardless of that bizarre statement, this article is sub par - like most Microsoft 'help' docs, it appears to have been written by someone in Marketing, with no technical experience. My chief concern is that the term 'OTP' doesn't appear ANYWHERE in here. So, for us and our customers - who block Voice/SMS already - this is alarming. Microsoft's Passkey flow is confusing af to people - and since it includes SYNCED passkeys by default, it faces the same risks as OTP. We specifically HAVEN'T rolled out passkeys because everytime we do, people get confused and frustrated - because they'll have 3-4 different things pop-up, offering to take a sync'd passkey. Really concerned with my 'do not allow microsoft to manage' setting, being explicitly set to 'Microsoft managed', and whatever decisions they're NOT publicly addressing at this point. We've spent years teaching people to use Microsoft Authenticator and password vault-based OTP. Now, Microsoft is pushing everyone to keep using those same tools, but to go through the mess that is the passkey setup interface?
Microsoft Sign In Loop
I am trying to sing into Microsoft 365, but every time I do, it takes me back to the login screen. I sing in with my outlook account, but I can't reach the applications. I can sign in on the browser, but not the applications on my computer. I have tried uninstalling and reinstalling M365, but the issue still persists
I Can't get Microsoft's help
Why is it that it is so difficult to get Microsoft to help me access my account? I have been trying for a few months now and have not had any issues resolved. I can no longer access some of my accounts. My Authenticator app on my iphone is asking for a code from my Authenticator app which is circular reasoning. This is impossible. I have also tried to call Microsoft multiple times but their automated system hangs up on me because they are experimenting technical issues. We'll, guess what! I'M HAVING TECHNICAL ISSUES AS WELL.. I'm hoping someone from Microsoft well see this and reach out. I need to log into my new PC I purchased and I can't.[Community tool] Find the GPO, registry value and Intune setting for any Office ribbon button
Hi everyone, as a technical service owner for Microsoft 365 Apps, one question comes up for me again and again: which policy actually controls this button or option? The information is all there – in the Office ADMX/ADML templates, the Office Fluent UI control ID lists, the Intune Settings Catalog and many Learn articles. But I never found it in one place, so every answer meant connecting several sources by hand. Especially when onboarding new colleagues, this costs a lot of time. So I built a free community tool for it: Office Admin Explorer https://tools.pascal-donath.de/office-admin-explorer/ How it works It's a clickable mock of Word, Excel, PowerPoint and Outlook (ribbon, File menu, Options, Trust Center). Click any element and you get: idMso and Policy ID (for customUI and the "Disable commands" policy) the ADMX policy with its exact path in Group Policy Management the registry value it writes, with ready-to-copy PowerShell or .reg the matching Intune Settings Catalog entry Cloud Policy notes, step-by-step guides and Microsoft Learn links The search covers all Office ADMX policies (2,400+) and command IDs (8,000+), including elements that aren't part of the mock. Also included Ribbon builder – hide or disable buttons, groups or tabs and export the result as customUI XML, a macro-free add-in (.dotx / .xlam / .ppam) or the "Disable commands" policy for Group Policy and Intune Deployment view – configuration.xml generator for the Office Deployment Tool User Support view – typical user problems: symptom → cause → fix Policy names and registry values are checked against Microsoft's ADMX/ADML files, and the Intune mapping against the Graph settings catalog. It runs in the browser without sign-in and is available in English and German. Please test any configuration on a lab device or pilot group first. I'd like your input How do you handle this today – ADMX search, Group Policy Search, the Intune catalog, your own documentation? Which Office settings do you get asked about most often? I'd like to add the most requested ones next. If you find a wrong or outdated entry, every entry has a "Report it on GitHub" link – corrections are very welcome. Thanks! Pascal --- *Transparency note: The tool was developed with the help of AI. The content is based on my own admin experience, and policy names, registry values and Intune mappings are validated automatically against Microsoft's official sources (ADMX/ADML templates, Fluent UI control lists, Microsoft Graph settings catalog). This is a community project and not affiliated with Microsoft.*
