Excel 2011 is a solid upgrade for any current Excel user whose work involves a heavy dose of spreadsheet duty. Some uneven performance issues and a lack of Mac-standard features, however, prevent this version from Excel from attaining perfection. Add-ins by Ablebits are designed to help you with everyday worksheet tasks in Excel 2016 for Mac, desktop version of Office 365 for Mac, and Excel 2011. What you want to do. Merge two tables into one.

I am in a business environment where we have 40 Apple workstations running Office for Mac 2016 (O365 business subscription) and since computers auto updated to latest version 16.9 (180116) of Office 2016 for Mac, everything is turning into a nightmare. So far, we discovered several NEW issues we never had before: - Outlook 16.9 (180116) is very unstable, I often have the BBOD (beach ball of death) and I have to force-quit it and loose unsaved message. Something that NEVER happened a single time with prior version like 15.41 for the past several years. - Excel 16.9 (180116) crash (unexpectedly quit and error reporting) when we try to print some existing documents we are carrying for a while.

This NEVER happened a single time before. I have to manually roll back Excel version (and disable updates) of SEVERAL computers for this reason because these existing documents are business criticals for daily operations. - Word 16.9 (180116) mess up most of our Avery label template files (existing DOCX with some content) we use daily and apparently, some very old Avery label template as been removed from this new version, so we have remaining stock of label, but built-in template is gone if we try to start a new documents from scratch. I also have to roll back version on a few computer where people print a lot of label with it. Overall, from my IT manager perspective, this is the worst upgrade I ever see. Did other people noticed all these flaws? I am pretty sure I'll discover some more in the next few days.

Quicken loans payment options. After installing 18011602 I immediately had problems printing to pdf from Excel which I do extensively. I have not tried other Office apps. I immediately knew there were problems after the update as simply choosing the print command causes a long beach ball, then choosing print to pdf results in another lengthy beach ball. Then the pdf is created but with flaws including imprecise type appearance and odd 'borders' around images.

I reverted to the previous version and the problems were instantly resolved. There are obviously big printing issues with this update. After installing 18011602 I immediately had problems printing to pdf from Excel which I do extensively.

I have not tried other Office apps. I immediately knew there were problems after the update as simply choosing the print command causes a long beach ball, then choosing print to pdf results in another lengthy beach ball. Then the pdf is created but with flaws including imprecise type appearance and odd 'borders' around images. I reverted to the previous version and the problems were instantly resolved. There are obviously big printing issues with this update.

Thank you Dave for you quick answer, I appreciate that you confirm that I don't have isolated issues. In my case my entire Excel crashed and it was on a physical HP business laser printer, I don't even tried on a PDF since we can't succeed on a physical printer. In fact the Word issue I also reported where all our corporate templates are messed up (wrong alignment, wrong margin, etc.) are also related to the printing in Ms-Office. Definitely problems with display and printing.

For example 1) Documents with charts placed within word boxes. Previous version views and prints normally. With v16.9 the charts appear as placeholders, although hovering mouse over the chart reveals the presence of data points, axis, etc. Zooming in or out enables the chart to be viewed normally. However, when printing the document the charts are not printed. Charts also missing when saved to PDF. Colleague in U.K. Using latest PC version has same experience except he can save to PDF okay; going directly to print still leaves out the charts.

This suggests the problem(s) are not entirely Mac-specific. 2) Odd format behavior with objects. I have objects filled solid white with drop shadows. Choose No Fill and the shadow disappears even though the Shadow parameters remain in place. Haven't taken time to discover more. Already a productivity killer.