disappearing file

oliver_penney

Board Regular
Joined
Dec 18, 2002
Messages
182
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Monkey

Active Member
Joined
Feb 10, 2003
Messages
251
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
 

Monkey

Active Member
Joined
Feb 10, 2003
Messages
251
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

Board Regular
Joined
Dec 18, 2002
Messages
182

ADVERTISEMENT

windows 2000

don't know if the file is damaged

it's 1.8 meg with no macros
 

Sourdust

Well-known Member
Joined
Sep 15, 2002
Messages
769
Grasping at straws probably but have you tried opening the file from Explorer or My Computer rather than Excel?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,037
Messages
5,856,967
Members
431,843
Latest member
Malahhai

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top