Cookies that cause Error 400 Bad Request when accessing Microsoft websites

For those people who interact with many sites across the *.Microsoft.com domain this may be an issue. I was looking for an update on Office Add-Ins and I came across this issue.

If you see a 400 Bad Request Size of a header exceeds the limit error, for no good apparent reason, that cause is likely cookies.

The following image was taken from just trying to access the Microsoft 365 Blog site. As you can see there are a LOT of cookies picked up from all over the MS domain.

The simple solution, clear your cookies. This process will vary per browser but once that is done, we are in business again.

 

NOTE

Microsoft is not the only company with this issue as I wrote about before 🙂

Advertisements

Office Add-ins community call

“The Office Add-ins community call is our quarterly event for developers to connect in real-time with the folks who are building the Office Add-ins platform and JavaScript APIs.”

The fact that we have a general office Add-in community call now is fantastic and shows how significant the community is to the product group.

The call was blogged and posted here: https://dev.office.com/blogs/office-add-ins-community-call-april-11-2018

The next Office Add-ins community call will be on Wednesday, July 11, 2018. You can download a recurring quarterly calendar invite at https://aka.ms/officeaddinscommunitycall.

 

Problems with Miracast? Could be a display adapter driver…….Solved

We use Miracast in the office to connect to the Tvs in the conference rooms. I used it for months without issue and then a few weeks ago it stopeed working for no good reason.

The display would say I was actually connected – and it would not come up on the TV. Eventually it would just die and tell me I had a problem.

After a considerable amount of trial and error it turned out to be the intel display adapter driver….ok then. Figured I should share.

  • Right click on the desktop
  • Display settings
  • Find display adapter properties

 

  • Properties
  • Update Driver

 

And after that and a reboot – Miracast back and working !!!

 

 

Create custom functions in Excel

As of MS Build 2018 custom functions in Excel are available for all developers to use and implement.

https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel

For more information on how to create a custom function in Excel using the JavaScript Add-In model check out this link.

https://aka.ms/customfunctions

“Custom functions (similar to user-defined functions, or UDFs), enable developers to add any JavaScript function to Excel using an add-in. Users can then access custom functions like any other native function in Excel (such as =SUM()).”

This is actually a huge deal because one of the limitations of the Add-In model in the past is this ability to create a custom function without having to add it to the tool bar as an icon which has to be clicked. With this release it means that develoipers can create their own functions in excel in an analogous manner to VBA. The simple example below adds the two numbers and for no good reason adds 42 as well. But you get the idea.

custom functions

 

 

 

Outlook Add-ins community call

Back in March the Outlook Add-In development community had it’s quarterly meeting. The notes from the meeting were blogged and released here: https://dev.office.com/blogs/outlook-community-call-march-21-2018.

These calls are really helpful to spread the new on the progress being made in the Outlook Add-In area. Some really interesting points of notes at this call were the upcoming preview requirements for API 1.6

https://dev.office.com/reference/add-ins/outlook/preview/index?product=outlook&version=preview

I have a particular selfish interest in the “Office.context.auth.getAccessTokenAsync – Added access to getAccessTokenAsync, which allows add-ins to get an access token for the Microsoft Graph API.”

I think I am going to play with that 🙂

Next call will be at 8:00AM PST on June 20, 2018. https://aka.ms/outlookcommunitycall