Excel keeps checking for a floppy...

[Gregory A. Wandless]

I have Excel 2003 and it keeps checking to see if there is a floppy disk in
the drive, to the point that you can't close Excel without having a floppy
in the drive. Any ideas how fix this?
--
============================================
Gregory A. Wandless
Chemist
US Geological Survey
MS 954
Reston, VA 20192

Email: (e-mail address removed)
Phone: (703) 648-6189
============================================

 

[Guest]

I'm not sure this will be it, but you can check your settings to see if the A
drive is listed as the default drive. Click Tools>Options | General tab and
see what is listed here as 'Default file location'.

HTH

Bruce

 

[Gregory A. Wandless]

Thanks Bruce but thats not it. Default file location was hard drive.

--
============================================
Gregory A. Wandless
Chemist
US Geological Survey
MS 954
Reston, VA 20192

Email: (e-mail address removed)
Phone: (703) 648-6189
============================================

 

[Fredrik Wahlgren]

I have Excel 2003 and it keeps checking to see if there is a floppy disk in
the drive, to the point that you can't close Excel without having a floppy
in the drive. Any ideas how fix this?
--
============================================
Gregory A. Wandless
Chemist
US Geological Survey
MS 954
Reston, VA 20192

Email: (e-mail address removed)
Phone: (703) 648-6189
============================================

Does this happen when you use a certain workbook or at all times?

/Fredrik

 

[David]

Gregory A. Wandless wrote

I have Excel 2003 and it keeps checking to see if there is a floppy
disk in the drive, to the point that you can't close Excel without
having a floppy in the drive. Any ideas how fix this?

A long shot, but open and save as many different Excel files from the HARD
DRIVE as are indicated under Tools|Options|General tab|'Recently used file
list:' (that's where it is in XL2000) and see if that helps.

 

[Gregory A. Wandless]

Fredrik,

All the time, not with one specfic workbook.


--
============================================
Gregory A. Wandless
Chemist
US Geological Survey
MS 954
Reston, VA 20192

Email: (e-mail address removed)
Phone: (703) 648-6189
============================================

 

[Fredrik Wahlgren]

Fredrik,

All the time, not with one specfic workbook.

I assume you have checked everything under tools|Settings. There shouldn't
be a refrence to A:\ anywhere.
Is it possible you have a macro that checks for a floppy in personal.xls
If not a macro, do you use any add-ins? I guess you could have an add-in if
the computer isn't your personal one.

/Fredrik

 

[Dave Peterson]

I liked your idea about the MRU filenames.

Gord Dibben posted this a couple of years ago for a similar problem:
http://google.co.uk/[email protected]

 

[David]

Dave Peterson wrote

I liked your idea about the MRU filenames.

That's what led to my suggestion of opening enough HD based files to
overwrite the MRU.

 

[Dave Peterson]

Oops. Sorry.

I remembered reading the comment, but I didn't remember who wrote it.

 

[David]

David wrote

Oops. Sorry.

I remembered reading the comment, but I didn't remember who wrote it.

Referring to OP's statement:

to the point that you can't close Excel without having a floppy in the
drive.

That doesn't match my experience. While my drive was polled until I
overwrote the MRU, it only occurred when Excel was first opened, not
continuously and I could still close Excel.

I guess what I'm saying is that the MRU may not be the OP's issue.

 

[Guest]

Does this happen with any other Application? I am having a similar problem
with Word. I haven't tried the solutions yet, I'll let you know.

 

[Ken Macksey]

Check under Tools, Options, General tab and make sure that the default file
location is not the floppy drive.

HTH

Ken