Question: 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?When 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.
SSO 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 advance
Office versions - MSI and C2R
Hi, In my organization some users have Office C2R and others have MSI (Office 2016 ProPlus). Is there a way to see if the current build of the MSI is a match to the current version of C2R? I cannot figure out how to accurately compare these since C2R is at version 18xx and the MSI is version 16 build 16.0.4738.1000. Are these two a match, or do they differ in how many features they've received in the updates?Excel 2016 OfficeJs Task Pane Add-in error “can't connect to catalog”
I have a user that purchased an Excel 2016 Add-in from the Office Store/App Source thinking he could install it on Office/Excel 2013. The purchase was successful but he could not not install and load it in the Excel 2013 client. That makes sense. But... After, he upgraded/installed Office 2016 and then when he inserts the add-in the Task Pane opens but he gets the message: "can’t load this add-in because we couldn’t connect to the catalog" The OS is Windows 10 and the issue occurs in both the Excel 2016 client and in Excel Online in Chromse and Edge (and I think IE). Tried clearing browser cache etc and also tried the "Clear" button under File-> Options -> Trust Center -> Trusted Add-in Catalogs. I think the add-in is in a invalid state because he can install and load other add-ins in the Task Pane that are both for trial and purchase without a problem. Also, I verified that the add-in was in the user's purchased list in his Microsoft Account profile. Any ideas would be great, including how to get the add-in out of this state because he did purchase it and now it can't even load.
In get data section is Oracle database option lost
Hi! I use Microsoft 365 Apps for business. In here I always had option to get data from Oracle database. But last couple of months I haven't had that option in databases list to get data from Oracle database. Why this option/possibility has lost and how I could get it back? For example in PowerBi I still have that option/possibility in the list. BR Elar
Need help with an error: unhandled exception by an external application
Hello, I am really hoping someone here will be able to offer some help. when I run a specific macro (an HPC macro), Excel is throwing up the following error. Does anyone have any idea what this means? I am trying to submit a computation job to HPC application (HPC server 2012 R2) and this was working fine until recently. Feedback Type: Frown (Error) Timestamp: 2017-08-22T10:45:05.9293108Z Local Time: 2017-08-22T11:45:05.9293108+01:00 Product Version: 2.42.4611.241 (PQ-CY17SU01) (x86) Release: January 2017 Excel Version: 16.0.7766.2099 Excel Install Location: C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE IE Version: 11.953.14393.0 OS Version: Microsoft Windows NT 10.0.14393.0 (x64 en-US) CLR Version: 4.6.2. or later [Release Number = 394802] Workbook Package Info: 1* - en-GB, fastCombine: Disabled. Peak Working Set: 293 MB Private Memory: 204 MB Peak Virtual Memory: 1.06 GB Error Message: External component has thrown an exception. Error Code: -2147467259 (0x80004005) Stack Trace: System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception. at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2R.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.TryGetTaskPaneControl(NativeTaskPaneType type, IntPtr uiFrame, TaskPaneControl& taskPaneControl) at Microsoft.Mashup.Client.Excel.Shim.NativeTaskPaneServices.NativeTaskPane.get_ContentControl() at Microsoft.Mashup.Client.Excel.Shim.NativeTaskPaneServices.TryGetCustomTaskPane(TaskPaneType taskPaneType, ExcelWindowId excelWindowId, ITaskPane& taskPane) at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.TryGetCustomTaskPane(ExcelWindowId windowId, ITaskPane& taskPane) at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.TryGetTaskPaneControl[T](ExcelWindowId windowId, T& taskPaneControl) at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.OnWindowDeactivate(IWindowContext windowContext) at Microsoft.Mashup.Client.Excel.CustomTaskPaneManagers.OnWindowDeactivate(IWindowContext windowContext) at Microsoft.Mashup.Client.Excel.NativeEventHandler.<>c__DisplayClass1d.<OnWindowDeactivate>b__1c() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace) at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Client.Excel.NativeEventHandler.OnWindowDeactivate(IntPtr uiFrame) at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.<>c__DisplayClass5b.<OnWindowDeactivateCallback>b__5a() at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.InvokeAndReturnHResult(Action action) at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.OnWindowDeactivateCallback(IntPtr uiFrame) at System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.OnComponentEnterState(IntPtr dwComponentID, Int32 uStateID, Int32 uContext, Int32 cpicmExclude, Int32 rgpicmExclude, Int32 dwReserved) at System.Windows.Forms.ComponentManagerProxy.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.OnComponentEnterState(IntPtr dwComponentID, Int32 uStateID, Int32 uContext, Int32 cpicmExclude, Int32 rgpicmExclude, Int32 dwReserved) at System.Windows.Forms.Application.ThreadContext.BeginModalMessageLoop(ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.RunDialog(Form form) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner) at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.ShowUnexpectedErrorDialog(IWin32Window owner, WindowsHost windowsHost, FeedbackErrorInfo errorDetails) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback) at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Client.Excel.NativeEventHandler.OnIdle() at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.<OnIdleCallback>b__3a() at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.InvokeAndReturnHResult(Action action) at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.OnIdleCallback() Supports Premium Content: True Formulas: section Section1;O365 Excel 2016 ProPlus - Table Import Wizard for Power Pivot - Not accessible after initial use?
It seems as if the Excel/Power Pivot "Table Import Wizard" is only available on the initial data import now. It used to be available on the initial import, and if the user selected "Table Properties" for an existing table in the Power Pivot model. I am running Office 365 ProPlus, Excel 2016. To re-create steps: 1. Run Excel 2. Select Power Pivot 3. Manage 4. Get External Data/From Database/From SQL Server 5. <fill in server and database name> 6. Select from a list of tables and views to choose the data to import 7. Select table, and choose "Preview and Filter" button 8. That brings up the Table Import Wizard 9. Using this wizard, users can manipulate the query filter using the header columns 10. Then select "Finish", to load the data into Power Pivot data model In past versions of Excel, in the Power Pivot window, could choose "Design/ Table Properties", and it would display the Table Import Wizard again. But now, in Excel 2016, it only displays SQL, and/or a SQL Designer that displays SQL. We have quite a few existing Power Pivot workbooks that were built the old way, by business users who are not SQL knowledgeable. They would use the Table Import Wizard. ** Is this feature only available on the first use in Excel? ** If it is available after first use, please tell us how to access it? ** If it is no longer available after first use, what is Microsoft's recommendation regarding the Excel/Power Pivot workbooks built by business users who do not know SQL? See ScreenShot 1 (attached), showing the Table Import Wizard on first use, and Screenshot 2 (attached), showing what I see now when choosing Table Properties. Thanks for your help. Tom Littlejohn
