Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / June 2008



Tip: Looking for answers? Try searching our database.

Maintaining File Links: Moving from PC to Mac

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben C. - 25 Jun 2008 14:06 GMT
Hello all,

This is my first post to this group. I did a search here and across
the web for an answer to this question but couldn't find one. I also
called Apple Care but the person I talked to didn't have an answer.

My issue involves moving from a PC to a Mac and wondering how I can
keep the links within my Excel files working when I move the files to
the Mac folder/directory structure.

I have an iMac running Leopard with a copy of MS Office running under
VMWare Fusion which is running Windows XP.

For example, on the PC I have a file linking to another file in a
completely different directory. Let's say the original file is at:

C:\Documents and Settings\Administrator\My Documents\FOLDER1\

The file above is linked to the following file in a different
directory located here:

C:\Documents and Settings\Administrator\My Documents\FOLDER2\

What kind of folder structure would I create on the Mac to have the
link above continue to work?

Thanks in advance for any assistance or pointers on how to go about
resolving this issue!

Ben Cacace
Bob Greenblatt - 25 Jun 2008 17:00 GMT
On 6/25/08 9:06 AM, in article
3da0c4b5-bd18-4438-a369-b4be8d53e213@y38g2000hsy.googlegroups.com, "Ben C."
<bcacace@gmail.com> wrote:

> Hello all,
>
[quoted text clipped - 26 lines]
>
> Ben Cacace
I don't think you need to worry about it. Just move the files. When you open
them Excel might ask to update the links, just do so and point to the new
location.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Ben C. - 25 Jun 2008 18:27 GMT
> I don't think you need to worry about it. Just move the files. When you open
> them Excel might ask to update the links, just do so and point to the new
> location.

Thanks but there are too many files to do this with. I'd be spending
too much time relinking my files.

Is there a way to create a file structure on the Mac that will
preserve the links?

Thanks again for your help.

Ben
Bob Greenblatt - 25 Jun 2008 20:57 GMT
On 6/25/08 1:27 PM, in article
ba1c722e-6acf-4609-9151-efeee25168d9@s50g2000hsb.googlegroups.com, "Ben C."
<bcacace@gmail.com> wrote:

>> I don't think you need to worry about it. Just move the files. When you open
>> them Excel might ask to update the links, just do so and point to the new
[quoted text clipped - 9 lines]
>
> Ben
Have you tried it? Name the folder and files the same on the mac as on the
PC.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Ben C. - 25 Jun 2008 22:43 GMT
> On 6/25/08 1:27 PM, in article
> Have you tried it? Name the folder and files the same on the mac as on the
> PC.

Thanks for the suggestion but what would the same folder name look
like?

\Documents and Settings\UserID\My Documents\ etc. etc.

I was hoping someone out there actually moved files from the PC to the
Mac with links in them and knew what the process would be.

Thanks again for the assistance.

Ben
Bob Greenblatt - 25 Jun 2008 23:46 GMT
On 6/25/08 5:43 PM, in article
beedc76a-6a9e-48a6-ac38-e1577c45fa09@l42g2000hsc.googlegroups.com, "Ben C."
<bcacace@gmail.com> wrote:

>> On 6/25/08 1:27 PM, in article
>> Have you tried it? Name the folder and files the same on the mac as on the
[quoted text clipped - 11 lines]
>
> Ben
Just put the files in the same named folders with the same names. The full
path is not necessary to duplicate.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Ben C. - 29 Jun 2008 23:12 GMT
Bob,

Thanks for the tips. Copying the files to same folders as before
worked well. I didn't realize that Windows XP under the virtual
machine is where the files get copied. I thought the files got copied
to the Mac side and somehow I pointed to these files from Windows XP.
Now I know a bit more than I did a week ago.

Thanks again.

Ben
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.