Sun 26 Mar 2017

Article 44 - Not able to open .xls file after upgrading to Excel 2016 / Windows 10

By |Sunday, March 26th, 2017|Categories: Articles|Tags: , , , , , |0 Comments

The problem of .xls file not getting opened after upgrading to Excel 2016 / Windows 10 is a common problem. This problem may occur after any windows / MS Office update as well.

1. Start the Excel and CTRL+O (or File > Open) > Locate the file and open the file. This should open the file but thisĀ  may not solve the problem of double clicking the file and opening it.

2.A quick repair usually fixes the file association

https://support.office.com/en-NZ/Article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

3. If this doesn't fix the association, when you right click on .xls file > Open With > You should get the list of programs which can open this file and you should select Excel.

In case, the list of program doesn't have Excel, then choose BROWSE and select Excel.exe. But, in case the folder which you get after clicking BROWSE doesn't have Excel.exe, you will need to find the location of Excel.exe to select Excel.exe. To find the path, you can refer to below link -

http://eforexcel.com/wp/tips-tricks-147-find-the-location-of-excel-exe/

1

4. If there is a file block issue

4.1 Right Click on the file > Properties > In the General tab, you will get Unblock option down below > Check the unblock box

4.2 If you don't get unblock option, ALT+T+O (or File > Options) > Trust Center > Trust Center Settings > File Block Settings > Uncheck the box in front of .xls file

1

Sat 25 Mar 2017

Solution - Challenge 60 - Generate a list of 2nd and 4th Saturdays for a Year

By |Saturday, March 25th, 2017|Categories: Solutions|Tags: , , , , , , , , |0 Comments

Below is a possible solution to the challenge - Challenge 60 - Generate a list of 2nd and 4th Saturdays for a Year

Drag the below formula down

=IF(ROWS($1:1)<25,FLOOR(DATE($A$1,ROUNDUP(ROWS($1:1)/2,0),
2*(MOD(ROWS($1:1)-1,2)+1)*7),7),"")

Sat 18 Mar 2017

Downloads 13 - Template 11 - Invoice Template

By |Saturday, March 18th, 2017|Categories: Downloads|Tags: , , , , , , , , , , |0 Comments

The invoice template is specifically designed for Service Invoices in India but this can be used anywhere in the world with little customization.

There are two templates, one which populates the amount in words in Rupees and Paise and one which populates in Dollar and Cents. If you need to change these currencies, you can write to me to change them.

(more…)

Sat 11 Mar 2017

Excel Quiz 50

By |Saturday, March 11th, 2017|Categories: Quizzes|Tags: , , , , |0 Comments

Excel Quiz 50 - A Quiz on Insert Tab in Excel

This checks your knowledge on Insert tab in Excel.

Sat 04 Mar 2017

Solution - Challenge 59 - Clean the Problem Workbook Data

By |Saturday, March 04th, 2017|Categories: Solutions|Tags: , , , , , |0 Comments

Below is a possible solution to the problem Challenge 59 - Clean the Problem Workbook Data

Formula to convert would be which you need to drag down would be

=--SUBSTITUTE(SUBSTITUTE(A2,UNICHAR(8237),""),UNICHAR(8236),"")

Data has UNICHAR(8237) and UNICHAR(8236) prefixed and suffixed which need to be replaced by above formula.

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.

1

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.

1