The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,089 other followers

Archive for the ‘Office 2013’ Category

« Previous Entries

Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet

Posted by jpluimers on 2020/03/31

As I need this one day:

To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:

=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending"}))






Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet




–jeroen

				

				
			
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development |    Leave a Comment »

		


			

			
Excel: printing top row on every page, and including grid


			
Posted by jpluimers on 2019/06/28


				

					
I hardly print with Excel, so I always forget these two:



–jeroen

				

				
			
Posted in Excel, Office, Office 2011 for Mac, Office 2013, Power User |    Leave a Comment »

		


			

			
Language Accessory Pack for Office – Office Support


			
Posted by jpluimers on 2018/10/29


				

					
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

				

				
			
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:


    

  1. Check %windir%\Windowsupdate.log (on my system, it did not reveal anything special)
    2. 

  2. In an administrator command prompt, run sfc /scannow (which takes a few minutes to run)
    3. 

  3. Reboot
    4. 

  4. Run Clean Manager %windir%\System32\cleanmgr.exe (ensure to clean up update files: it can take tens of minutes to run)
    5. 

  5. Reboot
    6. 

  6. Download the SP1 files (I needed 32-bit x86)
    7. 

  7. Install SP1 manually
    8. 

  8. If it still hangs:

      

    1. In Appwiz.cpl try a “Repair” of the Office 2013 installation
      2. 

    2. If it works: Reboot, otherwise:

        

      1. Uninstall Office 2013
        2. 

      2. Disable the network adapter
        3. 

      3. Reboot
        4. 

      4. Check if KB3173424 is installed (check it with Appwiz.cpl)

          

        1. if not: download on a different machine, transfer over USB, install, then reboot
          2. 

        

        5. 

      5. Check ifKB3172614 is installed (which has a younger Windows Update Client)

          

        1. if not: downloadon a different machine, transfer over USB, install, then reboot
          2. 

        

        6. 

      6. Enable the network adapter
        7. 

      7. Let Windows scan for updates and install them

          

        1. If you get an error 80070463 or 80070663: just reboot and retry the updates.
          2. 

        

        8. 

      8. Reboot
        9. 

      9. Run Clean Manager
        10. 

      10. Install Office 2013
        11. 

      11. Reboot
        12. 

      

      3. 

    

    9. 

  9. Let Windows scan for updates and install them
    10. 

  10. Reboot
    11. 

  11. Run Clean Manager
    12. 

  12. Reboot
    13. 



The KB3172614 should also alleviate long during (dozens of minutes) high CPU usage of svchost.exe and TiWorker.exe when searching for Windows updates.


 Read the rest of this entry »

				

				
			
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.



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

				

				
			
Posted in GMail, Google, Office, Office 2013, Office 2016, Outlook, Power User |    Leave a Comment »

		


	
	

		
« Previous Entries

		

	


	






 











	

		

	

	

	

	

	

	

	

	

	

	

	




	
							
			

			
			
								
			







		
		
%d bloggers like this: