For my link archive: [WayBack] Language Accessory Pack for Office – Office Support (short-link)
All supported languages for Office 2010, 2013 and 2066/newer versions.
–jeroen
Archive for the ‘Office 2013’ Category
Language Accessory Pack for Office – Office Support
Posted by jpluimers on 2018/10/29
Posted in Office, Office 2010, Office 2013, Office 2016, Power User, Windows | Leave a Comment »
When Windows 8.1 gives 80070643 on applying Office 2013 SP1
Posted by jpluimers on 2018/09/17
Steps to try first:
- Check
%windir%\Windowsupdate.log(on my system, it did not reveal anything special) - In an administrator command prompt, run
sfc /scannow(which takes a few minutes to run) - Reboot
- Run Clean Manager
%windir%\System32\cleanmgr.exe(ensure to clean up update files: it can take tens of minutes to run) - Reboot
- Download the SP1 files (I needed 32-bit x86)
- Install SP1 manually
- If it still hangs:
- In
Appwiz.cpltry a “Repair” of the Office 2013 installation - If it works: Reboot, otherwise:
- Uninstall Office 2013
- Disable the network adapter
- Reboot
- Check if KB3173424 is installed (check it with
Appwiz.cpl)- if not: download on a different machine, transfer over USB, install, then reboot
- Check ifKB3172614 is installed (which has a younger Windows Update Client)
- if not: downloadon a different machine, transfer over USB, install, then reboot
- Enable the network adapter
- Let Windows scan for updates and install them
- If you get an error 80070463 or 80070663: just reboot and retry the updates.
- Reboot
- Run Clean Manager
- Install Office 2013
- Reboot
- In
- Let Windows scan for updates and install them
- Reboot
- Run Clean Manager
- Reboot
The KB3172614 should also alleviate long during (dozens of minutes) high CPU usage of svchost.exe and TiWorker.exe when searching for Windows updates.
Share this:
Posted in Office, Office 2013, Power User, Windows, Windows 8.1 | Leave a Comment »
How to Add Your Gmail Account to Outlook 2013 and 2016 Using IMAP
Posted by jpluimers on 2018/05/11
If you use Outlook to check and manage your email, you can easily use it to check your Gmail account as well. You can set up your Gmail account to allow you to synchronize email across multiple machines using email clients instead of a browser.
- [WayBack] How to Add Your Gmail Account to Outlook 2013 and 2016 Using IMAP
- [WayBack] Set up Gmail with Outlook, Apple Mail, or other mail clients – Gmail Help
Oh: you need to lower your Gmail security for Outlook 2013 as the latter isn’t up to par on security. For that, follow similar steps like in “the user name or password for imap.gmail is incorrect” – iPad, iPod or iPhone with iOS < 7.
–jeroen
Share this:
Posted in GMail, Google, Office, Office 2013, Office 2016, Outlook, Power User | Leave a Comment »
Completely Uninstall Skype For Business (aka Lync) – Skype Community
Posted by jpluimers on 2017/05/05
I don’t need Skype (aka Lync) on all my VMs, for enough reasons (obnoxiously getting in the way even when not configured, downloading updates even though not used, taking up space, etc).
Removing it through appwiz.cpl is more than just a single step. The reason is that Skype can be part of Office and – despite the updates being called Skype – can be listed as the Lync component in Office.
So the removal is as follows:
- Run appwiz.cpl
- Select the Microsoft Office version you have installed
- Right click, then choose Change
- Choose “Add or Remove features” then “Continue”
- Choose the dropdown left of “Microsoft Lync” or “Microsoft Office”, then click “Not Available” and click “Continue”
- Wait for the removal to proceed, then click “Close”
–jeroen
via: Solved: Completely Uninstall Skype For Business – Skype Community
Share this:
Posted in Office, Office 2010, Office 2013, Office 2016, Power User | Leave a Comment »
Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons
Posted by jpluimers on 2017/01/09
To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2:
Meaning: Column: Formula: Explanation: Date1Text I =TEXT(C2,”dd/mm/yyyy”) Interpret date text of the original text no matter the Excel settings Date1Value J =DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) Encode the date text to an actual date: dd#mm#yyyy format where # is any separator DatesEqual K =J2=L2 Are the encoded dates equal? Date2Value L =DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2)) Encode the date text to an actual date: mm#dd#yyyy format where # is any separator Date2Text M =TEXT(N2,”mm/dd/yyyy”) Interpret date text of the original text no matter the Excel settings
Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.
Source: Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons
Share this:
Posted in Excel, Office, Office 2007, Office 2010, Office 2013, Power User | 1 Comment »
