Fiscal Leadership for Georgia

Spreadsheet Upload Template


TeamWorks 9.2 Spreadsheet Upload Template

Step 1: Delete the current folder(s) containing the journal spreadsheet files from 9.1/8.8 versions.

Step 2: Click on the following link and download the instructions on how to upload Spreadsheet Journals in to General Ledger:

Step 3: To use Excel to create an upload file to load a journal into TeamWorks 9.2, you will need to download the files below based on your operating system. The files should be placed in a folder off the root directory (for example C:\GL_Upload).

NOTE:  The folder used to store the files SHOULD NOT be a subfolder (for example C:\user\GL_Upload).

Right click the links below and select Save Target As.

NOTE: Please be patient when you first start using the new 9.2 spreadsheet. You may encounter different spreadsheet formatting and configuration isues. The following information on troubleshooting provides instructions on resolving the most common errors received.


Troubleshooting

  1. If you receive a Visual Basic compile error message, see the following document for troubleshooting steps that can be taken to resolve the issue.

    Visual Basic Error message
    Visual Basic Error Message

    NOTE:  This occurs because the spreadsheet is not automatically associating to the macro file that was placed in the same directory.  This should be a one-time error after applying the fix.

     
  2. If you receive an Excel 64 Bit Visual Basic compile error message, see the following document for troubleshooting steps that can be taken to resolve the issue.

    Visual Basic 64-bit error message
    64 Bit Visual Basic Error Message

    NOTE:  As delivered, the spreadsheet will only work with the 32 bit version of Excel.  This fix enables 64 bit versions of Excel to work with the spreadsheet.

 


Do you need the previous download information? Click here: TeamWorks 9.1 Spreadsheet Upload Template