[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Microsoft Applications





Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post


I have a problem with office professional plus 2016. They get the activation key with a MAK key and it works fine.

I've been installing them on many computers and my problem is on computers with windows 10 with a preinstalled office version.

First I have uninstalled it, using the tool of Microsoft since the uninstallation is not present in the add/remove software of the control panel.

Then after restarting the computer, I install it and if I look in "account", I see this

Then, the next day, I get this

and this

So I try to re-enter the key, but activation fails. If I uninstall everything, and re-install it, it works for one day and the the problem occurs again.

I've notice that the limitation date changes every day, and even though its says that most features will be disables, it stays fully functional.

Thank you for your help.
Introduction to R
LVL 12
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

I am trying to convert height in inches to feet and inches to display on a SSRS 2012 report  like 5"8'  from 69.00 inches. I have the formula below that isn't showing up correctly the digits to the right of the decimal. For 69.00, it shows 5"0'.

HGT = concat(convert(int,min(HGTTO)/12),  '"', convert(int,min(HGTTO)/12) % 1,'''')

Hey all,

I have a client who has moved from their standard IMAP email hosting to G-Suite. I have configured google sync client and set up correctly and added a personal live.com email account to his account. He requested to have autocomplete moved across which was an easy fix but then found out a few days later live & google sync don't like working with each other, so I have had to remove his live account. This in turn removed the autocomplete settings also. I was thinking of creating a yahoo account or similar (but this was a joke of process) so I am left now without his autocomplete.

He really should have these as contacts (i know) but I would like to try and help him out. Any thoughts on 1) being able to migrate autocomplete contacts 2) saving his autocomplete contacts.

I was advised to use Cntrl + Shift + F9 to unhide a hidden tab (that is password protected) on an excel 2013 document.  That is not working - please advise if there is another way to unhide a tab. I do have the password.

I'm on Excel 2016:  I recall I ever see in older Excel there's a way to import
by "space separated" but I can't locate it currently.

Anyone can give me step by step instruction on how to do this?

I have a text file (output from  'net user /domain > file.txt') that has 3
columns of text, the 3 columns are separated by spaces

After that would like a macro that reads in the 3 column data that will
automatically move columns 2 & 3 to be under column 1 , resulting in
a single column of data & if saving can be automated, save as text
HI Guys

Hope you can help

Ive been trying to use SUMIF, SUM PRODUCT with FREQUENCY and MATCH to sum the quantities in stock locations but ignoring duplicate entries

I have column A and Column B - column A has the stock location which can be repeated several times with the unique stock quantity against the location in Column B

Ive tried creating a formula to sum the quantities in Column B but only for each unique location so for example, if in column A Stock Location PB12345 is repeated 6 times and has a quantiity of 500 - when the SUMIF runs through the the two columns, it only includes the sum of 500 from PB12345 once and not include the six times its repeated

Ive attached a sample file and the desired result in cell F1 - the formula im using shows how many times its repeated but not the sum ?

If you could help I would be very grateful

I installed Snip and Sketch from Microsoft Apps Store. Then I looked for it in the apps and it was not there. The store says it is owned and install button is greyed out. The recommended requirements are version 17636. Under system information, it says that I have version 17134. I did windows update to version 1803 yet it still shows that I have version 17134 and the snip and sketch app is nowhere to be found. Someone help me, please.


Hope someone can help me with this.

I have a Excel workbook containing two sheet.

On the Company sheet, I am capturing Company Name, Sector and Size. The company name of each company is unique.

On Page 1, using a drop down list, we need to be able to select the company name from the list, and enter some data underneath.

The issue I have is that I need some validation to prevent users from choosing  the same company name more than once from the list on that sheet.

Can someone please suggest a way of doing it, as I am stumped ?



I have a Excel formula problem, my Excel formula knowledge is not good. Please refer to my attached JPG file.


What is my error on cell F2? I want to get a result (IF cell A2 = "AA" , E12 will X L1. IF cell A2 = "BB" , E12 will X L2. IF cell A2 = "CC" , E12 will X L3.)

Asus T100 10" Laptop
Windows 8.1
Foxit PDF Editor/Reader
AutoHotKey Software

When using Foxit PDF reader, I need to magnify the document's text. This means I must scroll or pan left and right to view all the text. Foxit does not have any keys to pan left and right. I would like to use the Left and Right Arrow Keys to pan left and right when using Foxit.

Can someone help me to assign the desired behavior to the Left and Right Arrow keys by remapping the keyboard? Can you help me write the script using the AutoHotKey software? If you have another solution that works, I'd like to know about it as well. Can the remapping be in effect only when in Foxit?
IT Pros Agree: AI and Machine Learning Key
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Windows 8.1
Asus T100 10" Notebook

Foxit PDF Reader (Free Version) 9.3
In order to use the keyboard shortcut to pan left and right, when the screen is zoomed in, I had to disable Windows Hot Keys so that CTRL+ALT+ARROW would not rotate the screen. (My previous EE post focused on that problem.)

Is it possible to assign a different Hot Key combination (other than ctrl+alt+arrow) that allows you to scroll (or pan) left or right in Foxit? Can you assign just the Left and Right Arrow keys without the control keys? That makes it so much easier to use the arrow keys to navigate the page with one hand.
On my work computer w/Windows 10, when I open Task Manager, the computer hangs.
Windows 8.1
ASUS T100 Notebook (10 inch screen)

The problem I am trying to solve is difficult to search for on Google.

Problem (1): (SOLVED)
I need a magnifying glass app to enlarge the font on my small screen.
> > > > The native app that comes with Windows 8 is adequate for this issue.

Problem (2): When I read a paragraph that is enlarged, the text overflows out of the magnified reading area. This can be text in a PDF reader, text in a Word document, or text in the browser. (These may not be only text but text plus images, usually.)
Can you help me find a tool or utility or application (.exe) that runs on the Windows Desktop that will re-flow the paragraphs of a page so the text does not overflow the viewing area (allows it to wrap, perhaps) when either using the zoom feature (such as two finger gesture) or a magnifier?
1) both  the files are located in same place i.e.    C:\Users\Sholtan\Desktop
2)vba code will be placed in analyser.xlsb
3)Important  xlsx file name may differ
1)open xlsx file
go to U column
apply the formula as shown in the xlsx file
2) go to V column
apply the formula as shown in the xlsx file
and save the xlsx file and close it
Convert Csv file to xlsx and delete that csv file
1)Both the files are located in same place  that is C:\Users\Sholtan\Desktop
2)the name of the csv file may differ
3)My vba code will be placed in Analyser.xlsb
I need help with VBA that is automatic "like worksheet change event" that if all of the rows for column result in zero then hide the column. otherwise unhide all column where one or more rows has value other than zero.

I have attached example file.
How do I convert the data below using a pivot table. If this can not be done with a pivot, then what is the fastest VBA code that can do the same thing.


     A          B
Tommy    98
Tommy    90
Tommy    22
Larry        12
Larry        99
Billy          52
Joe            34
Joe            55
Joe            67
Joe            96


Tommy   98   90   22
Larry       12   99
Billy         52
Joe           34   55   67   96
what would be some useful checks to include in an audit/health check of SharePoint (and document management in general). The obvious one we can think of is around permissions of documents stored in SharePoint, to ensure sensitive documents are only accessible by the approved users/groups - but I wanted to spread the review a but further, and was hoping for some inspiration on what above and beyond security permissions would be useful when looking at such a system (it doesn't have to all be about security). Any common SharePoint mistakes/risks above and beyond permissions also most useful,
I'm looking for software that will allow me to use a key combination or method to launch software such as Google Chrome minimized.

For example, while I am using my Windows 10 laptop (with only the built-in LCD display, while it isn't connected to an external monitor) I will click on a link within an Experts Exhcnage email within Outlook 2016 and Google Chrome will then launch maximized. I would like a way of quickly being able to set Google Chrome to launch minimized so that these Experts Exchange links will launch and then when I am ready to read them I can click on the Google Chrome icon in the taskbar to maximize Google Chrome.

This will also be helpful when either opening other file attachments (such as Microsoft Office file attachments within Outlook or files within Windows Explorer).

Being able to press a certain key combination or enabling this setting and then disabling it when I don't want this to be done will be very helpful.

What applications, utilities or methods will allow this to be done?
HTML5 and CSS3 Fundamentals
LVL 12
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I am looking for a method, utility or website to list how many times specific words are used in a Word document.

For example, I tend to overuse the word "Perform" when there are other suitable synonyms that can be used instead of "Perform."

So I am looking for a way of analyzing a Word document (or by copying and pasting the text) to give me a complete list of which unique words were used and how many times each word was used so I can discover trends in my writing and words that are being overused and can be replaced by synonyms to make my writing less monotonous and to give more variety and make my writing my descriptive and prolific.

I will gladly pay for such software or service that will allow this to be done.

What are the best ways of doing this?
How can I include the file contents contained with my Windows 10 Box Drive folder in Windows searches?

I am using the default Windows 10 Box drive folder location of %userprofile%\Box.

Currently whenever I search for files within Windows Explorer the files contained within Box Drive aren't included in this search and even if I go into the Box Drive folder (which is C:\Users\djones\Box on my Windows 10 computers) and perform searches for these files using their exact or partial files names these files ARE NOT listed in the search.

I have the Windows Search configured to include ALL folder locations on my computer's C: drive but when I look at the folder structure within the Windows search I see that the Box Drive folder of %userprofile%\Box (which on my computers is C:\Users\djones\Box) is NOT included.

So currently I have to log on to my Box account within a web browser to perform these types of searches.

How can I fix this so that when I perform searches the contents of the Box Drive folder WILL BE INCLUDED?
I can connect to my remote apps and run them locally but not outside of our network. Gateway server cannot be accessed when trying the run the app. Before it was my certificate didn’t match but I don’t get that message anymore.
To remove duplicate line if this line is based on a repeated route and also add 'Y' in column F to indicate that the next line was removed.

One can filter column b, c and d to be all equal to 0 and will see all the same route appear in column A.

See attached for detailed examples and comments.

And of course if there are more than 1 duplicates meaning like this:

108.004.600 - 108.004.600      0      0      0      84.75291788  
108.004.600 - 108.004.600      0      0      0      1.968908303  
108.004.600 - 108.004.600      0      0      0      2.417233924  
108.004.600 - 108.004.600      0      0      0      1.713124927  

then the result should be like this (3 lines below are removed) :
108.004.600 - 108.004.600      0      0      0      84.75291788   Y

and column G states how many lines were removed.

if there is no duplicate, for example:
405.091.200 - 405.091.200      0      0      0      6.337535366

then do nothing for this line.

Same concept applies to all.

Thanks !
Has anyone had experience on converting PDF files to Visio 2016?  I lost my folder that had all my Campus Visio Diagrams but have the PDF versions.  Any help here would be appreciated.
Wanted to get the abbreviated month name based on a date.

In column J is the date and in columns N,O,P I wanted the abbreviated month listed based on the year.  

Please see attachment for example.

Microsoft Applications





Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.