TAG: Excel

How to Fix ‘Converter Failed to Save File’ with Excel 2016

I recently upgraded to Office 2016 on my Windows 10 desktop and was getting the error “Converter failed to save file” when double clicking on the file along with an “There was a problem sending the command to the program error” every time. I finally had enough with the annoyance to troubleshoot it and figured out a solve.

If you have the same issue, here’s how to fix it:

  1. Open your Default Programs configuration from the Control Panel. On Windows 10, you can hit start, type Default Programs, and it’ll open the app.
  2. Scroll down the list until you get to the Excel formats (XLS):
    Default Programs
  3. If you see anything other than Excel as the default, you’ll need to change the default to Excel. For me, the issue was the Open XML Converter not being installed anymore after upgrading to 2016. To change the default, select┬áthe format, click the “Change Program” button and select Excel 2016 from the list of apps that pops up and click OK to set the association:
    App Select
  4. You’ll need to do this for each format in the list to correct it. The most common formats you’ll use are XLS, XLSX, & XLT.

Round Up to Whole Numbers in Excel (10s, 100s, 1000s, etc)

After years of using Excel, I realized today I have never had to round up to the nearest whole number before – until today that is. I was organizing my finances and realized that I wanted to round some of the amounts up to the nearest 10. So to round to the nearest decimal place in Excel, the formula is:

=ROUNDUP([Range],[Position])

Count the number of places after the 0 to round to and set [Position] to that value

So if you had 1234.25 in Cell A1 and wanted to round up to the nearest cent, =ROUNDUP(A1, 1) would produce 1234.30.

1234.25
^ 1
1234.25
^ 2
=ROUNDUP(A1,1)=ROUNDUP(A1,2)

Want to go the other way? Simply start at the decimal as 0 and count backwards in the negated position.

1234.25
^ -1
1234.25
^ -2
1234.25
^ -3
1234.25
^ -4
=ROUNDUP(A1, -1)=ROUNDUP(A1, -2)=ROUNDUP(A1, -3)=ROUNDUP(A1, -4)

 

To round to the nearest ten (10)
=ROUNDUP(A1, -1) = 1240
To round to the nearest hundred (100)
=ROUNDUP(A1, -2) = 1300
To round to the nearest thousand (100)
=ROUNDUP(A1, -3) = 2000

There are no more results.