Reply to thread

Message: [QUOTE="Josh, post: 6791465"] I just moved my dad over from a Dell to a shiny G5. However, Excel has a problem with cells which are linked to other files. Obviously paths on windows are not the same as paths on the mac, but the dialog to change the links doesn't work. Here's what happens. I try to open spreadsheet A.xls in excel 2004, which has links to cell values in B.xls, C.xls, and D.xls. When Excel starts up, it immediately brings asks me if I want to fix the links (which makes sense, as the original paths were on a different machine and they don't work any more). When I indicate that I want to fix the links, it brings up a dialog box which allows me to locate B.xls. Naturally, I have B.xls in a nearby folder (though not in the same folder as A.xls). C.xls and D.xls are also located in the same folder as B.xls. Unfortunately, the excel dialog will not allow me to actually SELECT B.xls, even though I have located it in the Mac file hierarchy. What is going on here? Is this a bug? If this worked, it would become trivial to move these files to the mac and we could restrict our VirtualPC usage to actual windows-only applications. Instead, we have to *not* fix the links using the excel feature, then delete the cell value and re-create the link manually. What a schlep...especially for thousands of spreadsheets that are linked to the same dozen core spreadsheets. Any help is appreciated. [/QUOTE]