How to share work on Excel files with formula links, sent via email?
November 9, 2005 9:39 PM Subscribe
Excel experts? Between two Excel files, anyone know how I can reassign the data source file when I'm working on my Mac with files emailed to me by my boss, created on his PC?
posted by seaward to Computers & Internet (3 answers total)
To be more specific: how we work it is that he is sends me an Excel file we call "octoberdata" and various other Excel files that need to draw upon this "octoberdata" file. And he's already got the linking and formulas in place in the various files that link to "julydata" which--when we open the files to be updated at his place, on his PC--we are able to easily reassign/change the source file to "octoberdata" via dialogue boxes the PC just walks you through. Meanwhile, back at my place, on my Mac ibook (excel X), it won't give me the same dialogue box to choose the new "octoberdata" as source. Any ideas, some way of saving the files I get from him, something obvious I'm missing that would allow me to make that same global reassignment of the data source file on my end? Many thanks for any insights.