Sat 04 Mar 2017

Tips & Tricks 157 - Search for Online Templates Greyed Out / Disabled

By |Saturday, March 04th, 2017|Categories: Tips and Tricks|Tags: , , , , |0 Comments

When we create a new workbook through File > New, we get a box where we can search for online templates. But, at times, it may be greyed out or disabled i.e. you can not type out anything out there.


To correct this, you need to enable internet setting for Excel.

File > Options (You can also invoke Excel options through shortcut ALT+T+O) > Trust Center > Trust Center Settings > Privacy Options > Allow Office to connect to Internet and Check this box.


Tue 04 Aug 2015

Article 20 - Miscellaneous Errors in Excel - Sending Command to Excel, Greyed Out Options (Not Applicable to Windows 10)

By |Tuesday, August 04th, 2015|Categories: Articles|Tags: , , , , , , , |0 Comments

Over a period of time, Excel has become a complex piece of software. Many new features have been introduced and on top of that increasing requirement for security has introduced further complexity for Excel developers.

Many times, users report many different kind of errors while using Excel. Following are the common ones -

1. An error occurred when sending commands to the program
2. Microsoft Excel has stopped working
3. Excel is not responding
4. A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.
5. Some options missed out / greyed out in tab or right click - Copy and Paste Greyed out (more…)