Microsoft Office – (Product Activation Failed)
Nov17

Microsoft Office – (Product Activation Failed)

KB ID 0000548  Problem Fired up one of my test machines this morning, and opened Outlook to see, Error: Microsoft Outlook (Product Activation Failed) Though if you open other applications you will get the same; Error: Microsoft Word (Product Activation Failed) Error: Microsoft Excel (Product Activation Failed) etc. Solution I’m not sure why this happened, (perhaps I entered the wrong key when I installed it). But it’s...

Read More

Microsoft Excel – SGXLADDIN.dll could not be found

KB ID 0000505  Problem Seen when launching Microsoft Excel.. Error: ‘C:WindowsSysWOW64SGXLADDIN.dll’ could not be found, Check the spelling of the file name, and verify that the file location is correct. Solution You are seeing this because you have installed a Sage accounting product in the past and it dropped some add-ins into Excel. 1. Close the error > Click File> Options > Add-Ins > Select the “Sage...

Read More
Excel – IP Address Formula for ‘Auto fill’
Nov17

Excel – IP Address Formula for ‘Auto fill’

KB ID 0000928  Problem I got asked this week if I know how to do this, a colleague was doing a spreadsheet, and needed to quickly put in IP addresses. The Problem is if you use ‘Auto Fill’ to continue your IP addresses, it does not behave quite like you would expect. Solution A quick search got me most of the way there, but the solution is different depending on which ‘octet’ of the IP address you want to...

Read More