Windows 10: Excel 2016 broken after update

Vaclav Kvasnicka · Nov 14, 2024

We have reports from several users running Excel 2016 32-bit and 64-bit versions. Excel does not start at all, only the splash screen is shown and stays forever.Mostly on Win11.I had a similar problem on Win 10 in Excel 2016 now.Excel reported things like "Sorry, we couldn't find :\ExcelTools\MyTools.xll Is it possible it was moved, renamed or deleted?" while the refered file was ok at the correct location. But note the wrong path reported by Excel, starting with ":"I managed to solve this by uninstalling the "Security update for Microsoft Excel 2016 KB5002653 32-bit Edition" and now Excel w

:)

Brink · Nov 14, 2024

New feature updates for Power Pivot in Excel 2016

We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.

Save relationship diagram view as picture

Excel 2016 users can now save the data model diagram view as a high resolution image file that can then be used for sharing, printing or analyzing the data model. To create the image file, in the Power Pivot add-in, click File and then select Save View as Picture.

Enhanced Edit Relationship dialog creates faster and more accurate data relationships

Excel 2016 Power Pivot users can now manually add or edit a table relationship while exploring a sample of the data—up to five rows of data in a selected table. This helps create faster and more accurate relationships without the need to go back and forth to the data view every time you wish to create or edit a table relationship.

We have also added several usability goodies to the Edit Relationship dialog:

Table selection using keyboard navigation—Type the first letter of a table name to move the first column name starting with the selected letter.

Column selection using column navigation—Type the first letter of a column name to move the first column starting with the selected letter. Retype the same letter moves to the next column starting with the selected letter.

Auto column suggestion for same column name in both tables—After selecting the first table and column, on the selection of the second table, if a column with the same name exists, it is auto-selected (works both ways).

Fixes that improve your overall modeling user experience

We made a few fixes that improve your modeling user experience, including:

Power Pivot data model is no longer lost when working with hidden workbooks.

Ability to upgrade an Excel 2010 workbook with a data model to Excel 2016 is now available.

Ability to add a calculated column in Power Pivot, unless it contains a formula, is now available.

For a full list in this customer update, visit Power Pivot and the Analysis Services Engine in Excel 2016 fixes.

For all Excel 2016 users, get the latest customer update by installing the following updates. Note, there are 32- and 64-bit versions of each, so be sure to download the right version:

KB3114374—Office 2016 Excel update from December 8, 2015.

KB3114297—Office 2016 Power Pivot in Excel from December 8, 2015.

Try them yourself!

Try these new improvements and see how they can help you improve your analysis performance. Do you have ideas on other improvements that you’d like to see in Excel? Visit the Excel UserVoice and tell us about them.
Click to expand...

Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs

Vince R. · Nov 14, 2024

Excel 2016 freezes

Hello! merlinuwe1

Thank you for posting in Microsoft Community

There could be several reasons why Excel 2016 freezes when running under Windows 10. Allow me to ask:

Is this happening to all other devices? or just specific device?

What error message are you getting?

Is this happening to all other Office applications?

Here are some troubleshooting steps you can try:

1. Check for updates: Make sure that both Excel 2016 and Windows 10 are up to date with the latest updates and patches.

2. Disable add-ins: Sometimes, add-ins can cause Excel to freeze. Try disabling all add-ins and see if the issue persists.

3. Repair Office: Try repairing the Office installation to fix any corrupted files that may be causing the issue.

4. Disable hardware acceleration: Go to File > Options > Advanced and under the Display section, check the box for "Disable hardware graphics acceleration". This can sometimes fix freezing issues.

5. Check for conflicting software: Make sure that there are no other software programs running that may be conflicting with Excel.

I hope this helps!

Thank you,

Vince

Microsoft Community Moderator

Brink · Nov 14, 2024

April 2017 updates for Get & Transform in Excel 2016 and Power Query

Excel 2016 includes a powerful set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.Today, we are pleased to announce five new data transformation and connectivity features that have been requested by many customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved data connectivity and transformation features:

Support for the same file extensions in Text and CSV connectors.

ODBC and OLE DB connectors—support for Select Related Tables.

Enhanced Folder connector—support for “Combine” from the Data Preview dialog.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor.

New Insert Step After option in Steps pane inside Query Editor.

Support for the same file extensions in Text and CSV connectors

With this update, we revised the list of supported file extensions in From Text and From CSV connectors. Now, you can browse and select any text (*.txt), comma-separated value (*.csv) or formatted text space delimited (*.prn) file as the first step of the import flow for both connectors. Alternatively, you can switch to the All files (*.*) filter option and select to import data from any other unlisted file.

ODBC and OLE DB connectors—support for Select Related Tables

When using the ODBC and OLE DB connectors, we enabled the Select Related Tables button in the Navigator dialog. This option—already available for other relational data sources—allows users to easily select tables that are directly related to the set of already selected tables in the Navigator dialog.

Enhanced Folder connector—support for Combine Binaries from the Data Preview dialog

In the January 2017 update, we shipped a set of enhancements to the Combine Binaries experience. You can learn more about those enhancements in this article.

This month, we made it easier for customers to access the Combine Binaries feature by allowing them to combine multiple files directly from the folder Data Preview dialog within the Get Data flow, without having to go into the Query Editor.

Note that exposed multiple options (Combine and Combine & Load) allow customers to further refine their data before loading it into the worksheet or Data Model.

New Change Type Using Locale option in Column Type drop-down menu inside Query Editor

In the Query Editor, it is possible to see and modify column types by using the Column Type drop-down menu in the preview area.

With this release, we added the Change Type Using Locale option to this drop-down menu (previously available by right-clicking the column header and then selecting Change Type > Using Locale). This option allows you to specify the desired column type and locale to use for the conversion, which affects how text values are recognized and converted to other data types, such as dates, numbers, etc.

New Insert Step After option in the Steps pane inside Query Editor

With this update, we added a new context menu option in the Query Editor window to easily insert new steps in existing queries. The Insert Step After option lets users insert a new custom step right after the currently selected step, which can be the final step or any previous step within the query.

Learn more

Learn more about what’s new in Excel 2016.

Join our Excel community on Facebook and Twitter, and collaborate with others on Get & Transform Data at our new Tech Community forum.

Send us your ideas for other improvements on our Excel UserVoice page.

—The Excel team
Click to expand...

Source: April 2017 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs

Windows 10: Excel 2016 broken after update

Excel 2016 broken after update

Excel 2016 broken after update

Excel 2016 broken after update

Excel 2016 broken after update - Similar Threads - Excel 2016 broken

Excel 2016 broken after update

Excel 2016 freezes

Excel 2016 freezes

Excel 2016 freezes

Excel 2016 problems after W10 1903 update

Excel 2016

Excel 2016

Excel 2016

October 2016 updates for Get & Transform in Excel 2016 & Power Query