Tag Archives: microsoft excel

Microsoft Office – (Product Activation Failed)

Posted on by

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 simple to fix.

1. In this Example I’m using Outlook but select > File > Help > Change Product Key.

2. Enter a valid Office 2010 key > Continue > Follow the on-screen prompts.

3. When finished, restart Outlook and it will prompt you to activate, again follow the instructions.

4. When complete it should say “Thank You. You copy of Microsoft Office {version} is activated” > Restart your Office applications to remove the red warning bar.

 

Related Articles, References, Credits, or External Links

NA

 

Microsoft Excel – SGXLADDIN.dll could not be found

Posted on by

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 Excel Integration” > Go.

2. Untick sgxladdin > OK > Yes.

3. Now restart Excel and you should be error free.

 

Related Articles, References, Credits, or External Links

NA

Excel – IP Address Formula for ‘Auto fill’

Posted on by

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 increase.

So simply change the figures in red below, drop the formula into a cell on your spreadsheet then use the auto fill option.

Excel IP Addresses Increment the First Octet

[box]
=””&ROWS($A$1:A10)&”.1.1.0“[/box]

Excel IP Addresses Increment the Second Octet

[box] =”10.“&ROWS($A$1:A1)&”.1.1“[/box]

Excel IP Addresses Increment the Third Octet

[box] =”10.1.“&ROWS($A$1:A1)&”.1“[/box]

Excel IP Addresses Increment the Fourth Octet

[box] =”10.1.1.“&ROWS($A$1:A1)[/box]

 

 

Related Articles, References, Credits, or External Links

Excel: Calculate Cost, Margin, Sell Price

Excel – Creating a Dropdown Box ‘From data on another sheet’