Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Microsoft Office





Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

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

Sign up to Post

I have latest C2R Office installed in with shared activation a terminal server running 2012R2. From time to time different users lose their office activation and need to reenter their email and password to activate, it's random

sometime it I will get this error

Log: Application
Type: Error
Event: 35
Agent Time: 2017-10-23 10:23:20Z
Event Time: 02:22:58 PM 23-Oct-2017 UTC
Source: SideBySide
Category: None
Username: N/A
Computer: name
Description: Activation context generation failed for "C:\Program Files (x86)\Microsoft Office\root\Office16\lync.exe.Manifest".Error in manifest or policy file "C:\Program Files (x86)\Microsoft Office\root\Office16\UccApi.DLL" on line 1. Component identity found in manifest does not match the identity of the component requested. Reference is UccApi,processorArchitecture="AMD64",type="win32",version="". Definition is UccApi,processorArchitecture="x86",type="win32",version="". Please use sxstrace.exe for detailed diagnosis.

Any idea who to fix it?
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I have a user who when they open up certain Word files, the quotation marks are substituted with another character or letter. I can open the smae document on every other machine in our office (60 machines Win 7 and 10) with no problems.

 I have tried the following:

Reset Font cache
Enabled and Disabled Smart Quotes within word
Ran a repair on Office 2013
Upgraded Office 2013 to Office 2016
Upgraded Windows 7 to Windows 10

Please help
How can I tell if my companies office 2016 standard volume license has hit its user limit?  I can't tell when I look in the MS Volume Licensing Center.

I've had two versions (2010 & 2013) of MS Office installed for many years. For most of that time, I was running Windows 7 and my system was somehow configured so that Excel & Word files would open in version 2010 by default and OneNote would open in version 2013 — which is just what I wanted.

However, since upgrading to Windows 10 several months ago, opening an Excel or Word file from Windows Explorer or Everything Search Utility, etc, results in the corresponding 2013 app opening. The only way to open them in 2010 is to launch the 2010 app first then use:

File > Open > Browse...

Incidentally, I've tried using Open With... but 2010 Office apps are not included among the multiple options.

How can I get back to the original setting so that .xlsx & .docx files open in version 2010 by default?

We currently have one single domain on the enterprise "domain.com", this include AD, Internal DNS, External DNS,  and Office365 with Microsoft. So basically, a user logs into a workstation by authenticating to Active Directory in the house, then open outlooks and check email using user@domain.com and password which are sync to the cloud with office365 from internal domain.

We have a new request. We need an additional domain with email capabilities for 5 users in the office. I need to know what is the easy way to do it as IT oriented, maybe using Office365, and easy way to manage from the end user when emailing from domain.com and newdomain.com.  I appreciate your help.
i have 100 rows, where i need to create a matrix from another 300+ rows.

so, just for row1,  in tab A , I have the following in row 1

          COLA              COLB
row1 26.18599      -80.172721

in tab B, I have this

           COLA              COLB
row1 20.711955      -156.438498
row2   600                       5888

in new tab , i need this

cola                 colB                      COLc                colD
26.18599      -80.172721      20.711955    -156.438498

then in row 2 new tab 3  i need

26.18599      -80.172721      600                      5888

and so on 300+ more rows of tab B against the first row of tab a
then 300 rows of tab against against second row of tab a
and so on

file attached
I've found a few possible solutions to my problem on here but can't apply them properly to my situation...so I would appreciate some new bespoke code

i'm trying to copy and pastespecial information from 1 workbook and paste in into my current workbook

source file: c\users\sarah\documents\the oe\luminite\thankyouforthebusiness.xlsx
sheet 'Sales by Class Detail'
columns a-d

target file is current workbook
sheet 'Imported Data'
columns a-d

Can someone please help?
User whose mailbox is on office 365 cant access his calendars

another user outlook is crashing while opening

what could be the issue
How is the best way to combine two Named Ranges into one Named Range?

nUsrFName = DataRef1!$D$3 = Coach
nUsrLName = DataRef1!$D$4 = Cook
nUserName = ??  
    Thought it would be:
         nUserName  =nUsrFName & nUsrLName, but this does not work. It works with just one of the two...nUserName = nUsrFName...but not both...yet.

I've been struggling for a couple of weeks with the message "out of memory".
Have already created a totally new database and imported all objects. After that, it works well. But after a while, the message "out of memory" suddenly returns when I'am working on the VBA code behind a form. Then I can not do anything else in VBA. Also compiling immediately returns the error message.
Have transferred the form to another db. Then a could work in the form normaly without error. No message "out of memory". Only I can not return this form to the original db. The message appears that the form or code already exists. The only option is to import the form without VBA code (and module to NO) and then take the VBA as text via the VBA editor.
Have gone through all the modules manually. Found two functions that had the same names. This adjusted. After that I can work for a few hour, but then I get again the error message "out of memory".

Does anyone have any experience with this? How can I solve this?

I'am using office 2013 32 bit
Windows 10, 64 bit
Db is ca 250 mb

Concerto's Cloud Advisory Services
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

