Practical Microsoft Office, Excel and Outlook help for everyday work

Excel formula not showing cell reference
Microsoft Excel

Excel formula not showing cell reference

If a formula shows a cell reference instead of a result, check whether Excel is displaying formulas, treating the cell as text, or copying the reference with the wrong lock state.

Microsoft 365 keeps shutting down
Microsoft 365

Microsoft 365 keeps shutting down

Find the cause fast: app, profile, device, or update. Then use Safe Mode, version checks, repair steps, and rollback checks to stop the crashes.

Exchange online setup defender
Microsoft Office

Exchange online setup defender

Exchange Online needs a separate Microsoft Defender for Office 365 Plan 1 or Plan 2 license, then policy setup and message-trace checks.

Microsoft account device not showing: Fixes that work
Microsoft 365

Microsoft account device not showing: Fixes that work

If a PC is missing from your Microsoft account device list, first confirm the right account, then check sync delay, local accounts, and registration limits.

Excel pivot table analyze tab missing
Microsoft Excel

Excel pivot table analyze tab missing

Click inside the PivotTable first; if Analyze is still missing, check ribbon visibility, Excel version, and whether the file opens in desktop or web Excel.

New outlook keeps asking for password
Microsoft Outlook

New outlook keeps asking for password

New Outlook keeps asking for your password when the sign-in state is stale, saved Windows credentials are wrong, or the account type does not match what the app expects.

OneNote language settings not working: Fixes that work
Microsoft Office

OneNote language settings not working: Fixes that work

Match the symptom to the right OneNote language setting: selected text proofing, app defaults for new notes, or Windows keyboard defaults.

Exchange online setup alert notifications
Microsoft Office

Exchange online setup alert notifications

Check Exchange Online mail-flow rules for banners and Outlook or device settings for client alerts; transport rules win. This page maps the exact setup locations and troubleshooting steps.

Microsoft forms is not showing in sharepoint
Microsoft 365

Microsoft forms is not showing in sharepoint

Check the page, Microsoft 365 policy, or form permissions first. Then use the numbered fixes to restore the embed or link.

Onenote keeps scrolling right
Microsoft Office

Onenote keeps scrolling right

If OneNote keeps scrolling right, unplug the mouse’s Bluetooth USB dongle, plug it back in, and reopen the page. The cause is often input, an equation, or a page-specific bug.

Microsoft teams files tab not showing
Microsoft Teams

Microsoft teams files tab not showing

If Microsoft Teams files tab not showing, check whether the tab was renamed, the SharePoint link broke, or the client is rendering incorrectly.

Powerpoint keeps asking to repair
Microsoft Office

Powerpoint keeps asking to repair

If PowerPoint keeps asking to repair, compare one file in another copy and a new blank file first, then fix file damage, add-ins, or Office repair.