Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Access reports that databases are in an 'inconsistent state'
Click Windows Start and then type Command . Right-click on Command Prompt and choose Run as administrator . Copy and paste the following commands into the command prompt window: REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f. NET STOP SERVER. NET START SERVER.
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016
How to correct a #REF! error - Microsoft Support
Correct a #REF! error in Excel.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel for Windows Phone 10, Excel Mobile
Save a macro - Microsoft Support
Excel 2013. You create a macro in Excel by running the macro recorder or by using the Visual Basic for Applications (VBA) editor. After you've created your macro, you'll want to save it so you can use it again in the current workbook or in other workbooks. Save a macro with the current workbook.
Applies To: Excel 2013
SharePoint Correlation ID in error messages: what it is and how to use ...
Simply, it's a GUID (globally unique identifier) that's automatically generated for every request that the SharePoint server receives. It's unique to each request, not each error. However, when an error occurs, the error message contains the correlation ID that was valid for the request at the time.
Applies To: SharePoint Server 2016, SharePoint in Microsoft 365
Require a value in a field - Microsoft Support
Set the Required property for a field to Yes. In the Navigation Pane, right-click the table and then click Design View. Select the field that you want to require always has a value. In the Field Properties pane, on the General tab, set the Required property to Yes.
Applies To: Access for Microsoft 365, Access 2021, Access 2019, Access 2016, Access 2013
IF function – nested formulas and avoiding pitfalls
The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False. =IF (Something is True, then do something, otherwise do something else) So an IF statement can have two results.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10
Find and open File Explorer - Microsoft Support
Find and open File Explorer - Microsoft Support. Windows 11 Windows 10. File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard. How to use File Explorer:
Troubleshoot problems with Surface Dial - Microsoft Support
On your PC, open select the Start button, then select Settings > Devices > Bluetooth & other devices. Turn on Bluetooth. Pull the bottom off your Surface Dial to open the battery compartment. Make sure there are two AAA batteries inside. Remove the battery tab from the underside of your Surface Dial.
Introduction to What-If Analysis - Microsoft Support
Introduction to What-If Analysis - Microsoft Support. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 More... By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
October 13, 2015, update for Office 2013 (KB3039778)
This article describes update KB3039778 for Microsoft Office 2013 that was released on October 13, 2015. This update also applies to Office Home and Student 2013 RT. This update has a prerequisite. Be aware that the update in Download Center applies to Microsoft Installer (.msi)-based edition of Office 2013. It doesn't apply to the Office 2013 ...