I have only moderate PowerPoint skills.  I am trying to edit the attached slide, and I do not understand why i cannot resize most of the text boxes.  Please advise and thank you for your assistance.
I have list of unique data in a column and it has multiple colors. I want to read this color and go to another sheet and apply the same color to those data which are duplicated.

i have attached 2 sheet
i want to check the color on first sheet and apply to sheet2 that has the same severname.

this is sample.  i want to do for 1000 of data.

A user is having trouble with her Excel (2016) files

She has many files that contain multiple worksheets e.g. fifty two
These worksheets can contain multiple links to external Excel files

It's no so much the size of the files but rather the number links and worksheets each file contains

Very often when she opens these files, a warning pops up indicating that certain links are no longer valid; apparently she had updated these the previous day (or else before that)

I took the time to to open a file and in effect a message popped up indicating that two linked files weren't available anymore
I looked up the location for one of the sought files and discovered that it wasn't in the designated folder, but in another subfolder
The user promptly indicated that this file didn't have any issues up until now

This situation has been going on for months and it has now become very difficult to talk with this person in light of the frustration and anger that has accumulated as a result of this situation

I disabled, in response to her demands, all the protection options that exist within Excel so that she isn't hampered by confirmation and enabling/activation requests

I don't know what or who to blame for this situation

Is the user to blame because she doesn't know how to properly use Excel ?
Maybe she is updating the links but not saving the files once this update has been accomplished ?

Is Excel losing it's grip and resetting file links to their …
Im interested to know what IT depts and business are doing with the above.
We went the route of Office 2016 product, not subscription for various reasons.

We have sharepoint 2012 foundation on-prem for our intranet.  No sharepoint online licences.  
Skype for business is deployed, but nobody uses it much apart from IT, with odd vidoe conference to a client.  What are people doing here with audting of conversations etc?  
No use of onedrive.

Office 2016 installed on desktops/laptops.
We allow remote access via cisco VPN.

Plan is to roll out sharepoint for a particular dept to share and work on files.  Had a quick look and see you feally need onedrive setup and sync'd in order to share personal docs with people via sharepoint, correct?  Also if wanting to edit the sharepoint/onedrive docs we need office online, correct?
Can we share unc paths or mapped server drives to onedrive and sharepoint?

Pointers? Ideas?

I am furious that this has to be so difficult.

I am using Office 2016 x64 on Windows 7

I have CSV files that can potentially have multiple language characters in them. They are encoded in UTF-8 and separated by commas.

I want to be able to double click on them to open them nicely and start working (like OpenOffice.org does).

I got around Excel not understanding commas by changing my whole Windows default separators (which is dumb, but it worked).
I though I could get around Excel not understanding the UTF-8 by changing the registry like they explain here. However, that only changes the Default option of the dropdown called "File origin" in the Import method (Data Tab > Get External Data > From Text). While this is a useful step, it still needs me to go through the menu browsing instead of just double clicking the CSV file in the file explorer.
I then said frack it and I resorted to create a Macro for which I would put a custom button on the ribbon. I wrote the following macro, making sure to put "Origin:=65001" BUT IT STILL DOES NOT WORK.

 Copy to clipboard
Sub Open_CSV_UTF_8()

   filetoopen = Application.GetOpenFilename("Text Files (*.txt;*.csv), *.txt;*.csv")
   If filetoopen = Null Or filetoopen = Empty Then Exit Sub

   Workbooks.OpenText Filename:=filetoopen, _
   Origin:=65001, DataType:=xlDelimited, Comma:=True

End Sub
When I click my custom button, a dialog box appears to select the CSV file I want to open. I select it …
Hi, I have a UserForm which allows the user to browse, search, update and add records to a dataset, and some of the cells in the dataset contain formulas which are critical for the user to see.  I have locked the corresponding fields in the form to prevent the user from overwriting the formula but when Update and Add are used it overwrites the formula – Add leaves the cell blank and Update overwrites the cell contents with the result of the formula.  As you can see below it is mainly Lookup and IF's.

txtSICDesc      =IFERROR(VLOOKUP(F2,SICCodes!A:E,5,0),"")
txtMaterials      =IFERROR(VLOOKUP(F2,SICCodes!A:C,3,0),"")
txtDeal      =VLOOKUP(AE2,'Deals lookup'!A:B,2,0)
txtEUse      =HLOOKUP(IF(AND(F2>=10110,F2<=32990),VLOOKUP(F2,SICCodes!A:F,6,0)),'Combined Use'!$C$5:$AL$49,45,0)*AY2
txtEofTO      =AG2/AY2
txtERating      =IF(AG2>=1000,"High",IF(AG2>200,"Medium","Low"))
txtRUse      =HLOOKUP(IF(AND(F2>=10110,F2<=32990),VLOOKUP(F2,SICCodes!A:F,6,0)),'Combined Use'!$C$5:$AL$49,40)*AY2
txtRofTO      =AJ2/AY2
txtRRating      =IF(AJ2>=10000,"High",IF(AJ2>2000,"Medium","Low"))
txtEmpLAY      =IFERROR(INDEX(AO2:AW2,MATCH(TRUE,INDEX((AO2:AW2<>0),0),0)),)
txtHeadcount      =IF(AND(AN2<=250,AN2>=50),"50-250",IF(AN2<50,"<50",">250"))
txtBalLAY      =IFERROR(INDEX(BJ2:BR2,MATCH(TRUE,INDEX((BJ2:BR2<>0),0),0)),)
txtSites      =IF(BS2>=2,"Multi",IF(BX2>=2,"Multi",IF(BW2="Yes","Multi","Single")))
txtOrgCat      …

