4.10.22

Excel: Transpose data from rows to columns or vice versa

 

  1. Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.

    Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.

  2. Choose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data. The new table that you paste there will entirely overwrite any data / formatting that’s already there.

    Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose Tranpose button image.

    Paste Options menu

  3. After rotating the data successfully, you can delete the original table and the data in the new table will remain intact.

22.9.22

Gmail IMAP with Outlook 2016/2019 very slow synching subscribed folders fix

After trial and error with all the settings in Outlook, there is a setting/checkbox in Define Send/Receive Groups --> Edit --> Receive mail items.  There are two radio buttons.  One is for Download complete items including attachments for subscribed folders and the other is for Use the custom behavior defined below.  I chose the second setting and then selected ONLY the Inbox.  This way ALL of the subscribed folders don't get synched when the sync happens.  Back on the main Outlook screen, if a folder is clicked, it shows Synching folder xyz at the bottom of the screen and then updates that folder in real time to see any recent additions or deletions in the folder.

On this screen I also unchecked Get folder unread count for subscribed folders since that was recommended in a lot of search results I found.  I don't know how much this impacts the speed.

The default setting when adding a new IMAP email account is for the Download complete items including attachments for subscribed folders to be ON.  For smaller mailboxes or ones without too many folders, maybe this is OK, but as the mailbox grows, it adds considerable time to the sync.

With these settings, when clicking Send/Receive All Folders, the sync happens almost instantaneously.

20.9.22

How to use Office 365 shared calendars outside your organization

  1. Open your Outlook calendar, under the list of calendars on the left, select New Calendar.
  2. Label the calendar.
  3. Right click on the calendar name and select Sharing & Permissions.
  4. Add the email address of the external person you want to share with. Since you’re sharing your calendar (the room calendar) with a person outside your organization, you will not be able to give them edit permissions.
  5. Select the level of permissions for shared calendar visibility.
    Can view when I'm busy allows others outside your organization to see only event times. If you’re comfortable with sharing more information, Can view titles & locations details will show Free/Busy time, titles, & location. 
  6. Repeat these steps for each of your room calendars in Office 365.
    If the person you shared the calendar with uses Office 365, Outlook, or another kind of Exchange app they will receive an invitation and be able to add your calendar to their list. 
  7. cross platform permission issues
    These steps on how to use Office 365 shared calendar with external users have a couple limitations for the average organization.
    The above process only works for people also on Exchange or Office 365. Google users can view the calendar via a link emailed from Outlook. However, they will not be able to access your shared calendar invitation without a 3rd party app due to different calendar formats. 



13.9.22

Resolving high disk utilisation in Windows 10

 

Fix Your StorAHCI.sys Driver

According to Microsoft support, Event ID 129, the resets of the disk controller, can be caused by many factors. One of the known ones is that some Advanced Host Controller Interface PCI-Express (AHCI PCIe) models cause these symptoms in Windows 10 when running with the inbox StorAHCI.sys driver.

Due to a firmware bug, the Solid-state drive (SSD) does not properly complete input/output when Message Signalled Interrupt (MSI) mode is enabled. As a result, the Windows storage stack attempts to reset the device after waiting on unresponsive read/write for a period of time.

So, the first solution to fix 100 percent disk usage Windows 10 here is to disable MSI mode via the registry. Follow the guide below:

First Move: Identify if You Are Running the Inbox AHCI Driver (StorAHCI.sys)

Step 1. Press "Win+R" to call out the Run box, then type "devmgmt.msc" and hit Enter.

Step 2. Under "IDE ATA/ATAPI Controllers", right-click "Standard SATA AHCI Controller" and select "Properties".

see the Properties of AHCI controller

Step 3. Navigate to the "Driver" tab and click "Driver Details". If you see "storahci.sys" in the list, you are running the inbox driver.

check if you are running the inbox AHCI driver

Second Move: Disable MSI for the Controller in the Registry

Step 1. In the same properties window, navigate to the "Details" tab and select "Device instance path" from the Property drop-down menu. Please pay attention to the Value that starts with PCI\VEN, which will be useful in Step 3.

pay attention to the value of the Device instance path

Step 2. Open the registry editor by typing "regedit" in the same Run box.

Step 3. Navigate to "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Enum\PCI\<AHCI Controller>\Device Parameters\Interrupt Management\MessageSignaledInterruptProperties", where <AHCI Controller> refers to the device instance path you noticed in Step 1. Then change the value of the MSISupported key from "1" to "0".

change the value data of MSISupported

Reboot the machine and see whether this works 

4.7.22

How to grant access to TeamViewer on your Mac

 If you are starting TeamViewer on your Mac running macOS 10.15 (Catalina) for the first time, you will be prompted with the following dialog:

By default, all permissions are set to Denied. Please give permission to the system capabilities manually to use TeamViewer as desired. If you or others need to access the Mac remotely, Screen Recording and Accessibility are required at a minimum.

To allow the access, click the buttons shown in the dialog. Eg. click Open Full Disk Access Preferences... which will bring you to the Full Disk Access section of the Privacy pane, inside the Security & Privacy preferences:

For the Accessibility access you will need to click the padlock icon in the lower-left corner to make changes. You will be prompted to enter the credentials of an administrator account to continue.

Put a check next to TeamViewer to grant it access:

Repeat the same for Screen Recording and Accessibility if desired. Those are required to control your Mac.

Click again on the padlock in the lower-left corner to prevent further changes.

Now you can close the Security & Privacy window. The next time you want to receive an incoming connection with TeamViewer, the person connecting to your Mac will be able to see and control your screen.

The permission status can be reviewed under Help -> Check system access at any time.