- Excel For Windows 10
- Excel 2013 Windows 10 Issues
- How To Update Excel 2016 On Windows 10 Pro
- Download Excel For Windows 10
- Excel Setup For Windows 10
If you are using Office 2016, then it wouldn't be a surprise if you have run into issues, like crashing of MS Word on Windows 10, missing Office applications and so on. Even Windows 10 update might result in Microsoft Office malfunction. In this article, we'll see some of the Office 2016 issues and their fixes on Windows 10.
In this video I walk through how to install Excel 2016 on a Windows 10 machine with a Microsoft 365 subscription. If you purchased Officefrom the Microsoft Store app on your Windows device, you can update Office from the same place! Exit all Office apps. Open the Microsoft Store app by typing 'Microsoft Store' into the taskbar search and press Enter. Click on the icon and make sure you're signed into the Microsoft account associated with your Office license.
Issue #1: Microsoft Office 2016 Crashes on Windows 10
After updating to Windows 10, when you try to open a new Office application you'll encounter an error that stops the application to work properly and leads to crash. As a result of this, apps like Word and excel, need to be closed immediately.
Fix: A simple and easy solution for this is restarting your PC. If the problem still persists, you can try repairing it with Windows inbuilt repair tool. Let's see how it is done.
- Right-Click Start Menu and choose Control Panel
- Under Programs select Uninstall a program.
- Now select Microsoft Office that you wish repair and right-click on it and select
- A screen opens asking 'How would you like to repair your Office Programs' choose Online Repair. This will make sure all the files are repaired.
You can also choose Quick Repair, though it runs fast, it only detects the corrupt files and replaces them. Whereas Online Repair does a complete repair and uninstalls it, hence takes lot of time.
If this doesn't work, if you still see Word file not opening issue then you can make use of a file repair tool that can fix damaged Word document and restore it to a healthy state. The software fixes all Office applications like Excel, PowerPoint, etc. apart from Word doc.
Issue #2: Office Applications Missing After Upgrading to Windows 10
Fix: This problem has been resolved in the Windows 10 update. But, if you still haven't updated yet, or unable to install the November update, you use the below mentioned method until you install the Windows 10 update.
Method 1: Click Start and type the application name like Excel or Word. As you are typing you'll see the search results opening automatically. Now, click the program to open it.
Method 2: Click Windows icon and then All apps. Now, scroll-down to the name of the application you are looking for.
Tip: To open the Office application faster, you can pin them to Taskbar. To do that; right-click on the name of the application and select either Pin to Taskbar or Pin to Start.
Issue #3: Unable to Save Or Open Files After Windows 10 Update
Fix: If you are facing problem to open or save a file, here is a solution that worked for most of the people.
- Right-click on Start menu and select Command Prompt (Admin).
- Type the command cd %userprofile% and hit
- Now, type cd folder_name and press Enter.
- After that type icacls %userprofile% folder_name /inheritance:e
How to shorten all clips in imovie. Issue #4: MS Office 2016 Is Not Working on Windows 10
Fix: There can be numerous aspects due to which Office 2016 stops working on Windows 10. So, there cannot be definitive solution for this issue. But, there are different ways to solve the problem, and we have mentioned below one such fix. This has been done on Excel to show you as an example.
- Open MS Excel, then click on File tab and then click Options.
- In the Excel Options windows, click Add-ins from left sidebar.
- At the bottom of the Add-ins windows, under Manage drop-down menu, select Add-Ins and click Go.
- Now, uncheck the add-ins one at a time and check the status thereafter.
By doing this, you'll know which add-in is causing the problem. If Add-ins are the root cause, disabling them will resolve the issue. How to crop a screenshot.
Conclusion
With these workarounds, you can easily fix MS Office issues on Windows 10. Microsoft did fix some issues with the latest Windows 10 update. It even added lot other features on Office applications.
If your organization has upgraded to Office 2016 or Office 365, you now have access to Excel 2016. Now what? Are there any new features? The answer is yes, especially if you need business intelligence tools and new ways to present your data.
Don't miss out on new Excel 2016 features. Here are 10 I'm most excited about:
1. The 'Tell Me' Box
Excel For Windows 10
The 'tell me' box is one of the most obvious new arrivals to the Excel party and, quite frankly, it's a shame it wasn't around in the 2007 edition when the menu ribbon was initially reduced. (Remember how hard it was to find our favorite tools?) The 'tell me' box is essentially a search function that lists functions and operations matching your search terms. It's a handy shortcut to get you where you want to go! There's also smart look-up which will use the internet to search relevant articles for your search term.
2. Forecasting
Excel 2016 has seen the addition of 'one-click' statistical forecasting for data that has a time element associated with it. As long as you have a decent amount of data it will be able to forecast past your last data point, as well as show levels of confidence at each end of the spectrum. What's also great about the forecasting function is that if Excel can see trends due to seasonality, it will factor them into the forecast. Pretty smart! Once you've made your forecast you'll be able to display it as either a line or bar graph, but be aware that the data used to create your graph of choice will not link to the chart. If you make changes to the data these will not automatically be reflected in the chart.
3. Search field (PivotTables)
PivotTables have been revitalized with a search bar that makes life easier when dealing with large data sets with numerous fields. Just search for the field you're looking for and it pops up for you to select.
4. Date Grouping (PivotTables)
Excel 2013 Windows 10 Issues
Previously, Excel PivotTables would always register dates individually—your charts would have hundreds of fields along the date axis. Now dates are automatically grouped into Years, Quarters and Months. If you want to delve deeper you simply use the + option next to the date segment to expand the next level of grouping. I think you'll find it's much more manageable.
New charts
- Excel For Windows 10
- Excel 2013 Windows 10 Issues
- How To Update Excel 2016 On Windows 10 Pro
- Download Excel For Windows 10
- Excel Setup For Windows 10
If you are using Office 2016, then it wouldn't be a surprise if you have run into issues, like crashing of MS Word on Windows 10, missing Office applications and so on. Even Windows 10 update might result in Microsoft Office malfunction. In this article, we'll see some of the Office 2016 issues and their fixes on Windows 10.
In this video I walk through how to install Excel 2016 on a Windows 10 machine with a Microsoft 365 subscription. If you purchased Officefrom the Microsoft Store app on your Windows device, you can update Office from the same place! Exit all Office apps. Open the Microsoft Store app by typing 'Microsoft Store' into the taskbar search and press Enter. Click on the icon and make sure you're signed into the Microsoft account associated with your Office license.
Issue #1: Microsoft Office 2016 Crashes on Windows 10
After updating to Windows 10, when you try to open a new Office application you'll encounter an error that stops the application to work properly and leads to crash. As a result of this, apps like Word and excel, need to be closed immediately.
Fix: A simple and easy solution for this is restarting your PC. If the problem still persists, you can try repairing it with Windows inbuilt repair tool. Let's see how it is done.
- Right-Click Start Menu and choose Control Panel
- Under Programs select Uninstall a program.
- Now select Microsoft Office that you wish repair and right-click on it and select
- A screen opens asking 'How would you like to repair your Office Programs' choose Online Repair. This will make sure all the files are repaired.
You can also choose Quick Repair, though it runs fast, it only detects the corrupt files and replaces them. Whereas Online Repair does a complete repair and uninstalls it, hence takes lot of time.
If this doesn't work, if you still see Word file not opening issue then you can make use of a file repair tool that can fix damaged Word document and restore it to a healthy state. The software fixes all Office applications like Excel, PowerPoint, etc. apart from Word doc.
Issue #2: Office Applications Missing After Upgrading to Windows 10
Fix: This problem has been resolved in the Windows 10 update. But, if you still haven't updated yet, or unable to install the November update, you use the below mentioned method until you install the Windows 10 update.
Method 1: Click Start and type the application name like Excel or Word. As you are typing you'll see the search results opening automatically. Now, click the program to open it.
Method 2: Click Windows icon and then All apps. Now, scroll-down to the name of the application you are looking for.
Tip: To open the Office application faster, you can pin them to Taskbar. To do that; right-click on the name of the application and select either Pin to Taskbar or Pin to Start.
Issue #3: Unable to Save Or Open Files After Windows 10 Update
Fix: If you are facing problem to open or save a file, here is a solution that worked for most of the people.
- Right-click on Start menu and select Command Prompt (Admin).
- Type the command cd %userprofile% and hit
- Now, type cd folder_name and press Enter.
- After that type icacls %userprofile% folder_name /inheritance:e
How to shorten all clips in imovie. Issue #4: MS Office 2016 Is Not Working on Windows 10
Fix: There can be numerous aspects due to which Office 2016 stops working on Windows 10. So, there cannot be definitive solution for this issue. But, there are different ways to solve the problem, and we have mentioned below one such fix. This has been done on Excel to show you as an example.
- Open MS Excel, then click on File tab and then click Options.
- In the Excel Options windows, click Add-ins from left sidebar.
- At the bottom of the Add-ins windows, under Manage drop-down menu, select Add-Ins and click Go.
- Now, uncheck the add-ins one at a time and check the status thereafter.
By doing this, you'll know which add-in is causing the problem. If Add-ins are the root cause, disabling them will resolve the issue. How to crop a screenshot.
Conclusion
With these workarounds, you can easily fix MS Office issues on Windows 10. Microsoft did fix some issues with the latest Windows 10 update. It even added lot other features on Office applications.
If your organization has upgraded to Office 2016 or Office 365, you now have access to Excel 2016. Now what? Are there any new features? The answer is yes, especially if you need business intelligence tools and new ways to present your data.
Don't miss out on new Excel 2016 features. Here are 10 I'm most excited about:
1. The 'Tell Me' Box
Excel For Windows 10
The 'tell me' box is one of the most obvious new arrivals to the Excel party and, quite frankly, it's a shame it wasn't around in the 2007 edition when the menu ribbon was initially reduced. (Remember how hard it was to find our favorite tools?) The 'tell me' box is essentially a search function that lists functions and operations matching your search terms. It's a handy shortcut to get you where you want to go! There's also smart look-up which will use the internet to search relevant articles for your search term.
2. Forecasting
Excel 2016 has seen the addition of 'one-click' statistical forecasting for data that has a time element associated with it. As long as you have a decent amount of data it will be able to forecast past your last data point, as well as show levels of confidence at each end of the spectrum. What's also great about the forecasting function is that if Excel can see trends due to seasonality, it will factor them into the forecast. Pretty smart! Once you've made your forecast you'll be able to display it as either a line or bar graph, but be aware that the data used to create your graph of choice will not link to the chart. If you make changes to the data these will not automatically be reflected in the chart.
3. Search field (PivotTables)
PivotTables have been revitalized with a search bar that makes life easier when dealing with large data sets with numerous fields. Just search for the field you're looking for and it pops up for you to select.
4. Date Grouping (PivotTables)
Excel 2013 Windows 10 Issues
Previously, Excel PivotTables would always register dates individually—your charts would have hundreds of fields along the date axis. Now dates are automatically grouped into Years, Quarters and Months. If you want to delve deeper you simply use the + option next to the date segment to expand the next level of grouping. I think you'll find it's much more manageable.
New charts
The people at Microsoft claim that Excel has not seen the addition of a new chart type since the 1997 edition. You know when you're waiting for the bus, you get none for ages and then loads come along at once—that's the case with Excel 2016, which unveils six new chart types, each with their own specialist uses. Here are my favorites:
Pareto chart (support.office.com)
5. Histograms and Pareto charts
Histograms show you frequencies (e.g. how much of one product has sold against another). They're not based on categories but on values that are allocated into different bins. If you want to alter this to show categories you can do that. Pareto charts go one step further by sorting these frequencies and adding a cumulative percentage line to give you a trend through the data.
Sunburst Chart in Office 2016 for Windows (support.office.com)
6. Sunburst charts
These show values by hierarchy. A good use for sunburst charts would be to analyze sales of a company and break it down by salesperson, customers and products purchased. The chart will plot the sales people at the highest level and size their sections by the sales they have made. The next level will be the customers and the total amount they have spent with their respective salesperson. The final level shows the products bought by each customer. Sunburst charts allow you to go to dozens of levels so you can really drill down into your data.
Waterfall chart in Office 2016 for Windows (support.office.com)
7. Waterfall charts
Waterfall charts are great for showing movement from an opening position to a closing position and are therefore ideal for plotting financial data, such as cash flow over a period of time. They show your opening balance, the progression through the various stages of trading and then stop at your closing balance.
8. 3D data map
Perhaps the most impressive looking of all the new visualizations in Excel 2016, the 3D data map was actually an add-in for the 2013 version but is now a fully integrated option. This chart is perfect for analyzing data with a global span (e.g. a company sales report where the company operates with a global client base). Obviously you need locational data to use this type of chart and you can then add other fields to build your picture. The chart will give you a map of the world with bars or columns in the locations that have fields attached. What's more, if you set this against a particular period of time the chart will allow you to record a simulation video showing the change in values over that period. It's great for presenting sales growth to the board or your team.
9. PowerPivot
How To Update Excel 2016 On Windows 10 Pro
PowerPivot is still technically an add-in, and not new to Excel, but it's a great tool to use to bring data into Excel. In fact it allows you to import greater levels of data (we're talking hundreds of millions of fields here). PowerPivot even has its own function language, Data Analysis Expression or DAX, and this is where the new features lie. If you feel like you've exhausted all of Excel's functions, have a go with PowerPivots.
10. Get & Transform
Another permanent fixture that started life as the Power Query add-in, Get & Transform helps you import data from various data sources. There are still the standard options of importing from a Comma Separated Values (CSV) file or an Excel workbook but now you can also choose options such as Facebook, Salesforce and other programs and packages. Once you've imported your data it will give you the chance to tidy the data into a useable format. You can also apply the Get & Transform tools to data already in Excel.
To accelerate your Excel 2016 productivity, take a hands-on course from Global Knowledge. Our introductory and intermediate courses are personalized by version, allowing you to choose the one you will use. Our advanced and Power BI courses are specific to version 2016, allowing you to fully exploit its exciting new features.
Related webinars
Advanced Functions of Excel Formulas: Part 1
Advanced Functions of Excel Formulas: Part 2
Related courses
Download Excel For Windows 10
Microsoft Excel- Level 1/ Intro (2010, 2013, 2016)
Microsoft Excel - Level 2 / Med (2010, 2013, 2016)
Microsoft Excel 2016 - Level 3 / Advanced
Microsoft Excel 2016 - Data Analysis with Pivot Tables
Power Pivot and Power Query for Excel 2016
Excel Setup For Windows 10
About the author
How can i download pdf file. Denis has been a Microsoft Certified Trainer for over 10 years, teaching Office courses such as Word, Excel, PowerPoint, Access, Outlook and OneNote, as well as Visual Basic programming. He rounds out his application training skills with experience in team building, conflict resolution, time management, and proposal and report writing.
Subscribe
Never miss another article. Sign up for our newsletter.
