KeyTips now available in Office for Mac
Microsoft 365 Insiders, Happy Friday! Great news for Office for Mac users! KeyTip support is finally coming to Office for Mac, enhancing navigation and boosting productivity. Want to learn more about these popular keyboard shortcuts? Check out our latest blog post by Hugo Garcia, Product Manager on the Microsoft 365 team: KeyTips now available in Office for Mac KeyTips in Office for Mac are now available to Microsoft 365 Insiders, and they’ll be available to all Office for Mac users in the coming months. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
DataSource Error Access To The Path is Denied / PowerQuery Mac
I am trying to read a datasource (CSV) into Power Query. I keep getting DataSource error saying that it cannot read the file. This happens whether I try using "Get Data" or just editing an existing query so that it points to a different source. An exception occurred: [DataSource.Error] Access to the path '/my/path/to/the/file.csv' is denied. (Session ID: 6cc4c6b5-96d6-4d58-b68a-f20fcab1aa8f) Sometimes, If I make a copy of the file, then I can import that copy. But if I change the name back to what I want it to be named, then it can't connect. It's the same file, just with a different name. Sometimes when I go to Get Data, all the potential choices (ie.. all the CSV files) are grayed out. But if I rename one of the files then that one will (sometimes) not be greyed out and I can select it. But if I change it back to the name I want, then it grays out again. Very frustrating as a simple duplication task (ie. duplicating a query and then adding a different source) has become very hard indeed. Any ideas why this might be happening?Transform photos with Restyle Image in Microsoft Designer
Hello, Microsoft 365 Insiders, Unleash your creativity with the new Restyle Image feature in Microsoft Designer! Using this new feature, transform your photos into stunning, stylized images with just a few clicks. Explore this new feature and share your thoughts with us in our latest blog: Transform photos with Restyle Image in Microsoft Designer Thanks! Perry Sjogren Microsoft 365 Insider Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Python and last dynamic array functions on Mac
Hi Everyone, I own a Microsoft 365 account both on Windows and on Mac. I'm registered for the Insider Program and I can use Python in Excel and GROUPBY and PIVOTBY functions on Windows but not on Mac. Someone knows why please? Thank you for responding. Take care and have a nice day. Aurelien
Power Query source access denied for colleagues within same SharePoint group
I'm having a lot of success with Power Query in Excel on Mac, which I'm super happy about, but it's massively glitchy when colleagues open my files. My colleagues are all in the same SharePoint company as me, they have the same access to the relevant files and folders, yet when they open my files they always get some kind of "file access denied" message which prevents any PQ refresh actions working. If I open up the PQ editor to check the problem, what's happening is the source file has re-named itself from the generic file path that I set up, to a C/Users/ path that's specific to me. Hence I assume isn't recognised by the other user's machine. For example (simplified): What I set up as source file: Sharepoint/Company/Statistics/2023sales.xlsx What the file path becomes when a colleague opens the file: C/Users/AnnaJP/blah...blah.../Company/Statistics/2023sales.xlsx I have tried manually renaming the file on a colleague's machine while they've got it open but each time it is opened by someone else it becomes the wrong file path again and the issue persists. It also happens even when the source table is in the SAME file that contains the query and the output. This it basically makes all my PQ-cleaned source data only update-able and refresh-able by me. Yet I am sure that with a couple of simple instructions my colleagues could easily add new data to the source and then refresh it themselves... but they can't - "access denied"! Any ideas what might help?Profiles in Outlook for Mac
Hello, Microsoft 365 Insiders! This is Priya Ganta from the Outlook for Mac team. If, like me, you have multiple email accounts configured within Outlook or have long shied away from adding your personal accounts to your work Outlook, I have some great news for you! I am excited to announce a new feature now available for Outlook Mac that lets you create a distraction-free experience across multiple accounts. Profiles in Outlook for Mac In Outlook Mac, you can now create profiles – for example, one for your work account, and another for your personal account. You can then select your work profile and Outlook will not bother you with any notifications from your personal email accounts. Similarly, if you select your personal profile at home, Outlook will not bother you with work-related emails. With one click or by pressing the Control+Tab keys, you can switch between Outlook profiles in seconds. You can even automate switching with Siri automation. Switching to my personal profile every weekday evening after 6pm and then switching back to my work profile at 8am is just one example. Until now, you couldn’t mute notifications by account, or show only certain accounts when in a focus mode. Using profiles, you can now: Theme your work profile to be a different color than your personal profile. Switch between various Outlook to help with work-life balance. For example, you can switch to your personal profile, every weekday after 6pm and switch back to work at 8am, the next day. Set up as many profiles as you need to best manage your time and your inbox. Define different Outlook window appearance for different profiles. Tie your email accounts within Outlook for Mac to Apple’s Focus Filters. The possibilities are endless! Head over to theblog postto learn more and see other updates coming out soon! Best, Nathan Microsoft 365 Insider Social Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features while helping to shape the future of Microsoft 365. Join Now:Windows|Mac|iOS|AndroidRemove all hyperlinks working?
I am on Mac version 16.77. If I control-A the contents of a Word document, then Control-Shift-F9, nothing happens - and it should remove all hyperlinks. It has worked in the past. If I take the same document to a Windows computer, it works fine. Is this a known issue or am I doing something wrong?
