Excelential Auto-updates Dashboards from Excel Spreadsheets

New versions of Excel spreadsheets are created and sent to you by email, by folders on network drives, or by other means. You may update others from by running a database query.

Automatically Finds Updated Excel Files

However you get updated spreadsheets, when Excelential runs, it can automatically check if a new version of an Excel spreadsheet has arrived. It will even find a file whose name is slightly different, if you specified a "mask" for the file name. It will then move or copy it to a folder you specified for all updates to a file. It can even update a spreadsheet on schedule by running a query.

Automatically Links the Dashboard to Use the Updated File

Excelential updates the dashboard's contents with the new version of the Excel spreadsheet. It also changes the link, so that clicking on the dashboard object launches the new version. You don’t work with an obsolete version of an Excel spreadsheet.

Works with Changing Filenames

Excelential even adapts to situations where a spreadsheet’s name changes with every version. For example, some of the spreadsheets you work with may have the date appended to the file name. So one day, you get a file named “Sheets_20081126.xls”, and the next day, you get one named “Sheets_20081127.xls”. With Excelential, you can specify a “mask” (such as “Sheets_*.xls”), that allows it to find and open an updated file.

Of course, it is possible that the author of a spreadsheet made a mistake, and he misspells the file name. Only in those cases would you have to manually copy the file to its usual folder, and rename it. In all other cases, you will not need to worry about keeping abreast with the latest versions. Excelential will do that for you.