Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts

Wednesday, November 1, 2023

[EXC] Convert Values to GB

 =LEFT(B2,LEN(B2)-2)/10^((MATCH(RIGHT(B2,2),{"PB","TB","GB","MB","KB"},0)-3)*3)



to MB, handling error


=IFERROR(LEFT(D2,LEN(D2)-2)/10^((MATCH(RIGHT(D2,2),{"PB","TB","GB","MB","KB"},0)-4)*3),0)




Monday, August 6, 2018

[OFF] Working with channel and bulids




Switching Channels:

cd “C:\Program Files\Common Files\Microsoft Shared\ClickToRun”

OfficeC2RClient.exe /changesetting Channel=Current

OfficeC2RClient.exe /update user



ChannelKeyword in CMD or ODT
  Monthly Channel (Targeted)  Channel="Insiders" or Channel="FirstReleaseCurrent"
  Monthly Channel  Channel="Monthly" or Channel="Current"
  Semi-annual Channel (Targeted)  Channel="Targeted" or Channel="FirstReleaseDeferred"
  Semi-annual Channel  Channel="Broad" or Channel="Deferred"




    Switching Builds:

    PATHS:
    Office 2013 x86: cd %programfiles%\Microsoft Office 15\ClientX86 
    Office 2013 x64: cd %programfiles%\Microsoft Office 15\ClientX64 
    Office 2016: cd %programfiles%\Common Files\Microsoft Shared\ClickToRun 

    OfficeC2RClient.exe /update user updatetoversion=15.0.xxxx.yyyy  

    Run an Online Repair right after that to complete the installation