x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 3 replies
  • Subscribers 105 subscribers
  • Views 2713 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
44
topics
90
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
suzmwatson

Error Opening Excel

Posted By

We recently upgraded a client from 2014 to 2016.2.  There are 2 workstations that get an error when opening Excel that points to a Sage Intelligence file.  Sage Intelligence is not set up at this client.  I have uninstalled workstation setup, verified that there are no Sage Intelligence Programs or folders left on the workstation, rebooted the workstation and reinstalled workstation setup and the update and still get the error below.

Has anyone seen this error?  Do you know how to resolve?  I can't find anything in the KB.  This user has a Windows 7 32-bit workstation running Office 2010. 

Thanks,

  • 0
    Well, it looks like my screenshot didn't make it. The error reads:

    'c:\Program Files\Common Files\BIExcelFunctions\32bit\Sage.BI.ExcelFunction.xll' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
  • 0 in reply to suzmwatson
    Sage Intelligence is automatically installed on all workstations, it just isn't necessarily licensed. So the add-ins are installed in Excel regardless of the use of SI. When I've seen errors like the one you reference, it is normally because the user doesn't have appropriate permissions, or the workstation wasn't installed under an administrator login.
  • 0 in reply to KJones44
    Try going to the Excel options | add-ins on both the working machine and the non-working machine and compare.

    Note that if the workstation isn't licensed, the spreadsheet probably isn't going to work anyway. If someone who isn't licensed wants to look at the spreadsheet, you will have to publish a copy of the worksheet that doesn't have the formulas.

*Community Hub is the new name for Sage City