Blog

July 18, 2014 3:43PM

Excel Automation - Answers to your biggest questions!

After announcing our next webinar on Excel Automation we have had a few questions come in about Spreadsheet Server. Here we address a few of the frequently asked questions:

  1. If our system is hosted by MRI or Yardi can we use Spreadsheet Server?
    • Yes! It will require a VPN (virtual private network) from your software vendor but Spreadsheet Server is designed to work with MRI Windows or Web, as well as Yardi-hosted databases.

  2. Will my data, and any charts I have linked to my data, update automatically?
    • Yes, Spreadsheet Server will refresh your MRI or Yardi data when opened and any Excel charts you have linked to the live data will refresh as well.

  3. Do I need an MRI or Yardi license to use this tool?
    • No, Spreadsheet Server will connect directly to your system's SQL database. No MRI or Yardi license is required.

  4. What is the standard implementation time?
    • Standard implementation time is 8-12 hours total, including installation.

  5. One of my accountants wants to use Spreadsheet Server but doesn't understand queries or the MRI table structure, will they need additional training?
    • No. As long as the accountant has basic Excel skills the 8-12 hours implementation time is more than sufficient.
More questions? Contact us to learn more.