Excel 2000 Requesting Filespec on Open

P

Peter L Reader

I have an Excel 2K workbook; I bollixed up one of its worksheets, so
attempted to restore that single worksheet from a backup workbook on
floppy. Now whenever I open the workbook, it seems to want to find
that backup file on the A drive, giving me the filespec dialog if the
drive is not available. I can't seem to find where Excel is getting
the idea it needs the filespec. Is there a property setting somewhere
that I need to change?
TIA
Peter
Peter L. Reader, posting from sunny Portland, Oregon
[email protected]
---------------
 
D

Dave Peterson

Maybe there's a link in that workbook that points at the A: drive????

I'd copy the workbook to my harddrive (you already did???).

Start excel.
Tools|options|Edit Tab|
check that "ask to update links" checkbox.

then put a floppy in drive A:

Open the real workbook.

If you're prompted to update links, you can say no. (if you answer yes, then at
least drive A: is ready and you should be prompted for the new location.)

If you don't think you have links in that "real" workbook, get a copy of Bill
Manville's FindLink program:
http://www.bmsltd.ie/MVP/Default.htm

It'll help find those pesky ones.
 
P

Peter L Reader

Maybe there's a link in that workbook that points at the A: drive????

I'd copy the workbook to my harddrive (you already did???).

Start excel.
Tools|options|Edit Tab|
check that "ask to update links" checkbox.

then put a floppy in drive A:

Open the real workbook.

If you're prompted to update links, you can say no. (if you answer yes, then at
least drive A: is ready and you should be prompted for the new location.)

If you don't think you have links in that "real" workbook, get a copy of Bill
Manville's FindLink program:
http://www.bmsltd.ie/MVP/Default.htm

It'll help find those pesky ones.
Click to expand...
Thanks!! That did the trick. First I knew that if a worksheet is
copied from one workbook to another it left a trail back to the first
one...
Peter
Peter L. Reader, posting from sunny Portland, Oregon
[email protected]
---------------
 
D

Dave Peterson

sometimes when you have links to workbooks in the same folder and move them
together, you can get this problem.
 
Top