BoostExcel.com main content

Steps

It is easy to share and synchronize your invoice template and Access database file using OneDrive.

  1. First, make sure all your computers have the same version of Invoice Manager for Excel installed.
  2. Make sure all your computers connect to OneDrive with the same account.
  3. Find out where your invoice template and database files are stored. By default, they are stored in the "Public Documents" folder (see installation). However, it is possible that you changed the default installation location, or you are using a customized template downloaded here at InvoicingTemplate.com.
  4. To find out the exact location of your invoice template and database files:
    1. Open your invoice template as usual.
    2. Click "Contact/Email" on the "Invoice" ribbon tab.
    3. Click "Add current template and database". The box of the file list shows the exact path and name of your Excel template and Access database. Make sure both files are stored in the same folder.
  5. Copy the files to your local OneDrive folder. By default, the OneDriver folder folder is:
    C:\Users\<Your Windows Account Name>\OneDrive

    A sample of Onedrive folder

  6. You can create a subfolder inside the OneDrive folder for storing the invoice template and database file.
  7. Verify that the template connects with the correct database file. To do this:
    1. Open the template as usual.
    2. Click the "Settings" button on the "Invoice" ribbon tab.
    3. Go to the "Database" tab.
    4. Make sure the "Current database" field shows an absolute path like " C:\Users\<Your Windows Account Name>\OneDrive\Sample.mdb", but not a relative path that has no drive letter like "C:".
    5. If it does not show an absolute path, click "Open database" to browse to and open the database. Save the template to make the connection persistent.
  8. Now if you log in with the same Microsoft account on the second computer, the files will be synchronized to the second computer via the OneDrive cloud storage.
  9. On each compute, you can create a shortcut of the template on Windows desktop. To do this, right-click the invoice template in the local OneDrive folder and then choose "Send to" / "Desktop (create shortcut)".

Please also refer to the official Sync OneDrive files and folders document.