Instead of creating a new connection each time you begin work on a new Excel workbook, you can save connection information in a Excel template. This template will then be available whenever you want to create a new file for Velixo.

Generally, these are the steps:

  1. Create a Velixo connection in an Excel workbook.

  2. Save the workbook that contains the Velixo connection as an Excel Template.

  3. Open that template to start a new Excel workbook for which you need a Velixo connection.

Read below to learn how to create a Velixo connection and save a workbook as an Excel template.

Create a Velixo connection

Click the Connection Manager button in the Velixo ribbon, then click Add Connection. Enter a unique Name for the connection, since you will use this name later as you build formulas.

mceclip0.png

Learn more in Connection Manager.

Note: If you click the box for Remember me, you will not be prompted for your Acumatica username and password when you re-open the workbook.

Create an Excel Template

Now that you have connected the workbook to Acumatica, select Save As from Excel’s File menu (or the Office button if using Excel 2010):

excel_saveas.png

In the Save As dialog, give your new Template a descriptive name (such as “Velixo Template”), and select Excel Template (*.xltx) from the pulldown list…

excel_saveasdiag.png

And click Save.


Now, when you select New from Excel’s File menu, the Template is available in the Personal list...

excel_new.png

Note: You can right-click that Template (or click the pushpin in its lower right corner), to pin it to the New list:

excel_newwithtemp.png

When you select the Template, Excel will open a new workbook which will automatically establish the connection with Acumatica…

connecting.png

…so that you can now start creating your next Velixo report without having to enter the connection information, by hand.

This simple technique is especially useful if you often use the same layout or data in your workbooks, or you need to consolidate multiple tenants/instances and frequently need to create multiple connections with every new workbook you create.

Did this answer your question?