x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 47 subscribers
  • Views 1137 views
  • Users 0 members are here
Browse Forums
Announcements
51
topics
34
replies
General Discussion
1k
topics
2k
replies
CMB@MSK

Excel custom exports going to wrong version of Excel

SOLVED
Posted By

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!

Parents
  • +1
    verified 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

Reply
  • +1
    verified 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

Children

*Community Hub is the new name for Sage City