Sage 100

 View Only
  • 1.  Sage Intelligence Expert input needed. Customer i

    Posted 12-17-2018 15:47
    Sage Intelligence Expert input needed. Customer is using a new container. Excel version is 2013, I don't know 32 or 64bit. Sage version is Advanced 2018. His original Excel spreadsheet has 280k rows, but only 26,236 rows coming into his SI report (he is not using filters). For data, the ""Expression Type to Add"" is ""Data Field"" type and is he is choosing two of the columns. We cannot see anything different between one row and another in the original spreadsheet. In Excel, we changed the option to ""alert the users when number of cells is affected"" to 330k and that didn't help. I cannot find anything else limiting the rows. Nothing in KB. Sage support didn't have any suggestions.


  • 2.  RE: Sage Intelligence Expert input needed. Customer i

    Posted 12-17-2018 16:21
    Did the template get saved to an older version of Excel? Using the same container, create a new report with same data and when your run ""Save Excel Template"" make sure the user selects a (edit) newer format from the Excel options list.