Reported | search
Click here to view Reported news from 60+ newspapers.
Bookmark or Share- Overview of diagnostic log files for Office - Microsoft SupportWhen a user runs an Office app, such as Word or Excel, diagnostic information is collected and saved to log files on the user’s device. These log files contain information about the processes and components running in the application, and can help detect, diagnose, and fix issues and help make improvements to Office.
- Handling data source errors (Power Query) - Microsoft SupportSome errors may be easy to fix, some may be transient, and some may be hard to diagnose. What follows is a set of strategies you can take to handle errors that come your way. There are two types of errors that might occur when you refresh data.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
- How to correct a #VALUE! error - Microsoft Support#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it. The information on this page shows common problems and solutions for the error.
- Repair an Office application - Microsoft SupportIf a Microsoft 365 application such as Word or Excel isn’t working correctly, sometimes restarting it will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer. The steps to access the repair tool vary depending on your operating system.
More
