Project Description
A command line utility for refreshing Excel data, as well as a Windows service which monitors and periodically refreshes a folder of Excel files.

This project was created to help businesses that primarily use Excel for reporting, but are not yet ready to adopt SharePoint. It provides a Windows service which will periodically refresh the data connections in one or more Excel files.

Command Line Highlights:

  • Support for PowerPivot cubes, OLEDB and ODBC data connections.
  • Support for saving workbooks using date-naming conventions (i.e. creating archives)

Service Highlights:

  • Supports parallel, prioritized refreshing of reports, with automatic archiving.
  • Support for PowerPivot cubes, OLEDB and ODBC data connections.
  • Supports a variety of reporting schedules (hourly, daily, day-of-week, weekly, monthy).
  • Automatically bypasses Excel files that are locked (i.e. being viewed by someone) .
  • Simple management console for administering the service.

For an installation and configuration guide, click here.
For help with configuration, click here.

Last edited Mar 7, 2013 at 10:07 AM by maranite, version 11