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: , , , , , |1 Comment

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 10 Dec 2016

Tips & Tricks 151 - Saving in ODS (OpenDocument Spreadsheet) but Don't Need Excel Warning Message - "Do you want....."

By |Saturday, December 10th, 2016|Categories: Tips and Tricks|Tags: , , , , , , , , , , |0 Comments

Question - Sometimes, I may require to work in different Office Suites and to maintain compatibility, I use Open Document Format. But whenever, I save in Open Document Format (ODS - OpenDocument Spreadsheet), I get the Excel warning like below. I don't need this. What is the way out?

1

Answer - This requires a registry hack, hence you need to take the backup of your registry first. Also, if you are not comfortable with modifying your registry, don't proceed.

For backing up your registry and restoring in case of any issue - https://support.microsoft.com/en-us/kb/322756

1. Press Windows +R, type regedit and press Enter.
2. Navigate to the following location:
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
(In case of Excel 2013, replace 16.0 with 15.0, Excel 2010 - 14.0, Excel 2007 - 12.0, Office 2003 - 11.0)
3. Right click on the in the left panel and select New>DWORD.
4. Once new DWORD is create right click on it and select Rename asDisableSaveAsLossWarningOpenDocumentSpreadsheet
5. Set Value data 1 to suppress the warning message.

Sat 23 Jan 2016

Tips & Tricks 127 - Change Default File Extension for Saving

By |Saturday, January 23rd, 2016|Categories: Tips and Tricks|Tags: , , , , , , , , |0 Comments

We know that when we save an Excel file, it gets saved as .xlsx file.

1

But sometimes, few users may need to change the default file extension to something else. You can change it in

File > Options > Save

1