Red Gig

Word and Excel don’t usually get along too well so it's no surprise that Power Query isn't directly compatible with its estranged cousin Word either. If you are presented with the need to import data from Word into Power Query you'll be please to hear it is possible however it requires a couple of manual steps to make it work.  The manual steps could fairly easily be completed by a batch file which would automate the process further. Here is the Excel data pasted 'as values' in a Word file which i'll use for the first example Here is the Excel data pasted with 'keep source formatting' which i'll reference a couple of times in the article. Although the steps I've covered below aren't complex, this whole process has some unknowns around it so you may find the result in your instance varies from mine. The Word file I've used contains the contents of a range of excel cells that I deliberately pasted as values into Word to create a test file f

The most useful tip / trick in Microsoft office (possibly) If you're often sharing documents and using multiple locations (including sharepoint and/or OneDrive) then the following might be of use to you. Its the 'Document Location' feature in the Quick Access Toolbar. Once its added, you can always see the location of the document that is loaded and also copy the location for a hyperlink with 2 clicks (one to select it, another to copy). This function is available in all of the main office applications (Word, Excel, PowerPoint) and needs to be added manually to each application to work. This is what it looks like when its enabled To enable it do the following: 1. click the down triangle option on the Quick Access Toolbar and select 'More Commands' 2. Once the next window opens, select 'All Commands' from the 'Choose commands from' drop down 3. From the list below, navigate to 'Document Location' and select it and click the '