Event 1 Knowledgebase

Category » Office Connector

There were 33 questions found in this category:

21. Where do I save updated versions of the Excel templates provided with Office Connector?
    Background From time to time, Event 1 Software may update certain Excel templates that are furnished with the software. This is done to add functionality, resolve issues, or allow them to function with a wider range of scenarios.While the new version of a template will be incorporated into the i ...
22. Which Sage Timberline Office applications can be used with Office Connector?
    Any Sage Timberline Office application that allows access to its data via the Timberline Data ODBC driver can be used with Event 1 Office Connector. The following table identifes the applications that presently meet this requirement: Application Yes No Accounts Payable x Accounts Re ...
23. Which versions of Excel can I use with Office Connector and Sage Timberline Office 9.5 or higher?
    Background Office Connector version 2.02.0004 (or higher) will work with Sage Timberline Office 9.5 and higher. This article addresses specific issues pertaining to the versions of Microsoft Excel that are supported.Excel 2000 and PriorNot SupportedExcel 2002 and 2003Sage Software identified an ...
24. Which versions of Office Connector are compatible with Sage Timberline Office 9.5 or higher?
    BackgroundWhen upgrading from Sage Timberline Office 9.4 (or prior) to version 9.5 (or higher) several changes are made to the location of Timberline folders and files that are used by Event 1 Office Connector. Older versions of Office Connector are not compatible as a result. This article iden ...
25. Why am I prompted about optimizing my workbook that doesn't use Office Connector functions?
    Symptom Upon opening an Excel workbook that does not use Office Connector functions or queries, you receive the following prompt: "This workbook was saved using a prior version of Office Connector. This workbook needs to be optimized to run faster under the new version. If you do not optimize t ...
26. Why can't I login with a workbook that was created before I upgraded to Sage Timberline Office 9.5 or 9.6?
    BackgroundPrevious versions of Sage Timberline Office identified data folders using a path beginning with a drive letter. In a network environment, this would be a drive letter mapped to a location on a file server (e.g., T:\CompanyXYZ). Beginning with Sage Timberline Office 9.5, network data f ...
27. Why can't I use certain Sage Timberline Office accounting applications with Office Connector?
    A small number of accounting applications in the Sage Timberline Office suite were not originally developed by Timberline Software. As such, these applications do not share the same architecture as those originally built by Timberline. Although these applications may utilize the Pervasive datab ...
28. Why do some tables appear more than once and end with "(1)" or "(2)"?
    ScenarioWhen a list of table names is displayed in an Office Connector wizard, some tables may appear more than once and end with "(1)" and "(2)".ExplanationOffice Connector uses certain Microsoft database technologies that do not support the use of tables that have more than 255 columns. Since ...
29. Why does it take so long to open files with Excel 2007 or later?
    SymptomWhen you double-click an Excel file, Excel 2007 takes a seemingly long period of time to open the file (up to a minute). SolutionThe problem may be caused by the properties associated with the Excel file type that tells Windows and Excel how to open the file. This solution corrects a kno ...
30. Why doesn't my Workbook or Template open via Windows Explorer or Office Connector Launch Pad?
    BackgroundMicrosoft Excel contains a setting that prevents external applications from communicating with Excel via DDE. DDE stands for Dynamic Data Exchange and is used by some applications to exchange data back and forth. Windows Explorer uses DDE to open XLS and XLT files. Therefore if this f ...
31. Why don't I see a list of data folders after upgrading from Sage Timberline Office 9.4 to 9.5 or higher?
    SymptomUsing Excel XP (2002) or 2003, when you click on an Office Connector toolbar button that would require you to identify a Sage Timberline Office company data folder, you receive the following message:There are no Sage Timberline Office companies already identified. Click Search to discove ...
32. Why is the following message displayed when launching Excel? "Office Connector1.xls could not be found"
    Symptom Upon opening Excel or attempting to use any Office Connector feature, the following message is displayed: “OfficeConnector1.xls could not be found” Cause This is typically caused if the current installation of Microsoft Excel is not up to date with regard to available serv ...
33. Why is the Office Connector toolbar disabled?
    SymtomOffice Connector toolbar is grayed out.CauseThe Office Connector add-in can be disabled by Excel, often as a result of Excel being ended while Office Connector was doing something.ResolutionThe steps to resolve this issue will depend on the version of Microsoft Excel being used. Excel 20 ...