changing links to other worksheets on a shared drive

[mads]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi all,
I created a worksheet on my PC which had links to other worksheets on the hard drive and it all worked well.

Bought myself a wireless network access drive (Buffalo Linkstation) and decided to move all my files on to there. All fine.

I now open the one workbook on my mac and it asks me to update the links. Problem is that though I browse to the files on the NAS, it wont let me select them. They are faded and unselectable. I can open the files seperately so dont think it is an access issue, I just cant create a link to them to update the location within the main workbook.

Any ideas?

 

[John McGhie]

No Idea at all

Try this:

1) Navigate to one of those files in Finder, right-click, do "Get Info" and
Copy the "Where" path (it doesn't look like it's copyable, but it is...)

2) Paste that into TextEdit.

3) Now copy the file name and paste that on the end.

4) Select the whole thing and copy.

5) Come back to Excel, create a link, and try to use what you copied as the
source.

What happens?

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi
all,
I created a worksheet on my PC which had links to other worksheets on the hard
drive and it all worked well.

Bought myself a wireless network access drive (Buffalo Linkstation) and
decided to move all my files on to there. All fine.

I now open the one workbook on my mac and it asks me to update the links.
Problem is that though I browse to the files on the NAS, it wont let me select
them. They are faded and unselectable. I can open the files seperately so dont
think it is an access issue, I just cant create a link to them to update the
location within the main workbook.

Any ideas?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[mads]

Thank you for the reply John.

The "where" path does not allow me to copy it. However, I seem to have sorted it. I opened up the workbook where the data is being imported from and re-saved it. Then opened the workbook with the links and it allowed me to update the links. Only problem now is that it keeps asking me to update the link each time I open the file. But its a small price to pay now that it works.

Thanks once again.