KB All Products
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 […]Newsletter – Volume 1, Issue 1
Event 1 Software Newsletter Volume 1:Issue 1 March 2009 In This Issue Importance of Training TUG Conference Information Illuminate Your Knowledge What are YOU Saying? Featured Template NEW in the Event 1 Software Knowledgebase Just in Time Training The Importance of Training Do you have the training you need to […]Why do my TSLookup and TSFind functions return zero after optimizing my workbook?
Symptom After upgrading to Office Connector version 2.01.0041 the following message is displayed when opening a workbook that was saved using a prior version of Office Connector: This workbook was saved using a prior version of Office Connector. This workbook needs to be optimized to run faster under the new […]How do I unload and load the Office Connector add-in?
Background This is a general-purpose article that provides steps for manually unloading and loading the Office Connector add-in. The resolution for certain technical issues require the add-in to be manually unloaded or loaded, and this action may also be prescribed by technical support staff. The Office Connector product suite consists […]Why do I receive a message indicating that the cache could not be saved?
Symptom When running a macro that includes a step to save the workbook, the following message may be displayed: The cache cannot be saved. Please contact technical support for assistance. Would you like to email this information to the support department at Event 1 Software? <Yes> <No> When caching […]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 this workbook, it […]When Should I Use Filter vs Where?
Excel queries only support the Where technology, so this discussion only applies to the Office Connector workbook functions (TSLookup, TSFind, TSSum, TSCount). By default, Office Connector workbook functions use Microsoft’s Filter technology to apply criteria. First, all of the data is loaded, and then the filter is applied. Once you […]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 300 Construction and Real Estate database. When Excel evaluates an Office Connector […]Invalid User Name/Password When Trying to Login
Symptom The following pop-up message is displayed after providing Sage 300 Construction and Real Estate 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 300 Construction and Real Estate […]