Using Sage 200 Business Intelligence with Excel 2007
The Sage 200 Business Intelligence toolbar will not show in Excel normally after a crash.
Check the following registry entry:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Resiliency\DisabledItems.
If you find any keys within here, open them up and see if anything relates to Business Intelligence or MScoree.dll
If you do take a backup of the registry branch and then delete these items, start up Excel and the BI toolbar should now be there.
Using Sage 200 Business Intelligence with Excel 2003
When you use Sage 200 Business Intelligence with Excel 2003 you will need to copy over the Excel.exe.config file from the Excel folder within the Sage 200 file server folder into the same folder as Excel.exe (normally c:\Program Files\Microsoft Office\Office11.) Once this is copied over you will need to disable then re-enable Business Intelligence from the enable BI tool. |