Compatibility Support for Excel 2019

SOLVED

Is there documentation saying Excel 2019 is officially compatible with Sage 300 v2019? The most current Compatibility guide (rev Feb 6, 2019) says "Microsoft Excel 2010, 2013, 2016 (32-bit), or 2019 (32-bit) is required on each workstation running the GL Financial Reporter." (page 9, highlight added). However the word "required" is not quite the same as officially supported or compatible. Especially when one of my colleagues got an email from Sage Support in April saying R&D had not even tested against Excel 2019 yet.

Parents
  • +1
    verified answer

    I had this problem at a client today.  The solution was to put a tick mark in front of the = sign of that formula, turning it into a text cell.  When you run, even though it has the tick, FR parses it correctly.

  • 0 in reply to Jay Converse Acumen

    This solution has worked for me at 2 different sites now (using Office 2016 Sage 300 2020) in the past year. The error was the "Desktop has stopped working" error after running through Statement Designer and FRView. Running the statement using Print Financial Statements does not error out, and it didn't error out on other workstations running Statement Designer (other WS were using Office 2013). Looks like it's fixed in PU 5 for 2020 as well. Thanks Jay! 

Reply
  • 0 in reply to Jay Converse Acumen

    This solution has worked for me at 2 different sites now (using Office 2016 Sage 300 2020) in the past year. The error was the "Desktop has stopped working" error after running through Statement Designer and FRView. Running the statement using Print Financial Statements does not error out, and it didn't error out on other workstations running Statement Designer (other WS were using Office 2013). Looks like it's fixed in PU 5 for 2020 as well. Thanks Jay! 

Children
No Data