disappearing file

[oliver_penney]

strange

i have this file, used to work fine, not macros in it, dead simple

i go to open it up, and it looks like it's opening it, but then it doesn't appear

argh

any ideas?

regards

ol

 

[Monkey]

Did this accured only once or always with this document??

If it only happened once there was still (invisible) Excel Running.

You can try the following to make it visible again.

Goto Extra, Macro, Visual Basic Editor

Then insert a module and place this macro.

sub Monkey
Application.Screenupdating = true
End sub

If it didn't work let us know

Greetings Monkey

 

[oliver_penney]

it happens all the time

i can never get in the file...

regards

ol

 

[Monkey]

Something else which OS are you running. Is the file damaged? if yes What error code do you get?
do you have your virus scanner turned on which scans for macro virussus. This can be a problem if it is a big file. It scans the entire document for a virus.

Can anybody else help this guy out?


Monkey

 

[oliver_penney]

windows 2000

don't know if the file is damaged

it's 1.8 meg with no macros

 

[Sourdust]

Grasping at straws probably but have you tried opening the file from Explorer or My Computer rather than Excel?

 

[oliver_penney]

yes i have

and other PCs..

oh well it's dead