Excel custom exports going to wrong version of Excel

Question

Every other time I do a customer export I end up with a garbled spreadsheet that my version of excel can't handle. I realized today that Sage is sending me the export as a version of Excel that is from 1997-2003, and my excel does not like that since it is a 2010. I am trying to figure out how to correct this issue, if there is a way at all. 
 
 Thanks!

Vince Settipane · Accepted Answer

IN EXCEL, you need to get to the trust center, I have Excel 2016, the option you need to change is the 
 FILE BLOCK settings, they are counter intuitive, UN-CHECK the file types you want excel to open 
 
 The other thing can be FILE EXPLORER, the file type is pointing to the wrong EXCEL 
 RIGHT click on a XLS file and choose properties, see what OPENS WITH is pointing to, Should be Excel

Sage BusinessWorks

Excel custom exports going to wrong version of Excel

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING