hi @ChrisHemedinger, When i tried your method to 1) Open the file in Microsoft Excel and specify the password. 2) Use the SAS Enterprise Guide File->Import Data task to read the same Excel file, while it's still open in Excel. I am getting the attached error. I am using a client-server model. Is it a requirement that microsoft office should be installed in the server also for this method to work. I have excel 2007 installed on my local desktop. Also, Allow xcmd option is diabled, so even with dde we wont be able to import. Please correct me if i am wrong. Regards, Naveen
... View more