<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
	<title>Event 1 Knowledgebase - Office Connector</title>
	<link>http://kb.event1software.com</link>
	<description />
	<language>en-us</language>
	<copyright>http://kb.event1software.com</copyright>
	<generator>ActiveKB NX</generator>
	<webMaster>event1support@gmail.com</webMaster>
	<lastBuildDate>Thu, 09 Sep 2010 02:05:34 PDT</lastBuildDate>
	<ttl>20</ttl>
	<item>
		<guid>http://kb.event1software.com/questions/2/</guid>
		<title>Do I need to uninstall Office Connector before upgrading?</title>
		<link>http://kb.event1software.com/questions/2/</link>
		<description>You do not need to uninstall Office Connector before installing a new version.  Just install on top of what&amp;#8217;s already there.  All Event 1 programs recognize an upgrade and respond appropriat ...</description>
		<author> </author>
		<pubDate>Tue, 10 Apr 2007 04:50:07 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/3/</guid>
		<title>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?</title>
		<link>http://kb.event1software.com/questions/3/</link>
		<description>
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, clic ...</description>
		<author> </author>
		<pubDate>Tue, 10 Apr 2007 04:51:53 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/4/</guid>
		<title>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.</title>
		<link>http://kb.event1software.com/questions/4/</link>
		<description>
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 mi ...</description>
		<author> </author>
		<pubDate>Tue, 10 Apr 2007 04:53:08 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/6/</guid>
		<title>How Do I turn Office Connector off for a particular user under Citrix?</title>
		<link>http://kb.event1software.com/questions/6/</link>
		<description>
The following procedure will prevent the Office Connector toolbar from showing up for a particular user.

Click Start-&amp;gt;Run, type regedit and click OK:
Navigate to &amp;#8220;HKEY_CURRENT_USER\ ...</description>
		<author> </author>
		<pubDate>Tue, 10 Apr 2007 04:59:57 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/8/</guid>
		<title>How do I reference a cell from an Office Connector workbook function?</title>
		<link>http://kb.event1software.com/questions/8/</link>
		<description>
The quick answer is &amp;#8220;Replace the existing value with a cell reference using the following syntax 
&amp;#8220; &amp; &amp;lt;cell address&amp;gt; &amp; &amp;#8220;  

Following is a more detailed explanation:   ...</description>
		<author> </author>
		<pubDate>Tue, 10 Apr 2007 05:05:39 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/14/</guid>
		<title>Why doesn&#039;t my Workbook or Template open via Windows Explorer or Office Connector Launch Pad?</title>
		<link>http://kb.event1software.com/questions/14/</link>
		<description>
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  ...</description>
		<author> </author>
		<pubDate>Tue, 10 Apr 2007 06:57:03 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/15/</guid>
		<title>Which Sage Timberline Office applications can be used with Office Connector?</title>
		<link>http://kb.event1software.com/questions/15/</link>
		<description>
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 applicatio ...</description>
		<author> </author>
		<pubDate>Thu, 12 Apr 2007 23:20:23 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/16/</guid>
		<title>Why can&#039;t I use certain Sage Timberline Office accounting applications with Office Connector?</title>
		<link>http://kb.event1software.com/questions/16/</link>
		<description>
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 architectur ...</description>
		<author> </author>
		<pubDate>Thu, 12 Apr 2007 23:14:02 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/17/</guid>
		<title>Why do some tables appear more than once and end with &quot;(1)&quot; or &quot;(2)&quot;?</title>
		<link>http://kb.event1software.com/questions/17/</link>
		<description>
ScenarioWhen a list of table names is displayed in an Office Connector wizard, some tables may appear more than once and end with &quot;(1)&quot; and &quot;(2)&quot;.ExplanationOffice Connector uses certain Microso ...</description>
		<author> </author>
		<pubDate>Wed, 10 Oct 2007 19:51:53 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/18/</guid>
		<title>How do I save a workbook without Office Connector functions or queries (save as values)?</title>
		<link>http://kb.event1software.com/questions/18/</link>
		<description>
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  ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:37:32 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/19/</guid>
		<title>Why is the Office Connector toolbar disabled?</title>
		<link>http://kb.event1software.com/questions/19/</link>
		<description>
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.Resoluti ...</description>
		<author> </author>
		<pubDate>Tue, 06 Nov 2007 07:27:18 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/20/</guid>
		<title>Unable to open the license file</title>
		<link>http://kb.event1software.com/questions/20/</link>
		<description>
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 Off ...</description>
		<author> </author>
		<pubDate>Wed, 07 Nov 2007 00:13:04 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/21/</guid>
		<title>Invalid User Name/Password When Trying to Login</title>
		<link>http://kb.event1software.com/questions/21/</link>
		<description>
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.  Pleas ...</description>
		<author> </author>
		<pubDate>Wed, 07 Nov 2007 00:46:40 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/22/</guid>
		<title>Function values are zero or blank when workbook is re-opened</title>
		<link>http://kb.event1software.com/questions/22/</link>
		<description>

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 ...</description>
		<author> </author>
		<pubDate>Thu, 08 Nov 2007 01:12:32 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/23/</guid>
		<title>How do I install Office Connector on additional computers?</title>
		<link>http://kb.event1software.com/questions/23/</link>
		<description>
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 Timb ...</description>
		<author> </author>
		<pubDate>Sat, 10 Nov 2007 04:38:50 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/26/</guid>
		<title>Why is the following message displayed when launching Excel?  &quot;Office Connector1.xls could not be found&quot; </title>
		<link>http://kb.event1software.com/questions/26/</link>
		<description>
