excel
71 Topics[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.*Issue with viewing mode for E5 licensed users
I'm a sysadmin for a Health care provider in Sweden and we have an issue with users with an E5 license loading into Office apps in view-mode. As far as I know we are a coupe of organisations providing health care that have this same issue. Background: We have a mix of F3 and E5 licenses and sometimes the F3 licensed users need to view documents that contains info that isn't allowed to be saved in the cloud. To minimize the popups that show up when a user starts word unlicensed we have a GPO (viewer mode) that says that it should open i view-mode. Per my understanding this GPO is device based and not user based. However, this also affects the users of E5 license who regularly change workstations, easily 5-10 devices in a day. Since they should be able to view and edit documents in office apps it causes frustration and confusion when they load into view-mode and have to log out and then in again (or update license) and restart the program. Our computers devices are Microsoft Entra hybrid joined and shared computer licensing is enabled. Are there any solutions or viable workarounds for this issue? It's not complicated for users to handle but frustrating and causes a lot of tickets to the support team. Unsure if I'll be able to participate due to the time zone difference but will appreciate any and all help. /Per EkholmSSO issues in Word and Excel, but not Outlook
Hi, Strange issue started a month ago at a customer site. They use RDS with Office 365 installed. Historically this has been working fine, then it randomly stopped signing in properly for all users. We can't point it down to anything specific however. Network / User / Settings all look good. What is strange is on first login to Outlook, it says it's done SSO but says unlicensed. A simple restart then would show it licensed. We have managed to work round that issue by saving the license folder \appdata\local\microsoft\office\ to the UPD. So for this, a month ago, new and existing users would just sign in and it worked. Then something changed and users were being asked to sign in every time. So we have made this change to include \appdata\local to the UPD - now users only see this problem once (a month). While not as good as it was a month ago, it is acceptable. However, and this is what I need help with. SSO is NOT working at all from Word / Excel. Open Word Blank Micrsoft Sign In box pops up. You have to type username and hit enter You then have to type your password and hit Sign In That popup then goes away, but at the tope right of Word, it still shows "Sign In". When you go to Account, it still has a Sign in box. BUT... if you now close and reopen word, both of those show the signed in user. The problem here is that this doesn't persist over the UPD, so happens every time the users open Word or Excel. As this is used by a business app to open docs, it's actually breaking the process and we need to fix this. I have been having a look at SSO info, because it feels like something fairly low level has changed with how this works, but can't find anything helpful, hence posting here after about a month of searching and trying things. It's not very helpful when you have MS links like: How to use Remote Connectivity Analyzer to troubleshoot single sign-on issues for Microsoft 365, Azure, or Intune https://learn.microsoft.com/en-us/microsoft-365/troubleshoot/active-directory/single-sign-on-issues How to run Remote Connectivity Analyzer to test SSO authentication To run Remote Connectivity Analyzer to test SSO authentication, follow these steps: Open a web browser, and then browse to https://www.testconnectivity.microsoft.com/tests/SingleSignOn/input. However, that page just hangs with LOADING written on it. Then on the change notes for this page we see that it was removed in 2022! Version 4.0.15 (October 2022) Removed the Single Sign-on Test now that basic authentication in Exchange Online is being disabled. Quick note on the setup. AD is synced to Entra using Entra Connect (Password Hash Sync + SSO enabled), latest version. SSO URLs are added to Internet trusted sites as per setup instructions. Network has been tested and all URLS accessible and working for the user. User is on RDS on fully updated Server 2016 and is on the latest Office 365 app updates. So I guess my first question is: 1) Does SSO still work for Word and Excel? Is it a realistic expectation that the user will sign in to the PC and then Word and Excel will automatically sign in for the user (proper seamless single sign on) like it was doing only a month or so ago? 2) What can I do to test and troubleshoot this if it should be working? I have been trying for a month, so I have already tried a lot of things. But maybe I am missing some tests? Any info to help get this working again (or that it's no longer possible and we missed that instruction from MS) would be ideal. Thanks in advance8.4KViews0likes23CommentsWhen Excel couldn't save a file, 3E0CF950.MACTF was created, but where and by which program?
. Currently running: Mac OS 10.14.6 Excel with Office for Mac 2021 Manual copies to iCloud. Also running with Parallels Desktop: Windows 10 Excel with Office 365 for Windows Autosave copies to OneDrive. Hello, I would appreciate some assistance with an unusual problem involving Excel for Mac 2021 and possibly with Mac OS X, Excel for Windows 365, iCloud, and OneDrive. I generally create, edit, and save my workbooks using Excel for Mac and Excel for Windows 365 on the same file and never had any problem. After making edits to a workbook, I tried to save the file in Excel for Mac 2021. A message appeared saying that it could not save it due to some sharing violation. It did not specify the message's source, nor a directory path or the enclosing directory name to help locate the file. Instead, it instructed me to close the workbook without saving it and to access a file named 3E0CF950.MACTF, rename it and save it as a regular Excel file. Microsoft technical support instructed me to search at: /Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutroRecovery But the was no AutoRecovery directory. I also searched unsuccessfully on iCloud Drive and OneDrive, where I have autosave enabled when I edit my workbooks in Windows 10. I have also searched for it using Spotlight and the FIND command of the Finder with hidden files made visible. Nada. Although Microsoft tech support thinks that the file does not exist, however, I think it's unlikely that I would get a message so detailed to include the filename if none was created. A similar issue happened about a year ago before I had Excel for Windows installed. I was never able to find a resolution for it. Has anyone else experienced this? Before giving up, would anyone happen to know: Other locations to search on my Mac? A safe command line for Terminal to search more thoroughly? If Excel would create temp files with the ".MACTF" extension, or could this be a product of the Mac OS, iCloud or the OneDrive to which I enable autosave when I edit my Excel workbooks in WIndows? Whether the file name "3E0CF950.MACTF" ïs a random name, or is it a generic file name specific to my issue, and if so, what does it mean? If it's normal for Excel for Mac 2021 to lack an AuitoRecovery folder? Your kind assistance would be much appreciated. Please advise.17KViews0likes9CommentsNot so Dark theme
Is there something that can be edited or is an option coming to enable a more contrasting but less harsh theme to MS365 apps and Windows? As I’ve got older I need to turn down brightness because the extremes in the current themes, White, Black, Dark Grey, are too harsh, but that doesn’t quite achieve what I need. A light grey, giving better contrast than white for those that need it but not so harsh and depressing as the dark versions, would be ideal. We’re lacking options at the light end of the spectrumQuestion: Adding Undo and Redo Buttons to the Toolbar in Office 365 Apps
My Microsoft Office got updated today, I was taken to the Coming Soon section as soon as I opened it through a pop-up box and I updated to the new and refresh look of Office but what I found is the undo and button came to the ribbon. I could remove those buttons from ribbon but cannot figure out how to add them in the toolbar as depicted in the picture. Can anyone please help me?SolvedCan we configure filter for me in Office Online Server On-premise(Sharepoint)
We are using SharePoint Server 2019 along with Office Online Server (On-premise). Multiple users work on the same worksheet simultaneously. However, when one user applies a filter on sheet1, it affects all the users instead of being user- specific. Is there any workaround to make the filter apply only for individual users?