Tip: If you want to bypass File > Open and always use the Open dialog box, do this: Select File > Options > Save, and then select the Don’t show the Backstage when opening or saving files check box. Then, close and reopen any open Office applications. Note that this change only affects what you see when you press CTRL+O to access the Open Files dialog box.

In the VBA Project Explorer on the left hand side, expand the VBA Project folder for your workbook, then double-click the ThisWorkbook module.If you don't see the Project Explorer, you can go to View > Project Explorer, or press Ctrl+R.

Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.

Active content is additional functionality in a file or program, such as macros, add-ins, or data connections. This article lists types of active content that can be blocked by settings in Trust Center and which, when present in a document, cause display of the Message Bar when you open your file.

Learn how to use voice access for accessibility. This page includes accessibility help articles for people who use Windows voice access to control their PC and author text using their voice.

Test your camera with the Camera app. Select Start , then choose Camera from your apps. If you're asked to allow access to the Camera, select Yes.If the camera works in the Camera app, the problem might be with the app you're trying to use.

Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.

Edit or update a date field. If you selected Update automatically when inserting the date, you'll see a faint gray box when you rest your mouse pointer over the date. This means you've inserted a field that you can change or update. To edit the date, click the gray box, type a new date, and then click outside the box.

On the Choose an account screen, click the Microsoft account button.; On the Add your Microsoft account screen, enter the email address and password associated with your Microsoft account.; On the Make it yours screen, you'll have the option to make this Microsoft account your primary account. (This makes sign-in, settings, and syncing happen automatically for all other Microsoft services.)

To be able to send bulk email via mail merge, you must already have installed a MAPI-compatible email program such as Outlook or Gmail. The following process assumes that you already have the message you intend to send created and open in Microsoft Word.