My name is Faus from the Philippines and I was looking for excel experts who can help with my report, and I found your web! :D

I have this report where 75% of it is manually inputted. I also have to manually edit the formulas on a monthly basis.
To give you a sample, during January I had $10,000 net income.
But I can only get the cash after 51 days, and at the last day of the month only.
So every last day of every month, I need to compute how much cash I can get from the 10,000 earned last January, based on 48 days. If the 48th day falls in the middle of month, the cash will be divided and paid into two separate months.

Sample computation:

January  - 31 Days - 31 days Total 10,000 income - No cash Yet
February - 28 Days - 59 days total (Can now get 11 days worth of cash, 59-48 days) (I get 11*10,000/31 days =   3,548.39)  
March    - 31 Days - 90 days total (can now get 20 days worth of cash, 31 - 11 days) (I get 20*10,000/31 days  =   6,451.61)

Above scenario is repeated every month. Attached google sheet is my report with above scenario.
Also, the 48 days delay, will be changed every quarter.

This is very manual which I'm fine of, but I believe that there are a lot of things excel can do that I haven't discovered yet. So this is why I'm asking for your help. Thanks.
On my main sheet, I have this information of a balance of $1000 dollar that has to be paid . on another sheet I  have all his monthly payments where he is to pay of $100 per month to pay the$1000.These payments are entered on this another sheet.How can I link the two sheets so then I can automatically have the figure showing on the first sheet the updated balance.Please explain clearly and give me the best and shortest excel method.
I tried this substitute formula to replace the decimal separator (. to a ,), but it does not work:

=SUBSTITUTE(H8/-('Innestående; totalt förvaltat'!G2+'Innestående; totalt förvaltat'!K2+'Innestående; totalt förvaltat'!O2+'Innestående; totalt förvaltat'!S2+'Innestående; totalt förvaltat'!W2+'Innestående; totalt förvaltat'!AA2+'Innestående; totalt förvaltat'!AE2+'Innestående; totalt förvaltat'!AI2+'Innestående; totalt förvaltat'!AM2+'Innestående; totalt förvaltat'!AQ2+'Innestående; totalt förvaltat'!AU2+'Innestående; totalt förvaltat'!AY2+'Innestående; totalt förvaltat'!A17);".";",")

(I use semicolon instead of comma for separating elements in a formula.)

All the other part of my formula is correct, it's only when I add the substitute part and the last part with . and , that it gets completely wrong result.

How should I change it?
Free Backup Tool for VMware and Hyper-V
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

This is related to the brand-new Office 365 app - To-Do. Not related to Outlook To Do items.

As it is brand-new, I can't find any info on it, but just want to know how to create To-Do items in Access VBA please?

For more info, this should help: https://todo.microsoft.com/en-us
In Excel 2007, how do I restore the grey bar up to the right so I can split window vertically only?

In this demonstration (forward to 3.48) he says there is a small grey bar I should click on so I can then drag to the position where I want to vertically split the window:


But I don't have any such small grey bar. I have the view tab window active as he has, but still don't have this small grey bar in my Excel.
In Excel 2007, how do I get the minus sign entered immediately before the number? Can I custom format like that?
I have a Word doc that's 258MB and when I Save As a PDF it gets inflated to over 700 MB. But, I had someone help me with the layout and that person exports to PDF where the file size is about 6 MB.

What's going on?

How can that be?

Today we were doing a new firewall install, the old firewall is a cisco ASA 5510 that was going to be replaced by a Sonicwall TZ 400(This was happening at 2 locations, the main office and the Colo).
The install was a bust and we were switching back to the Cisco, now upon switching back we cannot get virtual machines at the Colo to work, their office is up and running without issue, or any computer to use a couple IP addresses. Example LAN IP:
(it doesn't matter what the DNS is set to whether it is a public google/xfinity or to a DNS server that's local)
The systems cannot reach the outside network whatsoever
We have tried rebooting all network equipment
tried running netsh winsock reset
rebooting systems multiple times
destroying VM Switch adapter and recreating
investigated Cisco Firewall and no rules are in place stopping it.
The Cisco did show that from the inside out it is fine, but from outside in (Google dns to local ip) fails and defaults to the basic deny rule.
I have exhausted every resource I have and I am just short of going and sacrificing live chickens to the IT gods.
Please someone save me from this nightmare.
When I use Save As PDF I get this error on many sections and have clicked Yes, since this is a trial run. But I hope to create a printable book version very soon.

How do I find the spots which are outside the printable areas?

Margin error
Also, how can I navigate inside Word to a given Section? The error references a specific section.


Microsoft Office





Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.