Skip to content

x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 104 subscribers
  • Views 260 views
  • Users 0 members are here
Browse Forums
Announcements
338
topics
271
replies
Databases and Operating Systems
578
topics
2k
replies
Financials Suite
732
topics
2k
replies
General Discussion
2k
topics
8k
replies
Operational Suite
461
topics
1k
replies
Reporting and Analytics
625
topics
2k
replies
Reports, Macros, and Customizations
574
topics
2k
replies
Sage CRM for Sage 300
104
topics
250
replies
Darren Williams

Sage BI formula errors

SUGGESTED
Posted By

I'm getting the dreaded #ERROR! in Sage BI for two different clients on different versions of Sage 300 (2022 and 2025) with both using 32bit Excel.

Normally an Office quick repair (or occasionally a full repair) fixes the issue, but it's not working this time. I'm wondering if the latest Office update may have broken something.

I do have a case open with Sage right now, but I'm wondering if anyone else is experiencing this same issue?

Parents
  • 0
    SUGGESTED

    These errors revolved around both clients having 64bit Office 365 installed, then removing it and replacing with it 32bit.

    Solution was to backup up folder C:\Program Files (x86)\Common Files\SIExcelFunctions\64bit,

    then copy the contents of C:\Program Files (x86)\Common Files\SIExcelFunctions\32bit to C:\Program Files (x86)\Common Files\SIExcelFunctions\64bit

    If you are using Sage 2024 or below the folder names will be BI... instead if SI...

Reply
  • 0
    SUGGESTED

    These errors revolved around both clients having 64bit Office 365 installed, then removing it and replacing with it 32bit.

    Solution was to backup up folder C:\Program Files (x86)\Common Files\SIExcelFunctions\64bit,

    then copy the contents of C:\Program Files (x86)\Common Files\SIExcelFunctions\32bit to C:\Program Files (x86)\Common Files\SIExcelFunctions\64bit

    If you are using Sage 2024 or below the folder names will be BI... instead if SI...

Children
No Data

*Community Hub is the new name for Sage City