Long file opening time after protecting formulas

F

footy

New member
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!
 
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.
 
You must log in or register to reply here.
Back
Top