Most people do not need to know the exact version (nor do they care). But in case you are troubleshooting a problem with Office, you will need to know the version.
Finding the exact version is a funny story. Why? Because the version is shown somewhere in some menu. Over time, that menu itself has been changed and moved around. Therefore, the answer to the question “Which version do I have?” is “You have to go to place x, depending upon the version you have”.
That does not make any sense. Therefore, it is a visual answer. You have to literally look at the way Office looks (Word, Excel , etc. ) and then figure out where the version is mentioned.
Microsoft has written a detailed article with screen shots to answer this question. Here is the link Which Office version do I have?. This shows various screen shots. You open a file in Word and compare the screenshots to find the version.
Funny but true.
I had both these problems. I am using Office Insider – Fast track for Office Pro Plus. I tried all kinds of things but nothing worked. Full repair, complete uninstall and reinstall, reapply Windows patches, reinstalled .net framework, escalated to MS. No use.
The solution was very simple. I went to Excel – Customize Quick Access Toolbar. At the bottom right corner I chose – Reset – Reset All Customizations. That’s it. Both problems solved.
I myself do not know why it worked. But it did. If you have the same issues, try this one.
SFB audio problems are common. In any meeting, irrespective of the technology or tool, we always spend time asking people “Can you hear me?”. Most of us do not realize how hilarious and funny this question is!
Those who cannot hear you can’t hear your question as well!
Here is how you can handle the SFB audio problem in a smart and speedy manner.
Continue reading SFB audio joke – “Can you hear me?”
This works for all Office products. When things go wrong or the application starts very slowly, or gets hung while starting or misbehaves in any way, it is worth trying starting it in SAFE mode. How do you do that? Simple.
Press CTRL key while clicking on the Office Application Icon. It will ask you if you want Safe mode. Choose Yes.
Another method is to use a command-line switch – more useful to techies. Press Windows Key and R. The run dialog opens. Write the application name followed by /safe and press Enter. For example:
Here are the exact application names for all products:
winword, excel, powerpnt, outlook, mspub, msaccess, onenote
It opens the application with no customization. All your custom settings are replaced with default settings. No add-ins are loaded. This usually makes the application start very quickly. And now you can troubleshoot which item or setting is causing the problem.
Starting in safe mode is NOT a permanent solution. It is usually the first step in troubleshooting causes of application instability or crashes.
The Need: Trace Dependents
Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file has left the organization long back. There is never any documentation available about exactly how a file works.
Due to all this, it is almost impossible to remember which value is used in which formula. When you are about to change a value or add more data to existing block, it is absolutely necessary to ensure that all the related formulas are updated. If you forget to update the formula, the results shown there will be outdated and WRONG. This can hamper decisions and can have severe side effects.
What we need is a way to find out which formulas to update when any data changes or grows. Excel has provided this facility since 25 years. Unfortunately, very few people are even aware of it – leave alone using it!
Continue reading Excel – Impact Analysis – Trace Dependents
Office 2013 can be installed using two completely different ways.
These two methods DO NOT work together.
Read on to find out more.
Estimated reading time 6 min
Continue reading Office 2013 running too slowly, erratically? This could be the reason.
Here is something I learnt the hard way today … If you use Live Writer to blog to WordPress, you will benefit from what I learnt.
I use Live Writer for blogging to WordPress. I love it – brilliant tool. I have posted 120+ blogs so far. This one had many images. When I posted the draft I got this error.
Continue reading What did I learn today: Live Writer “Bug”