Images can now be included in Excel PivotTables which not only makes for better looking PivotTables but more interesting Slicers too. A great contribution from Office Watch reader “AllanC” in New Zealand. With pictures in a PivotTable you can easily make cute slicers like this to show one record (person) at a time Here’s the […]
Microsoft is changing more than just the font in Microsoft 365, there are also default color scheme and even line changes coming too. Here’s all the proposed changes and how to reverse them. New Default Fonts We’ve already talked about the new default fonts, Aptos and Aptos Display. New default font, Aptos, in Microsoft 365 […]
Microsoft Excel has caught up with the needs of investors by adding automatic refresh of Stock prices and Currency data. Office Watch will explain what’s now possible and its limitations. Don’t get too excited, we’ve waited so long and when Microsoft does respond, the auto-refresh options don’t go far enough, isn’t properly configurable and doesn’t […]
Like to know some more about your Microsoft 365 for Windows software license? How long the Office apps will run without an Internet connection? Here’s how to see that hidden license info, how it’s changed and a little good news too. Microsoft 365 software occasionally checks with Microsoft servers to see if the customer still […]
Here’s how to find out what type of Microsoft Office 365 licence you have with details hidden from the usual About dialog box. We recently showed it’s important for for perpetual non-subscription versions of Office like Office 2021 or Office 2019 to know if the purchase is Retail/Volume or OEM. That’s a vital detail for […]
