Sage 100

 View Only

  • 1.  Sage 100 Advanced v2014. Sage Intelligence. Clie

    Posted 03-15-2017 13:41
    Sage 100 Advanced v2014. Sage Intelligence. Client can run one Sage Intelligence report successfully, but running a second one (any report, any order) results in the Excel spreadsheet locking up with the word ""Calculate"" flickering constantly. Tried on two different workstations, both with 8Gb RAM, results identical. I tried reducing the amount of data being pulled by filtering out older years' data, but that made no change. Any ideas?


  • 2.  RE: Sage 100 Advanced v2014. Sage Intelligence. Clie

    Posted 03-15-2017 13:52
    The workaround we used to was be sure no instances of Excel are running before clicking the Run arrow in Intelligence. Sounds stupid, but we never had the time to look for a better answer.


  • 3.  RE: Sage 100 Advanced v2014. Sage Intelligence. Clie

    Posted 03-15-2017 14:29
    If you open the excel program first, then open the spreadsheet, you should be able to turn off auto calculate in File Options. Then save the template.


  • 4.  RE: Sage 100 Advanced v2014. Sage Intelligence. Clie

    Posted 03-16-2017 07:06
    I've seen that work too, @KathrynScofield


Related Content