Event 1 Knowledgebase

Category » Office Connector

There were 33 questions found in this category:

1. Do I need to uninstall Office Connector before upgrading?
   You do not need to uninstall Office Connector before installing a new version. Just install on top of what’s already there. All Event 1 programs recognize an upgrade and respond appropriately.
2. Does Office Connector support Windows 7?
   SummarySupport for Windows 7 will be provided starting with the release of Sage Timberline Office 9.7 which is expected in late spring of 2010.DetailsOffice Connector requires the environment it runs in to have Sage Timberline Office installed. Sage Timberline Office versions 9.6 and prior do no ...
3. Function values are zero or blank when workbook is re-opened
   Symptom When a workbook that contains Office Connector functions is saved and later the workbook is re-opened, the cells containing Office Connector functions show zeros or blanks. Cause Each Office Connector function represents a link to your Sage Timberline Office database. When Excel eval ...
4. How do I create a template from an existing workbook?
   Background Once you have created a workbook containing Office Connector queries and functions, you may wish to deploy it to other people or companies. This article covers the recommended steps and things to consider that will create a smooth experience for the recipient who will create workbook ...
5. How do I email technical support from Office Connector?
   BackgroundYou can use this feature of Office Connector to contact technical support staff about a question or an issue you are experiencing. At times, technical support staff may direct you to do this. The email that is sent from Office Connector includes diagnostics files that are useful to the ...
6. How do I enable macros for templates provided by Event 1 Software?
   Background Some Excel templates that are provided with your Event 1 Software product contain Excel macros that are used to automate certain tasks. The default macro security settings in Excel may prevent these macros from being used or may require you to click a button to enable them upon openin ...
7. How do I enable macros in Excel 2003 and prior?
   BackgroundWhen opening an Excel workbook or creating a new workbook from a template, macros may be disabled depending on your macro security settings in Excel. This may disable certain functionality of the workbook.ResolutionThis article is not intended to provide complete information on the to ...
8. How do I enable macros in Excel 2007 and later?
   BackgroundWhen opening an Excel workbook or creating a new workbook from a template, macros may be disabled depending on your macro security settings in Excel. This may disable certain functionality of the workbook.ResolutionThis article is not intended to provide complete information on the to ...
9. How do I enable macros in Excel?
   BackgroundWhen opening an Excel workbook or creating a new workbook from a template, macros may be disabled depending on your macro security settings in Excel. This may disable certain functionality of the workbook.ResolutionClick here to view specific recommendations regarding Excel templates t ...
10. How do I install Office Connector on additional computers?
    Office Connector can be installed on as many workstations as needed. The number of concurrencies you purchased determines the number of users who can have an active connection to your Sage Timberline Office data at one time using Office Connector.The software can be downloaded from the Event 1 ...
11. How do I reference a cell from an Office Connector workbook function?
    The quick answer is “Replace the existing value with a cell reference using the following syntax “ & <cell address> & “ Following is a more detailed explanation: Start by creating the workbook function and using a hard-coded value for the filter (see the screen shot f ...
12. How do I save a workbook without Office Connector functions or queries (save as values)?
    A workbook that you create using Office Connector will contain Office Connector worksheet functions and/or queries that rely on a connection to your database. You may want to provide a copy of an Excel workbook to someone who does not have Office Connector or a connection to your database. This ...
13. How do I save my workbook as a template?
    Background Excel templates have a special file type that designates them as a template. The advantage of using a template is that the default action associated with a template is to create a new workbook based on a template but not open or modify the template itself. The design of the template i ...
14. How Do I turn Office Connector off for a particular user under Citrix?
    The following procedure will prevent the Office Connector toolbar from showing up for a particular user. Click Start->Run, type regedit and click OK: Navigate to “HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options”. The “11.0” is for Office 2003. Previous ...
15. How do I unload and load the Office Connector add-in?
    Background This is a general-purpose article that provides steps for manually loading and unloading the Office Connector add-in. The resolution for certain technical issues require the add-in to be manually loaded or unloaded, and this action may also be prescribed by technical support staff. S ...
16. I installed Office Connector. It shows up in Add/Remove Programs, but it does not show up in Excel. What happened and how do I fix it?
    You must close Excel during the installation in order for the setup program to automatically insert the Add-In. There are two ways to fix this: Close Excel and re-run setup. In Excel, click Tools->Add-Ins…, click Browse… and select C:\Program Files\Event 1\Office Connector\Offic ...
17. Invalid User Name/Password When Trying to Login
    Symptom The following pop-up message is displayed after providing Sage Timberline Office login information using Office Connector: The user name or password you entered is incorrect. Please enter a valid user name and password. Cause Assuming you are entering a valid Sage Timberline Office ...
18. Unable to open the license file
    Symptom When opening Excel, the following message is reported in a pop-up message: Unable to open the license file! Please call technical support. Cause This error is caused when Office Connector is unable to open either the Query license file or the Write license file due to one of the fo ...
19. What templates are available for Office Connector?
    Template LibraryEvent 1 Software is in the process of building a library of add-on templates that provide solutions to common needs. Search For TemplatesUse the following page to search for template solutions in our current library:http://www.event1software.com/templates/index.phpCurrent Librar ...
20. When I try to run the self extractor file that I downloaded from your web site, I get a message saying that it is not a valid Win32 or WinNT image.
    This symptom indicates a corrupted download. Download the image again; when prompted, be sure to click Save, not Open. Pick a new location and try opening the file from there.Re-downloading might not resolve the issue if the corrupted file is in your Internet cache. You can tell if this is the ...