I have iMac 27 (10,1 late 2009) with High Sierra. I got new SSD and installed High Sierra. After installing MS Office it asked me to sign in. And it seems impossible. After I enter my email address nothing happens, just blank window. I entered my MS account and changed authorization method from Authenticator to Login-Password, but it didn’t work. Is there any solution? Please, help. :)

[macOS 15.4.1, Mail.app 16.0] I use Mail.app to access 4 MS 365 accounts. One stopped being able to send/receive recently (soon after I updated from 15.4 to 15.4.1?). Restarting Mail or the MacBook Pro doesn't help. I still have full functionality with the other 3. Near the upper-right corner of the main Mail.app window is the text "Account Error" with a triangle warning symbol. If I click that text, I get a dialog with the message Online Status \ Connections to host (null) on the default ports failed. I also tried going to System Settings -> Internet Accounts -> *problem account* and then toggling the Mail setting off, then back on. Still no luck. I can read/send email with this MS 365 account on my iPhone with no issues. I realize I can fully blow this account away and then re-sync everything, but this is the account with 3GB of mail, and it would be a hassle to do that, so I'm hoping to find another option to this problem. Thanks for any pointers! EDIT:\ Here is a ping to Microsoft 365 SMTP: >ping -c1 smtp.office365.com PING yyz-efz.ms-acdc.office.com (40.99.227.114): 56 data bytes 64 bytes from 40.99.227.114: icmp_seq=0 ttl=236 time=28.277 ms --- yyz-efz.ms-acdc.office.com ping statistics --- 1 packets transmitted, 1 packets received, 0.0% packet loss round-trip min/avg/max/stddev = 28.277/28.277/28.277/nan ms

