A recent Office addition is ‘Shared with Me’, a list of the documents you’ve been invited to collaborate on with others. It’s available in Office 2016 Windows/Mac and the iPad, iPhone and Android Mobile apps. According to Microsoft ‘Shared with Me’ ” lets you see the files others have shared
It’s always been possible to email a document for reviewing or editing. Modern versions of Office make that easier by letting you email from the document directly, instead of an email program like Outlook. Instead of opening your email to send an attachment, click on Send as an attachment from
The Share pane in modern Office is fine within an organization or with people who are familiar with document collaboration. But what if you want to share a document link with more detail in the email or using a non-email method like Instant Messaging? Well, you want to get just
There’s a new Office security bug that can be exploited with just an email or calendar invite as well as the more common infected Office document. The new Office exploit uses the long-standing DDE system which allows Office documents to ‘talk’ to each other. Until told otherwise, best to assume
Ever since Microsoft added shared, collaborative documents via OneDrive, they’ve had problems with saving and sign-in. Here’s how to deal with some of those persistent bugs. These bugs can happen in Word, Excel, PowerPoint or OneNote. Most commonly with documents saved to OneDrive but also Dropbox or other cloud storage.
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings. We’re using the same source list as in our Basic PivotTable and Two-dimensional PivotTable examples. Doing that is simple, just
We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables. They aren’t a lot more complicated than a basic PivotTable, just add a few more fields. We’ll start with the same sales list that we used for our PivotTables 101 article. This
Bluetiful will be the new Crayola color. It’ll be generally available from January 2018 or you can use it right now in Microsoft Office with these tips. Office-Watch.com told you about the demise of Dandelion, the now defunct Crayola color. And we showed how to keep Dandelion in your Office
PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. Mayurakshi wants to show you some of the nifty parts of PivotTables
10 October 2017 was an important date for Microsoft Office. It marks the end of support and updates for all ‘flavors’ of Office 2007. From now on there’ll be no updates or patches. Not even security patches to fix vulnerabilities available to hackers. It applies to the entire Office 2007
The October bundle of Office security patches includes one for a bug that’s already known and being used by hackers. Known as CVE-2017-11826, this is a Word bug which allows a malicious RTF/DOCX combination to access your computer. The attack uploaded all the documents, images etc that it could find
Here’s how to control what Outlook does when it gets a Read Receipt request with an incoming email. The setting is at File | Options | Mail | Tracking, just below where you set the options for outgoing Read Receipts. That’s Outlook for Windows, see below about Outlook for Mac.
A new vulnerability in Word was discovered and patched by Microsoft earlier this month. Again, the source was an RTF (Rich Text Format) document. There’s still a widespread myth that RTF files are ‘safe’ supposedly because RTF’s can’t contain macros. That’s FALSE. .RTF documents aren’t designed to accept code, they
Make smarter decisions with Excel’s tables and lists. Excel is a great place for comparison shopping or deciding which product to buy. Unlike Word or OneNote, Excel has tools to sort, filter and do calculations to help you narrow down many choices to just a few or one. In this
A new bit of spam or phishing got past our multiple spam filters and into our Outlook 2016 Inbox. It’s a good example of what check in an unexpected message. The message uses the name and link from a real law firm but they’re not to blame. It appears to
Outlook for iOS and Android has a of plugin with support for animated GIF’s which is very strange indeed. Gfycat has released a plugin for Outlook iOS and Android that lets you choose animated GIF’s to insert into your messages. Source: Microsoft/Gfycat You can add animated GIF’s to emails from
If you love digging into US election details you’ll love these spreadsheets with US Presidential Election results, by County and Party from 1836 to 2016 Unleash your inner Nate Silver, see how your county or state voted over the years, starting at Google Docs There are tabs for each state
A hidden trap in the 64-bit versions of Microsoft Office 2016 or 2013, they can’t work with MPEG-4 video .mp4, audio .m4a, nor QuickTime .mov . If you’ve ever seen this error message: “PowerPoint cannot insert a video from the selected file. Verify that the necessary 64-bit codec for this
By Mayurakshi Mohapatra Adding a picture to an Outlook contact is a good way to make the contact more identifiable. If you are bored seeing the initials or boring graphic next to the Outlook contact name, no worries, at all. Outlook lets you add, change or remove an existing picture
Logitech has a new Craft keyboard with a control wheel that works with Word, Excel and PowerPoint. It’s a high end keyboard that seems to have a lot of interesting points. Source for all images: Logitech It has more than one wireless connection, instead of the usual one. Either Bluetooth
Organizing your time at a busy conference, arts festival or other composite event is easier with Microsoft Outlook. Either for yourself or coordinating with others. Here’s how. These are ‘real world’ Office suggestions you can use for any busy conference, festival or event. Not just the official Microsoft advice but
Ransomware hasn’t gone away, it’s just not making headlines. MalwareBytes reports that two more variations of the Locky ransomware have appeared in the last few weeks. Beware DOC and DOCM They spread in ZIP files or the hackers favorite way to infect a computer, Microsoft Office files, most likely Word
The New York Times has a nifty new calendar of upcoming space related events including eclipses, meteor showers, launches etc. Here’s how to add the NYT Astronomy and Space Calendar into Outlook software. The service is directly linked to Google and Apple iOS devices (iPhone / iPad ) with Outlook
Can you believe it, PowerPoint is 30 years old? Originally called ‘Presenter’, in 1987 it was renamed to ‘PowerPoint’ by Robert Gaskins. Later in 1987, Microsoft bought the software out of petty cash (i.e. $14 million). 22 May 1990 was the first release of Microsoft PowerPoint for Windows, the birthday