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

  • Pages

  • All categories

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

    Join 1,604 other followers

Archive for the ‘Office’ Category

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. In an administrator command prompt, run sfc /scannow (which takes a few minutes to run)
  3. Reboot
  4. Run Clean Manager %windir%\System32\cleanmgr.exe (ensure to clean up update files: it can take tens of minutes to run)
  5. Reboot
  6. Download the SP1 files (I needed 32-bit x86)
  7. Install SP1 manually
  8. If it still hangs:
    1. In Appwiz.cpl try a “Repair” of the Office 2013 installation
    2. If it works: Reboot, otherwise:
      1. Uninstall Office 2013
      2. Disable the network adapter
      3. Reboot
      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
      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
      6. Enable the network adapter
      7. Let Windows scan for updates and install them
        1. If you get an error 80070463 or 80070663: just reboot and retry the updates.
      8. Reboot
      9. Run Clean Manager
      10. Install Office 2013
      11. Reboot
  9. Let Windows scan for updates and install them
  10. Reboot
  11. Run Clean Manager
  12. 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.

Read the rest of this entry »

Posted in Office, Office 2013, Power User, Windows, Windows 8.1 | Leave a Comment »

Office 365 #fail: … every now and then – without any UI showing high CPU usage …

Posted by jpluimers on 2018/09/11

After each reboot on the admin console after every logon and after every RDP connection:

net stop ClickToRunSvc

Via [WayBack] Office 365 #fail: Not sure yet, but every now and then – without any UI showing – C:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeClickT… – Jeroen Wiert Pluimers – Google+

Office 365 #fail: Not sure yet, but every now and then – without any UI showing – C:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeClickToRun.exe is using truckloads of CPU while executing an invisible OneDriveSetup.exe both totaling 100% of the full CPU for tens of minutes.

Since it needs to run after each RDP connection, Windows: running a batch file during logon of a single or all users is not enough.

I will need to dig into [WayBack] remote desktop – Run application or script on Windows RDC connection – Super User and [WayBack] SessionChangeDescription Struct (System.ServiceProcess) | Microsoft Docs

–jeroen

Posted in Office, Office 2016, Power User | Leave a Comment »

MS Excel 2011 for Mac: How to Change Data Source for a Pivot Table

Posted by jpluimers on 2018/08/24

Based on [WayBackMS Excel 2011 for Mac: How to Change Data Source for a Pivot Table:

  • Refreshing the data is in the “PivotTable” toolbar under “Data”: either
    • “Refresh” for the current PivotTable or
    • “Refresh All” for all PivotTables in the spreadsheet
  • Setting the range of source data is “Change Source” in the “PivotTable” toolbar under “Data”
    • If your data is on a sheet by itself, it’s better to select the range using column only notation than using column:row notation, compare these:
      • ‘FRITZ!Box_CallList.csv’!$A:$S
      • ‘FRITZ!Box_CallList.csv’!$A$1:$S$401

The last trick makes it way easier to add newer data from an external CSV file into an existing workbook with various PivotTable analysis worksheets:

  1. Append the CSV data to the source
  2. Copy over any formulas needed to make pivot life easier
  3. “Refresh All”

On a 1920×1200 screen, the PivotTable toolbar looks like this:

Excel 2011 for Mac PivotTable toolbar

Excel 2011 for Mac PivotTable toolbar

–jeroen

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

VLOOKUP Example Spreadsheet & Tutorial | Productivity Portfolio

Posted by jpluimers on 2018/08/10

Because I tend to forget how to use this:

Excel VLOOKUP tutorial with an example spreadsheet & video. The article shows how to lookup the values from one column to use in another worksheet column.

Source: [Archive.isVLOOKUP Example Spreadsheet & Tutorial | Productivity Portfolio

–jeroen

Read the rest of this entry »

Posted in Excel, Office, Power User | Leave a Comment »

 
%d bloggers like this: