Excel: Calculate Cost, Margin, Sell Price
KB ID 0001835 Problem Occasionally at work I need to work out what the sale price / retail price will be for something would be (given that I know the cost and the % margin). That’s easy to work out. But sometimes I get given the sell / retail price and I know the margin used, and I then must work out what the cost will be. Ordinarily if it’s a quick question I’ll just use and online margin calculator. But if I have a LOT of...
MS Teams Notifications Missing (macOS)
Teams Notifications KB ID 0001803 Problem I’ve put up with this for a while, my business pretty much runs on Teams now, so when theres no notification badges on the Teams icon (in the Dock), my response times can be ‘not great’. In fact, usually I get my head down into a job, and check Teams just to see a ‘ton’ of messages that need my input. (Some might think that’s a good way to work,) but when...
Completely Remove Teams From macOS
Remove Teams KB ID 0001789 Problem I started to notice the performance in my Microsoft Teams was getting ‘very sketchy’, this week while in the office a colleague on the same teams call as myself told me my speech in the call was lagging about 10 seconds behind my actual speech! So I thought I’d remove and reinstall MS Teams, Uninstalling the application is simple as peas! But I wanted to remove EVERYTHING to give...
Outlook OAB download fails with 0x80004005 and/or 0x8004010F
KB ID 0000035 Problem 0x8004010F is caused by client not being able to see the Offline Address Book. 0x8004010F Error With Exchange 2013/2016/2019 Firstly make sure your autodiscover is correct, on the Exchange server open the Exchange management shell, and issue the following command. Get-clientAccessServer | fl Name,AutoDiscoverServiceInternalUri If you need to fix/change it, use the following syntax. Set-ClientAccessServer...
macOS: Microsoft Outlook Search Broken
KB ID 0001754 Problem I’ve had to contend with Outlook Search Broken on Windows clients many times, but not being able to search my ‘sent’ and ‘deleted’ items has a detrimental effect on my productivity. Outlook Search Broken Fix This can happen if the folder/drive that your Outlook profile is in is Blocked/Prevented access by ‘Spotlight’ but in my case that wasn’t the problem. Close...
Outlook URL Shortening?
KB ID 0001735 Problem Outlook URL: I first noticed this a few weeks ago, When copying and pasting a URL into an email it shortens the URL and gives it the pages title. At first i thought my firms Devs had changed the way our CRM works, but then I noticed it happening with SharePoint URLs as well, this is what I mean; I don’t have a problem with it, in fact I much prefer it! However I got an email this morning from someone...