Posted on 1 Comment

How to silence sliding door alarm? Going crazy even when door is shut. | Honda Odyssey Forum

What you have to do is first is to remove the cargo net hooks. They have a little cover that you pry up to expose a Phillips screw head. Remove the tailgate kick/floor plate by simply removing two of the cargo hooks located at each corner and pry gently so as to pry the plate loose of its retainer clicks.
Next you will have to remove the rear lower seat belt and the middle lower seat belt that are both attached to the driver side panel. To remove the seat belt, you will need a 14 mm or 9/16 socket and ratchet. Remove the two bolts and you are nearly done.
Next you will have to open the car-jack compartment and remove the tire iron and the jack handle, leave the jack in its place. You will then see a Phillips screw helping to secure the panel to the wall, remove the screw.
Next you will have to pry the speaker cover off using gentle force and then remove two Philip screws that are holding the speaker in place. Once the speaker is removed and disconnected you will see another Philip screw in behind the speaker that is also used to secure the panel, remove this screw.
The next step is to remove the Phillip screw just below the rear seat latch; this is that “U” shaped piece of iron that is extruding out from the panel. Please note that you do not have to remove this hook, only the rubber cover and possibly any weather stripping that might prevent the removal of the left rear panel.
Next grab the panel firmly at the rear of the vehicle and with a short gentle thrust pull the panel away from the body, be careful not to use excessive force but a certain amount of strength is required to pull the panel away from the wall.

The “BUGGER” of the BUZZARD is located at shoulder level, when seated, near the back of the driver’s side sliding door, if in doubt simply leave the sliding door open and turn the ignition switch to on and with your foot on the brake put the van in gear; the buzzard will sound with all its might. You can disable it by disconnecting the two wire connecter that is about 2 to 3 inches away from the buzzard; follow the wire that is connected to the buzzard if you are not sure. The last step I would recommend is to verify the buzzard has been disconnected by doing the same thing to check for it location…
i.e.; ignition on, foot on brake and put van in gear.

 

Thanks for the details. I just did this today. I didn’t fully take off the panel even though I did everything so I could. I simply pulled the top enough to reach in and push the tab to unplug the piezo buzzer. No more random false alarms. And I still have my dash lights to see if a door is ajar. I took pics while I was at it since I had first searched google for almost an hour and couldn’t find any.

NOTE: You can not reach it via the speaker opening only as suggested in this thread.

DSC_9240e_web2.jpg DSC_9241e_web2.jpg DSC_9242ec_web2.jpg
Source: How to silence sliding door alarm? Going crazy even when door is shut. | Honda Odyssey Forum

Posted on Leave a comment

3 alternatives to building cascading drop-downs in SharePoint – SharePoint Maven

In this article, I share three options for building cascading, menu-driven drop-downs in SharePoint Online/Office 365.

Option 3: Customize in PowerApps

OK, for the real cascading menu, you will need to use Power Apps. It is not something that you can do quickly or easily, like with the options above. You will need to get familiar with Power Apps and some minor coding. Since this falls outside of the “out of the box” solution, I would like to share the technique documented by others who are true experts in this area.

 

Source: 3 alternatives to building cascading drop-downs in SharePoint – SharePoint Maven

Posted on Leave a comment

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

Steps to Change the Data Source of a Pivot Table

To change the data source of an existing pivot table in Excel 2016, you will need to do the following steps:

  1. Select any cell in the pivot table to reveal more pivot table options in the toolbar. In this example, we have selected cell A1 on Sheet2.

    You now should see 2 new tabs appear in the toolbar called Analyze and Design.

    Microsoft Excel

  2. Select the Analyze tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button and select “Change Data Source” from the popup menu.

    Microsoft Excel

  3. When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button.

    Microsoft Excel

    In this example, we want to change the range from Sheet1!$A$1:$F$16 to Sheet1!$A$1:$F$17 because we have added one more row to our data in Sheet1.

    Microsoft Excel

  4. Now when you return to your pivot table, it should automatically refresh the pivot table and display the information from the new data source.

    Microsoft Excel

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

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

Posted on Leave a comment

Remove title header on SharePoint Online – SharePoint Tricks

When creating a new page a header with the title of the page will be shown to the user. In the current days, it’s not possible to remove that header from the page using the SharePoint interface. Today, we will share a PowerShell that allows you to remove that area from the page and some article that you can use with different options.

Replace the variable below with your own and you will have a page without the title header.

$PageName = "PageName"
$LoginUrl = "https://contoso.sharepoint.com/sites/siteName"

Connect-PnPOnline -Url $LoginUrl -UseWebLogin
Set-PnPClientSidePage -Identity $PageName -LayoutType Home

If you intend to remove from all the SitePages use this code, but before you do to all of the Site Pages, I would recommend making some backup. You can use the approach of this article for this.

$LoginUrl = "https://contoso.sharepoint.com/sites/siteName"
Connect-PnPOnline -Url $LoginUrl -UseWebLogin

$pages = (Get-PnPListItem -List SitePages).FieldValues
foreach($page in $pages){
    Set-PnPClientSidePage -Identity $page.FileLeafRef -LayoutType Home
}

 

Source: Remove title header on SharePoint Online – SharePoint Tricks

Posted on Leave a comment

list – How to make a filtered lookup field – SharePoint Stack Exchange

In addition to your “Deactivated” field, create a Calculated field named “ActiveTitle” (or whatever you want to call it). Use the following formula:

=IF(Deactivated,"",Title)

The ActiveTitle field will be empty when the Deactivated field is set. When you configure your lookup column, tell it to use the value from ActiveTitle instead of Title. Empty values will not show up in your lookup list, so you will end up with only the values that are not Deactivated. Let me know if you have any trouble.

Source: list – How to make a filtered lookup field – SharePoint Stack Exchange

Posted on Leave a comment

FIX: SharePoint 2013 Workflow recursion prevention – Part 2 | Microsoft Docs

FIX: SharePoint 2013 Workflow recursion prevention – Part 2

Following FIX: SharePoint 2013 Workflow recursion prevention – Part 1, this post will walk you through the processes of designing your workflow that creates a list item on another list and invokes the workflow associated with that list using the new REST APIs released through SharePoint 2013 May 2014 CU as pointed out in part 1 of this series.  If you haven’t read through part 1 of this series I suggest you do to get some background that will help you appreciate this post.

The scenario:

List1 has a workflow Workflow1 associated with it.

Workflow1 can be set to auto-start on item adding/updating or set to manually start or both, it doesn’t matter.

Source: FIX: SharePoint 2013 Workflow recursion prevention – Part 2 | Microsoft Docs