mads
|
| posted on 10/3/10 at 12:52 PM |
|
|
linking to other Excel workbooks on a NAS (using MS Office for Mac 2008)
I am hoping someone can help with this and it's probably easy to do but I am cant figure it out...
Originally on my PC, I created some Excel workbooks to do house budgeting etc. Now in this one workbook, I created SUM equations to pull data from
another workbook and do some calculations with it. All worked fine.
I have since moved all the files to my NAS and changed the structure of the folders e.g. names etc so obviously the links in the workbooks no longer
work. I have tried to update the links but when I browse through to the folder on the NAS containing the workbook, the file is greyed out so I cant
select it. I cant figure out why it is greyed out. If I go into the NAS drive outside of Office, I can open the files no problem.
Here is what I am running:
Buffalo Linkstation NAS
Macbook Pro
Office for Mac 2008
any help would be appreciated. At the moment, the links in the original workbook seem to have made up the location of the other workbooks as being
somewhere on the Mac 
We gain knowledge faster than we do wisdom!
Life is not a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in
sideways, thoroughly used, totally worn out and loudly proclaiming... "f*ck, what a trip!"
|
|
|
|
|
bi22le
|
| posted on 10/3/10 at 04:45 PM |
|
|
I know abit about NAS and MS software.
My first thoughts are that the version of Excel your using cant read the file.
Can you just open the doc and read it wth out linking it? If no\yes then fault find from there.
Are all the docs you want to link in the same folder? This is good neat pratice and will work better when a NAS is involved.
Try copying all of the files onto the MAC then try linking them. If that works copy across to NAS and reaccess and edit as originally tried.
HTH
Track days ARE the best thing since sliced bread, until I get a supercharger that is!
Please read my ring story:
http://www.locostbuilders.co.uk/forum/13/viewthread.php?tid=139152&page=1
Me doing a sub 56sec lap around Brands Indy. I need a geo set up! http://www.youtube.com/watch?v=EHksfvIGB3I
|
|
|
mads
|
| posted on 10/3/10 at 05:50 PM |
|
|
Hi bi22le,
thanks for the reply.
Both files were created in Office 2007 and were working fine when on the PC.
Both files can be open and read separately on the mac, whilst saved on the NAS. If anything the MS Office on the Mac is newer than the one on the PC
so should read it no problem.
Problem comes in terms of the links need updating in the one workbook to link to the other one.
Will try what you've suggested in terms of moving the files on to the Mac and then back to NAS.
We gain knowledge faster than we do wisdom!
Life is not a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in
sideways, thoroughly used, totally worn out and loudly proclaiming... "f*ck, what a trip!"
|
|
|
prawnabie
|
| posted on 10/3/10 at 06:24 PM |
|
|
Have you set the permissions on the nas to allow you to edit files?
|
|
|
mads
|
| posted on 10/3/10 at 07:16 PM |
|
|
yep, one of the first things I checked.
also, I can make changes to the workbook e.g. add in numbers and save. Just the linking to another workbook it wont let me do.
We gain knowledge faster than we do wisdom!
Life is not a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in
sideways, thoroughly used, totally worn out and loudly proclaiming... "f*ck, what a trip!"
|
|
|