Symptom
Upon opening Excel or attempting to use any Office Connector feature, the following message is displayed:
&amp;#8220;OfficeConnector1.xls could not be found&amp;#8221;
 
Cause
This is typic ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:17:49 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/27/</guid>
		<title>Why am I prompted about optimizing my workbook that doesn&#039;t use Office Connector functions?</title>
		<link>http://kb.event1software.com/questions/27/</link>
		<description>
Symptom
Upon opening an Excel workbook that does not use Office Connector functions or queries, you receive the following prompt:
&quot;This workbook was saved using a prior version of Office Conne ...</description>
		<author> </author>
		<pubDate>Tue, 13 May 2008 15:28:38 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/28/</guid>
		<title>Why does it take so long to open files with Excel 2007 or later?</title>
		<link>http://kb.event1software.com/questions/28/</link>
		<description>
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 wi ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:36:48 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/31/</guid>
		<title>How do I unload and load the Office Connector add-in?</title>
		<link>http://kb.event1software.com/questions/31/</link>
		<description>
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  ...</description>
		<author> </author>
		<pubDate>Wed, 06 Aug 2008 15:11:26 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/33/</guid>
		<title>Which versions of Office Connector are compatible with Sage Timberline Office 9.5 or higher?</title>
		<link>http://kb.event1software.com/questions/33/</link>
		<description>
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 O ...</description>
		<author> </author>
		<pubDate>Wed, 17 Mar 2010 08:34:10 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/34/</guid>
		<title>Which versions of Excel can I use with Office Connector and Sage Timberline Office 9.5 or higher?</title>
		<link>http://kb.event1software.com/questions/34/</link>
		<description>
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 E ...</description>
		<author> </author>
		<pubDate>Wed, 17 Mar 2010 08:39:32 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/35/</guid>
		<title>Why don&#039;t I see a list of data folders after upgrading from Sage Timberline Office 9.4 to 9.5 or higher?</title>
		<link>http://kb.event1software.com/questions/35/</link>
		<description>
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 follow ...</description>
		<author> </author>
		<pubDate>Wed, 17 Mar 2010 08:36:47 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/36/</guid>
		<title>Why can&#039;t I login with a workbook that was created before I upgraded to Sage Timberline Office 9.5 or 9.6?</title>
		<link>http://kb.event1software.com/questions/36/</link>
		<description>
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 loca ...</description>
		<author> </author>
		<pubDate>Wed, 17 Mar 2010 08:36:29 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/43/</guid>
		<title>How do I enable macros in Excel 2003 and prior?</title>
		<link>http://kb.event1software.com/questions/43/</link>
		<description>
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 function ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:35:42 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/44/</guid>
		<title>How do I enable macros in Excel 2007 and later?</title>
		<link>http://kb.event1software.com/questions/44/</link>
		<description>
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 function ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:34:51 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/45/</guid>
		<title>How do I enable macros in Excel?</title>
		<link>http://kb.event1software.com/questions/45/</link>
		<description>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 functional ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:35:12 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/48/</guid>
		<title>What templates are available for Office Connector?</title>
		<link>http://kb.event1software.com/questions/48/</link>
		<description>
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 tem ...</description>
		<author> </author>
		<pubDate>Mon, 02 Mar 2009 15:03:20 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/49/</guid>
		<title>How do I save my workbook as a template?</title>
		<link>http://kb.event1software.com/questions/49/</link>
		<description>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 ne ...</description>
		<author> </author>
		<pubDate>Mon, 09 Mar 2009 09:31:06 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/53/</guid>
		<title>How do I create a template from an existing workbook?</title>
		<link>http://kb.event1software.com/questions/53/</link>
		<description>
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 ...</description>
		<author> </author>
		<pubDate>Tue, 02 Jun 2009 13:56:58 PDT</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/75/</guid>
		<title>How do I enable macros for templates provided by Event 1 Software?</title>
		<link>http://kb.event1software.com/questions/75/</link>
		<description>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 m ...</description>
		<author> </author>
		<pubDate>Wed, 17 Feb 2010 16:43:03 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/76/</guid>
		<title>Does Office Connector support Windows 7?</title>
		<link>http://kb.event1software.com/questions/76/</link>
		<description>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 r ...</description>
		<author> </author>
		<pubDate>Thu, 14 Jan 2010 07:03:12 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/80/</guid>
		<title>How do I email technical support from Office Connector?</title>
		<link>http://kb.event1software.com/questions/80/</link>
		<description>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 ...</description>
		<author> </author>
		<pubDate>Fri, 19 Feb 2010 08:04:18 PST</pubDate>
	</item>
	<item>
		<guid>http://kb.event1software.com/questions/88/</guid>
		<title>Where do I save updated versions of the Excel templates provided with Office Connector?</title>
		<link>http://kb.event1software.com/questions/88/</link>
		<description>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 funct ...</description>
		<author> </author>
		<pubDate>Fri, 11 Jun 2010 11:08:05 PDT</pubDate>
	</item>
	</channel>
</rss>
