Accessing Excel File

Johnny2002 · May 15th, 2002, 02:54 PM

I have a excel file that was saved on a floppy from a server that I need to access. Since then the server has been removed and now we are on standalone PC,s. When I try to access the file from A: drive I get a message that the file can’t be accessed. I can go to windows explorer and see that the file is on the floppy so I know the file is there. So is there any work around to this problem?
Thanks in advance.

[ This Message was edited by: Johnny2002 on 2002-05-15 15:49 ]

[ This Message was edited by: Johnny2002 on 2002-05-15 15:52 ]

Paul B · May 15th, 2002, 05:06 PM

Sounds to me like you might have a bad floppy disk.

Johnny2002 · May 16th, 2002, 10:45 AM

There is another excel file on the disk that I am able to open. It is just this file that will not open. It seems to be looking for the server before it can open the file.

Thanks

Johnny2002 · May 17th, 2002, 01:54 PM

Anybody have any ideas?

Jack in the UK · May 17th, 2002, 02:07 PM

you can see the file on the floppy is is bright or geryed out>

Johnny2002 · May 17th, 2002, 06:39 PM

The file is bright. So far the only thing I can think of is for some reason it is still looking for the server for the location of the file. I have tried copying the file to different locations, but with no luck.

Joe Was · May 17th, 2002, 07:15 PM

You may have hidden links to a file once on the server. Try to find the links and delete them or change the location.

Find links in a workbook
There is no automatic way to find links used in a workbook. However, because links use brackets [ ] to enclose the source workbook name when it is closed, you can search for it. For example =SUM([Budget.xls]Annual!C10:C25).

Close all workbooks except the one you want to find the links in.
On the Edit menu, click Find.
Click Options.
In the Find what box, enter [.
In the Within box, click Workbook.
In the Look In box, click Formulas.
Click Find All.
In the box at the bottom, look in the Formula column for formulas that contain [.
To select the cell with a link, select the row in the box at the bottom.
Links are also commonly used in names, text boxes, or chart titles.
Find links used in names

On the Insert menu, point to Name, and then click Define.
Select each entry in the Names in workbook list, and look in the Refers to box for links. Links contain a reference to another workbook, such as [Budget.xls].
Find links used in text boxes or chart titles

Click the text box or chart title you want to check.
In the formula bar , look for a reference to another workbook, such as [Budget.xls].
Find links used in other objects

On the Edit menu, click Go To, and then click Special.
Click Objects, and then click OK.
Press TAB, and then look in the formula bar for a reference to another workbook, such as [Budget.xls]. The name of the object appears in the Name box.
Repeat the previous step until each object is checked.
Find links used in chart data series

Select the data series you want to check.
In the formula bar , look for a reference to another workbook, such as [Budget.xls].
To proceed to the next data series, press TAB.
Repeat the previous two steps until each data series is checked.

Just a shot, it might help? JSW

May 17th, 2002, 02:07 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	you can see the file on the floppy is is bright or geryed out> __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 02:54 PM	#1
Johnny2002 New Member Join Date: May 2002 Posts: 4	I have a excel file that was saved on a floppy from a server that I need to access. Since then the server has been removed and now we are on standalone PC,s. When I try to access the file from A: drive I get a message that the file can’t be accessed. I can go to windows explorer and see that the file is on the floppy so I know the file is there. So is there any work around to this problem? Thanks in advance. [ This Message was edited by: Johnny2002 on 2002-05-15 15:49 ] [ This Message was edited by: Johnny2002 on 2002-05-15 15:52 ]

May 15th, 2002, 05:06 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Sounds to me like you might have a bad floppy disk.

May 16th, 2002, 10:45 AM	#3
Johnny2002 New Member Join Date: May 2002 Posts: 4	There is another excel file on the disk that I am able to open. It is just this file that will not open. It seems to be looking for the server before it can open the file. Thanks

May 17th, 2002, 01:54 PM	#4
Johnny2002 New Member Join Date: May 2002 Posts: 4	Anybody have any ideas?

May 17th, 2002, 06:39 PM	#6
Johnny2002 New Member Join Date: May 2002 Posts: 4	The file is bright. So far the only thing I can think of is for some reason it is still looking for the server for the location of the file. I have tried copying the file to different locations, but with no luck.

May 17th, 2002, 07:15 PM	#7
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	You may have hidden links to a file once on the server. Try to find the links and delete them or change the location. Find links in a workbook There is no automatic way to find links used in a workbook. However, because links use brackets [ ] to enclose the source workbook name when it is closed, you can search for it. For example =SUM([Budget.xls]Annual!C10:C25). Close all workbooks except the one you want to find the links in. On the Edit menu, click Find. Click Options. In the Find what box, enter [. In the Within box, click Workbook. In the Look In box, click Formulas. Click Find All. In the box at the bottom, look in the Formula column for formulas that contain [. To select the cell with a link, select the row in the box at the bottom. Links are also commonly used in names, text boxes, or chart titles. Find links used in names On the Insert menu, point to Name, and then click Define. Select each entry in the Names in workbook list, and look in the Refers to box for links. Links contain a reference to another workbook, such as [Budget.xls]. Find links used in text boxes or chart titles Click the text box or chart title you want to check. In the formula bar , look for a reference to another workbook, such as [Budget.xls]. Find links used in other objects On the Edit menu, click Go To, and then click Special. Click Objects, and then click OK. Press TAB, and then look in the formula bar for a reference to another workbook, such as [Budget.xls]. The name of the object appears in the Name box. Repeat the previous step until each object is checked. Find links used in chart data series Select the data series you want to check. In the formula bar , look for a reference to another workbook, such as [Budget.xls]. To proceed to the next data series, press TAB. Repeat the previous two steps until each data series is checked. Just a shot, it might help? JSW