Sage 100

 View Only
  • 1.  Sage Intelligence strange Excel behavior on one workstation

    Posted 06-11-2020 12:23
    Set up Sage Intelligence in 2018 Premium.  Report generates fine on 2 out of 3 workstations.  All are Excel 365 locally installed.  On one workstation, it fails to get the value from  cells that have a formula referencing another cell.
    Example:
     E10 = 4000
    H10 = E10
    I10 through I21 use Sage Intelligence formulas, but on just this workstation the reference to H10 for the account number comes up blank.

    Anyone else seen this?  Any ideas on what Excel setting might be out of whack?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 2.  RE: Sage Intelligence strange Excel behavior on one workstation

    Posted 06-11-2020 12:26
    Are Calculations set to Manual?


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Sage Intelligence strange Excel behavior on one workstation

    Posted 06-11-2020 14:59
    It is set to Automatic

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------