Installation > LockedFileRetry Parameter

LockedFileRetry Parameter

When an ExcelWriter script opens an existing spreadsheet (using ExcelApplication.Open or ExcelTemplate.Open), the spreadsheet is locked until the request is complete. To prevent failure of additional requests for the same script while the first request is processing, ExcelWriter will retry a request that could not be processed because the spreadsheet was locked. By default, ExcelWriter will retry the request every 2 seconds. To change this value:

1. Open the Start menu and select Run...
   
   
2. Enter regedit and click Ok.
   
   
3. Open the folder HKEY_LOCAL_MACHINE\SOFTWARE\SoftArtisans\ExcelWriter\Parameters.
   
   
4. Double-click the LockedFileRetry key. An Edit DWORD Value dialog will open.
   
   
5. In the Value Data field, enter a new value in seconds.

Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.