Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Can ExcelLock handle large workbooks? (Read 1521 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Can ExcelLock handle large workbooks?
17.03.10 at 18:52:30
 
Can ExcelLock handle large workbooks?
 
Quote:

In spite of various optimization attempts, my spreadsheets are large, approaching 20 megabytes in size with thousands of active formula cells. There are no macros or VBA code, just an abundance of INDIRECT, ADDRESS, COUNT and COUNTIF functions over a range of thousands of rows. Will ExcelLock handle large workbooks at the same speed as if it were running directly in Excel?

 
Your spreadsheet will still be running directly in Excel. ExcelLock works on your workbook when you secure it. The larger the workbook, the longer the conversion will take but this has to only be done once.
When viewing the secured workbook the ExcelLock viewer will enable Excel to open the workbook. Apart from stripping Excel and allowing the book the be opened it will not do anything. Your workbook will be as fast as running it without ExcelLock in Excel.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1