I generally use [BusyCal](https://www.busymac.com/busycal) for viewing my calendar and Apple Mail for my email — both connected to Office365 for my work. Sometime last week, BusyCal stopped responding. I contacted BusyCal support and they suggested rebooting. Sadly, that *did* help but only for a bit before long, it was hanging again. I tried opening Outlook and it also hung. All this time, Mail has been operating fine and updating with new mail from O365. This suggests that it’s an issue with calendar sync and not a general O365 sync issue. I googled a bit and found some old posts which suggested killing exchangesyncd (the name implies a daemon for sync with exchange). That didn’t work either. I ran Microsoft AutoUpdate and updated Outlook to 16.94 but that did nothing for me either. I’m on the latest MacOS: Sequoia 15.3.1 Specific questions: * Is anybody else seeing this? * Have you figured out a cause or fix? * Other than exchangesyncd, are there other background processes to try to restart rather than the big hammer of laptop reboot?

The user-defined function Excel VBA Office 365 Mac (Version 16.86 (24051422)) on macOS Ventura 13.6.7 generates different results if an "IIf" function is used instead of an "If Then Else" statement. Examples follow:

Function myMOD3(a As Double, b As Double) As Variant
 `   myMOD3 = IIf(b = 0, "NaN", a - b * (a \ b))
    myMOD3 = IIf((b  0), (a - b * (a \ b)), ("NaN"))
End Function

Function myMOD4(a As Double, b As Double) As Variant
    If b = 0 Then
        myMOD4 = "NaN"
    Else
        myMOD4 = a - b * (a \ b)
    End If
End Function

The first function, myMOD3 works. However, when "b" is equal to 0, it generates a divide by zero error if called from a Sub in VBA or **"#VALUE!"** when called from Excel. For some reason, the "IIf" does not capture **b=0** or **b0** (the commented-out code has the same result) resulting in the return of "NaN". The second function, myMOD4, also works fine. When b=0, it responds correctly by returning "NaN". Both these functions should produce identical results. Is this just a strange quirk of MS VBA? In other situations, the IIf function appears to work as expected. Does anyone have any ideas?

I am setting up a OneDrive account on my Mac (macos 10.15.7). The OneDrive local folder is at ~/OneDrive/. I would like to sync other folders as well, *e.g.* ~/Music/, ~/Documents/, etc. OneDrive for Windows 10 has this feature built-in, but of course this is lacking on the macOS version. (OneDrive will not allow your sync directory to be your home directory.) Are there any tricks to get these and other locations to sync here on the Mac? (FWIW I do have "Premium OneDrive" through my **Microsoft 365 Family** subscription.)

Since I installed Big Sur, I have run into this problem every time I open a document using Word or a worksheet using Excel or a slide show in PowerPoint: Run-time error '53': File not found: Library/Application Support/Adobe/MACPDFM/MacPDFM.framework/Versions/A/MacPDFM **This is very annoying, as I have to dismiss this window up to four times in a row every time I open a document** on these Microsoft Office applications. I searched everywhere, including the official Microsoft website, macOS tip websites, but the information was incomplete, obsolete and did not offer a practical solution. Does anyone know how to fix this really annoying problem?

MacOS Sonoma 14.5 Macbook Pro M1 Office 365 (Institutional) (.docx not required) I have about 50 documents that require swapping names within the document for ID codes. The documents are 30-40 pages each, and have ~15 instances of name swapping each. All names correlate with an ID. So for example: name: Mary Poppins becomes: P123456 name: Donald Duck becomes: P590834 Luckily, none of the names coincide - there is only one Mary, and one Donald, and so forth. This means I *Should* be able to Find+Replace across multiple documents to accomplish the task. The documents are currently .docx but I can easily convert them to .txt and back if need be. All files are in the same folder. I have seen several fixes, but they tend to be outdated or intended for Windows, such as: VBA Find and Replace Word Macro Fixes I suspect I can do this with Automator, but my tests so far have accomplished nothing.

I spent an enormous amount of time working on multiple sheets in a single excel file. Now, it's gone and just has an old version. I'm not sure why it didn't get saved (I typically save things way more often than needed), but that's besides the point now. - I'm on a Mac running version 16.61.1 of Excel and macOS Monterey 12.2.1 - Autosave was not on. - I am willing to do anything to get this data back, including Disk Drill-esque methods. - "Browse version history" is grayed out. I'm asking this here because all of the solutions I've seen and tried only are doable on non-Mac computers. If there's any information I'm not remembering to include, I'm more than happy to give additional details. Here is a list of things I've tried: - Checked trash and the time machine. - Checked temporary files: it looks like there's a newer temporary file instead that is too small in size to be my sheets. (New temporary files appear not to overwrite new ones in Excel 365, though.) - Tried the solutions here (I'm on version 16.61.1 of Excel and macOS Monterey 12.2.1, so these menus don't exist on my version.) Similarly, I don't appear to have the correct version to do this because I have Excel 365. - Attempted to find any "previous versions" by opening the properties/get info page of the file. - I searched for .tmp files in Finder, but didn't see any of those files. - I have installed EaseUS Data Recovery Wizard, and it is loading: I will try searching for .tmp files within it. - I've tried solutions like this that don't work on macOS and Excel 365. - I've tried finding "Unsaved Workbooks/Manage Workbook," which doesn't seem to exist on Excel 365. Not much time has elapsed since the creation of the file I want to recover, I have barely used Excel since (just for troubleshooting), and I have 177 GB of unused storage on my computer. I've found a ~ar4014.xar XAR archive document here: "/Users/user/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/~ar4014.xar". The file is 25 KB, which is about what's expected for the file I'm trying to recover. It has the correct number of sheets: there are files within the .xar that say "sheet2.bin", "binaryIndex3.bin", "sheet6.bin.rels", etc. The data is definitely in the .bin files within the .xar file: I can see the correct English text in the .bin when I converted .bin to ASCII.

I've tried many things to assign a 1-key shortcut to the "Step Into" debugging function in the VBA editor for Mac Excel (Mac VBE). I posted a question about this on Stack Overflow but my experience is that Macintosh-related questions often don't get resolved there, as in this case. Below are screenshots showing an attempt to reassign to the F8 key (which is used in Windows for this). Although it looks like it would work, pressing the key does nothing when debugging (although the awkward default shift-cmd-i still works). There are other 'solutions' to this kind of problem which do not work for me. Namely, using the FN key in combination with F8 or checking the "Use F1,F2,etc. keys as standard function keys" checkbox within Settings. I've also tried using a utility called FunctionFlip, but like others , it didn't work for me. I'm not tied to F8, and would be happy to reassign others such as F5, F6 or F7 which are already used within the Mac VBE. I say this because according to a comment by Emilio F8 is special on the Mac. But when I tried with F5, for example, it also failed. I'm using Excel 16.29.1 on an Office 365 Personal subscription on a MacBook pro without a touch panel (which I understand replaces the function keys), and I use both notebook keyboard and an external (mac) keyboard purchased in 2019.

How do I change the author name that appears in comments on Microsoft Word for Mac? I'm using Mac OS 14 and Word from Microsoft Office 365 version 16.8 I've tried Preferences > User Info > Name and then restarting but it didn't work

I have Office 365 on a PC running Windows 11 and on a Mac Mini running Sonoma. Both Office versions are up-to-date. I develop an Excel VBA application on Widows. After testing thoroughly, I copy the .xlsm file via OneDrive over to Mac for testing there. I have been doing this for several years with the same application, and have gone through many rounds of testing on both Windows and Mac. But something seems to have changed recently. Today, I ran the application on Mac in the usual way by double clicking the .xlsm file that I just brought over from the PC. The application halted with an Overflow error. In the Debugger, this assignment statement was flagged:

Dim i as Integer
i = 77

This obviously should not overflow. I was able to execute the line without raising an error by single stepping in the debugger. But when I let the program continue to run, it halted with an overflow at some other trivial assignment. Same story: single stepping in the debugger does not raise the error. I decided to try launching Excel in a different way. In Finder, I went to Applications, and double clicked Excel.app. In the Open window, I chose my .xlsm file. Now the application ran faultlessly. To make sure it wasn't a fluke, I ran the test several times this way and it worked every time. My question is this: On a Mac, what's the difference between (1) double-clicking an .xlsm file and (2) running Excel.app and then selecting the .xlsm file in the Open window?

john@Johns-Mac-mini ~ % ls -dleO@ /Users/john/Desktop/BTNS\ System\ Testing\ -\ Mac/March\ 2\,\ 2024/Process\ Profiler-129.xlsm
-rw-rw----@ 1 john  staff  - 308577 Mar  2 15:47 /Users/john/Desktop/BTNS System Testing - Mac/March 2, 2024/Process Profiler-129.xlsm
	com.apple.FinderInfo	    32 
	com.apple.lastuseddate#PS	    16 
	com.apple.macl	    72 
	com.apple.quarantine	    30

When I try and log in to my Office 365 apps with my corporate account on macOS Monterey 12.7.3 after changing my Active Directory password, I get the following error: No Network Connection: Please check your network settings and try again. - I do have a network connection. I can access SMB file shares. - The Mac is joined to the Active Directory domain and I can log in with my *new* password. - I entered my previous AD password at first login post-password-change to update my Keychain password as well. - My IT group cannot support me per corporate policy because Macs aren't supported. They have helped me with small things out of kindness in the past (I.e. they joined my Mac to Active Directory). - We use a Single Sign On solution which goes through VMWare Identity for all Office apps. I.e., Office asks for my email (Live account) and then displays, a message about redirecting me to my company login portal. That's when I see the dialog for VMWare Workspace ONE. - If I enter a different username, it will prompt me for a password rather than displaying the network error. - I've deleted every keychain item I can think of related to Microsoft, ADAL, etc. - I've reset every component (short of completely uninstalling Office) using Microsoft Office Reset . Based on this last point, I believe some piece of this SSO scheme (Office, Live, Kerberos, Keychain, VMware Workspace ONE, Oath, Microsoft OneAuth, ADAL, MSAL, MSAuth, etc.) is caching my old credentials. I'd like to find where those are cached and delete them so I can enter my new credentials.

I have a spreadsheet with a small number of cells - 4 tabs. - The biggest circa 860 rows x 30 columns = 25800 cells - The size of the spreadsheet on disk is 225KB. (222,467 bytes) - The cell count in the other 3 sheets are negligible - I think I am under the limits described here ! Hardware: - (MBP 2016) Quad Core Intel i7 - 16GB Memory - Activity Monitor says 7.29GB memory used at the time it happens. OS: - OS Monterey 12.7.3 - **upgrade to OS occurred last night. My gut tells me something here broke Excel.** Excel version: - Excel for Mac 16.81 (24011420) - Licence: Microsoft 365 Subscription I have used far bigger spreadsheets before today with no issue! Any ideas? I have tried: 1. clearing content of rows below, 2. copying data to a new spreadsheet 3. rebooting. All to no avail. The moment I try and enter or paste new data and hit enter in a cell I get this issue. A screenshot is here Others can open and add data with no issues on other hardware - probably Windows users - I shared spreadsheet internally with my colleagues in Teams. I also tried contacting Microsoft Support - but gave up after about 20 min - when I Googled the response time was 2-6 hours! I also ferreted around looking for answers in Excel log files located in this folder - nothing jumped out at me: - /Users/___/Library/Containers/com.microsoft.Excel/Data/Library/Logs/Diagnostics/EXCEL - ___ - substitute your login id for folder name. I also posted here too. Finally: - there was a UiPath forum post that came up in my search - which in turn had an embedded link here . But neither of these made any sense to me.

I'm running Mac OS 14.0. In both Word 365 on a Mac (Microsoft Office 365 for Mac version 16.80) and the web version, I can't get RTL (right-to-left) text to appear in comments. This type of text is used in Hebrew and Arabic, for example. In both cases, there's no problem with RTL text in the body of the document. But when it comes to the little comment bubbles that appear on the right side of a Word document, the formatting options are limited. For example, on Word for Mac if you highlight the text within a comment and right-click it, there aren't any formatting options. The web version, by contrast, does show formatting options when you right click, but they don't work for me. I can select Text Direction > Right-to-Left, but then nothing happens to the text in the comment bubble. This is a real problem for collaborating with others using Word for Windows, where apparently this is not a problem.

I have an iPhone with iOS 16.7 installed. I have Microsoft Outlook 4.2339.0 installed. Here are the steps: 1. Open the Microsoft Outlook app. 2. Choose **Add account**. 3. Enter my Office365 email address 4. Click **Add account** 5. Choose **Outlook.com** 6. Observe I get "We couldn't find an account with that email address or phone number." error. What can I do to be able to read my Office365 email on my iPhone?

Office 365 keeps prompting for login credentials within Mac OSX? I came across a problem where a client of mine had bought and installed Office Suite 2016 she than upgraded to Office 365 Business Premium.

I'm trying to programmatically retrieve the Office 365 account in use by users on a Mac fleet. I discovered this is apparently stored in the keychain, either in the msoCredentialSchemeADAL internet password or in the OneAuthAccount generic password (both in *Where* field). The first is sometimes missing, but the latter seems always to be present. Now I found some computers where the msoCredentialSchemeADAL ID is not matching the Office logged in user. And I have two OneAuthAccount entries, one with the same ID, and the other one with the ID matching the user showing up in (e.g.) Word. What's the correct way to obtain the Office365 User UUID? I was unable to sort it out, so far my searches were unsuccessful.

I want to make sure that an *Excel* file I created is purged of all personal and user metadata before passing it on, for confidentiality reasons. For Windows, there are many guides for removing personal metadata from most Office data files. Example guide direct from Microsoft: https://support.office.com/en-us/article/remove-hidden-data-and-personal-information-by-inspecting-documents-presentations-or-workbooks-356b7b5d-77af-44fe-a07f-9aa4d085966f I have also found guides for removing metadata from Microsoft *Word* specifically on MacOS: https://support.cu-portland.edu/hc/en-us/articles/360011611633-Scrub-metadata-from-Word-documents In short, most approaches to removing metadata from Office files in Windows involve the use of the built-in **Document Inspector**, which doesn't seem to exist in the MacOS versions of Office apps. There does seem to be a way to purge metadata from a Microsoft *Word* file in MacOS (Tools -> Protect Document -> Check "Remove personal information from this file on save"), but there doesn't seem to be any equivalent for Microsoft *Excel*. I am running the latest version (at the time of this posting obviously) of Microsoft Office 365 and Microsoft *Excel* 16.36 (20041300) for MacOS Catalina 10.15.4. Note, I wasn't 100% sure where to post this. I consulted a StackExchange question (https://meta.stackexchange.com/questions/90919/which-stack-exchange-site-is-best-for-microsoft-excel-questions) which said that I should use the **SuperUser** stack for Microsoft Office related questions, but since this is an Office question that is specific only to the MacOS version, I decided it would be more appropriate here. It seems to me, though, that an Office-specific stack might be useful.

How do you 'clear filters' in excel in office 365 for mac using the keyboard? On PC I can do alt+d,f,s or using the mouse I can go to Data > Filter > Clear

I'm on MS Outlook 365 for MacOS. I use it for a custom IMAP account. Sometimes I receive meeting invites and those are saved to the Outlook 365 calendar. Is there a way to sync them with one of my iCloud calendars?