Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Switching from Excel XP to Excel 2004
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
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]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Switching from Excel XP to Excel 2004
Top