This project is read-only.

System Requirements

  • 64-bit Windows (Server 2008 / Windows 7 or newer)
  • Excel 2010 (or newer)
  • Visual Studio 2010 Tools for Office Runtime
  • Excel files must reside on an NTFS volume.

The server's RAM and CPU requirements will depend entirely on what sort of Excel / PowerPivot files you plan to refresh, and how much parallelism you require.

Installation

Each download/release includes windows installer (MSI) file, which is reasonably self-explanatory to use and install. Note that the installer will install a Windows Server - i.e. an application that automatically starts when windows boots, and runs invisibly in the background.

Upon completing installation, you will be prompted for credentials (i.e. a login) that the service will run as. Regardless of whether you choose a Windows built-in account or a user account, be sure that the credential supplied have permissions to Read/Write to the folders where the Excel files are, and have appropriate permissions on any underlying data sources used by the Excel files.

Last edited Dec 20, 2012 at 9:11 AM by maranite, version 5

Comments

mcuevas Feb 24, 2014 at 11:54 PM 
same happens to me. Software has been installed and service is running, but nothing seems to happen on the excel file. Tried to launch the Refresh.exe file and got an exception (see below)

RefreshExcel - Refreshes data in an Excel workbook
==================================================

Refreshing C:\Temp\00 - book\Book1.xlsx
Error: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Error: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))

Unhandled Exception: System.ArgumentException: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.OLEDBConnection.get_BackgroundQuery()
at ExcelRefresh.Excel.ExcelUtilities.RefreshAll(Workbook workbook)
at ExcelRefresh.Excel.ExcelUtilities.<>c__DisplayClass4.<RefreshWorkbook>b__3(Workbook book)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClassa.<UsingWorkbook>b__8(Workbook workBook)
at ExcelRefresh.Com.ComHelpers.UsingCOM[T](T reference, Action`1 doThis, Action`1 thenFinally)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClassa.<UsingWorkbook>b__7(Application excelApp)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClass4.<UsingExcel>b__2(Application app, Process process)
at ExcelRefresh.Com.ComHelpers.UsingAutomationApp[T](T app, Func`2 fnGethWnd, Action`2 doThis)
at ExcelRefresh.Com.ComHelpers.UsingExcel(Action`1 doThis)
at ExcelRefresh.Excel.ExcelUtilities.RefreshWorkbook(String sourcePath, String saveToPath, String backupPath)
at RefreshExcel.Program.Main(String[] args)

FrancescoGolf Feb 22, 2013 at 11:28 AM 
Oh, I forgot: Content Status inside file properties is "Hourly" :)

FrancescoGolf Feb 22, 2013 at 11:26 AM 
Hello Maranite,
thank you for your effort.
I installed everything on a win 7 Enterprise 64-bit, Excel 2010, with Visual studio 2010 Tools for Office Runtime (installed for this purpose).
No errors or messages, the service is started and running, but refresh is not happening.
The folder I chose contains only an Xlsx file with a powerpivot data connection (vers 11.0.3) and, of course, a PowerPivot "cube" inside.
Even the "Refresh All" is not working, the file looks untouched.
What i could be missing?
Thank you again for your help.
Francesco