Run Time Error 1004, Cannot Open Excel File

XLS Padlock
1

I have 2 Excel Worbooks;

  1. Main: I need to Secure through Padlock
  2. The Database: From which the Main Workbook, fetch records.

I added The Database file through Companion File Option of XLSPadlock, but in response of getting data fetched, its giving me an error (Run Time Error 1004, Excel Cannot Open the File.

Excel Cannot open Companion File
Excel Cannot open Companion File1280×800 123 KB

2

You probably enabled this option:

image
image716×424 32.3 KB

Then, other workbook files won’t be loaded by Excel. Unless you authorize it (it’s explained in the doc).