Page 1 of 1

Error message importing Excel

Posted: Wed Mar 02, 2011 3:30 am
by jay_petty
I have office 2003 and using XP. I have changed the Excel file to 95 and saved it. I am getting a program Error message "file access denied". I click cancel and DM completely shuts down. Can you tell what I am doing wrong?

Re: Error message importing Excel

Posted: Wed Mar 02, 2011 7:08 am
by jmuehleisen
If you are getting the message "File access denied" ... then probably the file is still open in Excel at the time the DM is trying to access it.

When Excel opens a file, it "locks" it so no one else can access it at the same time. I think you getting that "lock."

So, if you close the file in Excel, and then try to import it again, you should get past this.

Re: Error message importing Excel

Posted: Thu Mar 03, 2011 12:44 am
by jay_petty
Using your advise i try to see what was using the file. Excel was not open. It was Kaspersky my anti virus program. Thank you!

Re: Error message importing Excel

Posted: Thu Mar 03, 2011 6:30 am
by jmuehleisen
Thanks for the update.

I've never seen that before, where an anti-virus would cause that error.

But, it's good to know that this is another possible source of problems.

I'm glad you were able to get past this.