Software

Ask something
Discussion Locked

Excel file automatic close

0 helpful
12 replies

by shaundyc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

gurus,

I have a file in Excel 2000 with password for protection, that automatically close when I type the password. Its the only file that make such a behavior on my entire files. Its a very important file. What causes this? I already scan for virus but still cant open it?

Hope someone can help.

Thanks

12 replies

by chitosunday

If there is a malicious macro, just disable macro . If it is in the start-up directory , transfer it to another directory, then open it macro disabled. If your security setting is low, make it medium so you can disable it. Delete the malicious code by going to tools, macro, visual basic, then go to each sheet or module and delete the code.

by shaundyc

Thank you for your email. I Tried it already but tono avail. The problem is the file wont open even the correct password is keyed. The status bar is loading on the excel but it wont finish up. It Automatically closes.

Do you have any alternatives.

Thanks

by sgt_shultz

not encrypted or compressed, right? what os? is the file located on the hard disk locally in your computer? (or on the network?)

by shaundyc

yes sir, it is not encrypted or compressed, im using win2k, the file is stored on my hard disk locally in my computer.

already did update to latest office sp.

do you have any alternatives?

thanks

by ayuknotna

Hi,

try duplicating the file:
- go to My Computer->"location of the file"
- copy "filename"
- rename "old filename"
- paste "file"

then try opening the new file.

goodluck

by shaundyc

thanks for the response, didn't quite get it though. but already tried what was your instruction and it have an error message.

may i ask if you can elaborate more.

thanks

by ayuknotna

Hello again,

navigate to the location of the file.

... select (by right-clicking) the file.
... go down to COPY, then left-click.
... move the pointer to the white background of the current window, then right-click the pointer then click PASTE or just press CTRL+V

Now you have a new copy of the file (COPY OF YOURFILE).

Double click the new file to see if this work.

Happy to post.

by shaundyc

thanks again but unfortunately it didn't work. hope you guys still have a solution to this prob of mine.

This discussion is closed to new replies.