Long file opening time after protecting formulas

XLS Padlock
1

Hello!

I have a worksheet with about 1000 rows and 40-45 columns. I have protected formulas in 6 columns and after compiling noted that file opening time has increased sensibly. What is the best practice to avoid long file opening time and having formulas protected?

Thank you!

2

Same problem here:

With XLS Padlock I need to wait almost 2 minutes for loading. Without XLS Padlock I just need to wait few seconds.

  1. I tested it with Excel 2010, 2013, 2016 and 365.
  2. I reinstalled MS Office several times.
  3. There are many customer who tested it and all of them need to wait so long time.
  4. I have a very good computer with AMD Ryzen 7 3700X 8-Core Processor 3,6 GHz, 16 GB, 64-Bit, Windows 10. So no bad hardware performance.
  5. During the loading time the file .EXE is in the task manager.
  6. I just use Windows Defender Antvirus.
  7. I saved my workbook into binary format. No difference.
  8. I deleted all graphics in my Workbook. No difference.
  9. I use XLS Padlock 2021.1

Maybe you can check some of these solutions. But I still wait for a solution.

3

Are you using cell format validation rules?

4

I use conditional formatting in some columns. Bot there’re no validation rules.

5

Do you think you could (for testing only) clear your conditional formatting?