(Mac Users): When I go to update the data source setting so that the Dashboard will work, I get a message that says: Microsoft.Mashup.Container wants to use your confidential information stored in “Microsoft.Office.Excel.ProtectedDataServices” in your keychain.
To resolve this, when the spreadsheet is first opened, the status bar in Excel warns you about external data connections, and it’s important to click on “Enable Content” (that button appears on the far-right side of the Excel screen). Next, when you visit the “Data” menu and pick “Data Source Settings…” you might get the Microsoft.Mashup.Container.app pop-up message. You’ll need to put in your Mac password and click on “Always Allow” to make it go away and get things working.
Here are a few articles from trusted sources about this keychain pop-up if there are concerns: Microsoft support article / Microsoft community article