Microsoft Office 2019 Now Available – Comparing 2019 vs 2016 vs 365, New Features in Access & Excel
Microsoft Office 2019 is out! Microsoft started the roll-out today of Microsoft Office 2019 for Windows & Mac – with major updates to Access, Excel, Word, PowerPoint, Outlook, Project, Visio, and Publisher – to commercial volume license customers. Microsoft is following up with Office 2019 releases to consumers and other business customers, as well as SharePoint / Exchange / Skype / Project Server 2019 releases, in the coming weeks. Office 2019 provides a subset of features Microsoft has added to Office 365 over the past three years. As Office 2019 is a one-time release, Office 365 is still the better choice with not only far more features (Co-Authoring, etc) unavailable in Office 2019, but also far earlier access to them than on-premises, non-subscription Office 2019, etc. editions. Speculation has been that Office 2019 may be the last perpetual license (on-premises / non-subscription) release of Office, so that Microsoft can focus in on its Office 365 subscription offerings. However, Microsoft has responded in one case that there is likely to be one more perpetual license release after this one. Either way, Microsoft Office 2019 product pages even describe Office 2019 as a "one-time release" with Office 365 being needed to gain access to new features after that. It may also be that there are fewer editions available for Office 2019 than for Office 2016. Whether you move to Office 2019 or 365, it's suggested you don't delay doing so, as Office 2016 cloud support will be dropped in 2020, with Office 2016 installs barred from connecting to Microsoft's cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020. New in Office 2019 Word – text-to-speech, improved inking & accessibility, focus mode, translator, Learning tools (captions & audio descriptions), @ Mentions PowerPoint – Morph transitions, Zoom, SVG, 3D model, play in-click sequence, 4k video, @ Mentions Excel – Power Query (Get & Transform) enhancements, Power Pivot included with all editions, new functions & connectors, publish to Power BI, AI-driven Excel Insights for chart suggestions, new charts, @ Mentions Excludes Co-Authoring, new Data Types like Stocks, and some other new features only available in Office 365 Outlook – @ Mentions, Office 365 Groups OneNote – OneNote for Windows 10 (Modern App included with Windows) has replaced OneNote desktop app (though OneNote 2016 will be available via Volume License Install tool) All Office apps – Ribbon customizations and roaming pencil case Microsoft Access - including the many updates we've seen recently such as: Modern Charts New Linked Table Manager Dark theme Big Int Salesforce & Dynamics connectors Other Recent Developments with Microsoft Access It's especially exciting to see all the new features, growing user base and communities, new integrations, and development team responsiveness seen with Microsoft Access of late. Inclusion on the Office templates page Which I hope will become permanent soon SQL Server Migration Assistant (SSMA) updates ODBC and OLE DB driver updates – for optimized use and new feature support for SQL Server, Azure SQL and other back-ends databases Power BI support (via On-Premises Data Gateway) Considering On-Premises Data Gateway is shared with PowerApps, hopefully that means we may see PowerApps support too in the future New & growing Access conferences and user communities: New Access Developers' Day in Amsterdam DevCon in Vienna, AEK in Germany, UKAUG in UK, PAUG in Portland, Access Day in Redmond, Access Madrid in Spain Presence at Microsoft Ignite and other conferences Access User Groups (AUG) webinars and local chapters (Chicago, Denver, Madrid, Hertfordshire, etc.) Access now included in most Office editions Included in nearly all (besides Online-only) editions Access in Office 365 Home, Personal, Business, Business Premium, ProPlus, E3, and E5 editions Access in Office 2016 Professional and ProPlus editions With MS Access having been added to most Office editions, presumably it will likewise be available with most Office 2019 editions now too. It's great to see these features available to Office 365 subscribers (or even sooner if opt-in for Insiders program) now being made available to others with Office 2019, and I look forward to the many more new advancements with Microsoft Access and Office to come. Links to More Info about Office 2019 You can find out more about Office 2019 with the following articles, FAQs and product pages: https://products.office.com/en-us/business/office-365-proplus?activetab=tabs%3aprimaryr4 https://support.microsoft.com/en-us/help/4133312/office-2019-commercial-for-windows-and-mac-frequently-asked-questions https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/office-2019-is-now-available-for-windows-and-mac/ https://www.computerworld.com/article/3229906/software-productivity/office-2019-is-coming-heres-what-you-need-to-know.html https://www.theverge.com/2018/9/24/17896700/microsoft-office-2019-release-date-features https://www.zdnet.com/article/microsoft-starts-rolling-out-office-2019-for-windows-and-mac/ https://www.engadget.com/2018/09/24/microsoft-releases-office-2019/ https://venturebeat.com/2018/09/24/microsoft-launches-office-2019-for-windows-and-mac-promises-it-wont-be-the-last/ https://www.techspot.com/news/76598-microsoft-office-2019-launches-commercial-customers.html -- Dan Moorehead Founder & Chief Software Architect PowerAccess (https://www.PowerAccess.net "Empower Microsoft Access – with new Tools | VBA Framework | PowerGit | Power Query-like PowerSQL | VSTO-like .NET API | CodeGen | Excel Formulas & Functions | Consulting | Excel ➜ Access ➜ SQL Conversion Tools"
Your message wasn't delivered because the recipient's email provider rejected it
Dear all, Recently, I registered 1 account Office 365 trial to experience O365 E3 version before bought it, I create a sharepoint site, upload some document and share with somebody, both the same and diffrence trial domain & gmail also. The share function working well, but email notification seem to be getting issue as below. Please help to advise me. PS: I search some conversation get the same my issue and they advise ask recipient admin unblock some policies and mechanisms that block my Office 365 email address and directly contact the recipient’s admin for support. I'm IT person and I believe there is no any specific policy that block my trial domain. Diagnostic information for administrators: Generating server: TY2PR0101MB2943.apcprd01.prod.exchangelabs.com Huanhk@navigos1.onmicrosoft.com Remote Server returned '550 5.7.501 Service unavailable. Spam abuse detected from IP range. For more information please go to http://go.microsoft.com/fwlink/?LinkId=526653. S(2017052602) [TY2PR0101MB2176.apcprd01.prod.exchangelabs.com]' Original message headers: Received: from TY2PR0101MB2943.apcprd01.prod.exchangelabs.com ([fe80::5970:b751:c67f:bc77]) by TY2PR0101MB2943.apcprd01.prod.exchangelabs.com ([fe80::5970:b751:c67f:bc77%2]) with mapi id 15.20.1965.017; Thu, 13 Jun 2019 07:34:39 +0000 MIME-Version: 1.0 Content-Type: text/plain Date: Thu, 13 Jun 2019 07:34:39 +0000 Message-ID: <TY2PR0101MB294387C16961C147E499FFC1C0EF0@TY2PR0101MB2943.apcprd01.prod.exchangelabs.com> Subject: =?utf-8?B?cG93ZXIgYmkgxJHDoyBjaGlhIHPhursgdGjGsCBt4bulYyAiTmF2aWdvc0dy?= =?utf-8?B?b3VwIiB24bubaSBi4bqhbi4=?=
PowerApp forms get stuck on "Getting your data..."
Some, but not all of my SharePoint Forms that are built using PowerApps are getting stuck saying (Getting your data...". The strange thing is that sometimes the data will load then this will happen, or I can click out of the form and reopen it and then it will work. Anyone experiencing a similar issue?Introducing "Request sign-off" - an approval flow that requires no set up
We are happy to announce a new feature in SharePoint called "Request sign-off". The goal is to provide you an easy way to send an item for approval to someone else. This feature enables an open approval process that allows you to easily record whether or not a document or list item was approved or not. There is no setup required. Request sign-off makes use of SharePoint's integration with Microsoft Flow. You can use it by selecting a file or list item (but not a folder), and then pulling down the Flow menu in the modern library or list UI, and selecting "Request sign-off". This flow will appear alongside any other custom flow that you or others may have added to the library. Once it is invoked, Request sign-off will create a new text column in your library called "Sign-off status". This column will record the state of your request. It works just like any other text column, you can sort, filter or group by it to organize your library. On invocation, this will tell you that it will send an approval request on your behalf, and ask your consent. Once this is provided, you can pick one or more approvers, and write a message to them for your approval request. If you add more than one approver, any one of them can approve your request: The person you sent the approval to will receive an approval request. This will be an actionable message on clients that support it (meaning you can approve it directly from within Outlook). The approver can also provide some comments along with their decision. There will also be a link included that lets the approver view the item in question: The sign-off status column is then updated with the decision, and the person who sent the approval request will receive an email with the comments: By saving you the trouble of setting up a flow and creating a new column to track status, we hope that this feature will make it easy to add a lightweight approval process to your libraries and lists. We expect this feature to start rolling out to our customers in targeted release (previously called first release) after April 9. Barring any issues we will continue to roll it out to the rest of our customers in two phases late April and early May.
Links to Sharepoint Document in Excel Opens in Browser
Hi We have several spreadsheets that have hyperlinks to documents in Sharepoint folders. Until recently, when the hyperlink is selected the document would open in the application. However, recently, more often than not the document is downloaded via the browser (Chrome). Sometimes the link behaves as expected and the document will open in its native application but will then revert back without intervention. I have checked the Sharepoint and Office 365 settings and the default is to open documents in their native application and this works when the document is opened from explorer. Thanks for any help you can give. Regards JonUpdate SharePoint list with Excel Items
I've been working on this for some time, it seems like it should be easy but has proven to stump me. I have a SharePoint list I use to track workplace safety incidents. I have an excel sheet (set up as a table) that is downloaded from WCB's website. I want to take certain cells from the excel sheet (4 columns) and update that information on the SharePoint list using a commonality between the two. In this case, the commonality would be the WCB claim number. I would like the flow to be manually triggered. Can anyone offer some help?
Can't import SharePoint online Powershell module
when I use Import-Module Microsoft.Online.SharePoint.PowerShell it says PS C:\Windows\system32> Import-Module Microsoft.Online.SharePoint.PowerShell Import-Module : Could not load type 'Microsoft.SharePoint.Administration.DesignPackageType' from assembly 'Microsoft.SharePoint.Client, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. At line:1 char:1 + Import-Module Microsoft.Online.SharePoint.PowerShell + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand I have this binary module installed: Directory: C:\Program Files\WindowsPowerShell\Modules ModuleType Version Name ExportedCommands ---------- ------- ---- ---------------- Binary 16.0.86... Microsoft.Online.SharePoint.Powe... Binary 16.0.80... Microsoft.Online.SharePoint.Powe... Any clues?
Send a Mail When a Field in a SharePoint List has a value of Yes
Hello We have a SharePoint List that people can add to / edit etc... We want to have a Flow that monitors this list and when a field changes to Yes we want a email sent to a person that basically says "ID 123" has changed Any idea how this can be done?
