Long file opening time after protecting formulas


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!

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.

Are you using cell format validation rules?

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

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