okay here is what i need to be able to do and please help me! i need to be able to work on my excel sheet at home, save the work on my memory stick and then upload it to the one at work (bear in mind that others use the one at work so i must ensure i only upload my work without writing over or effecting others work). how do i do it? a friend suggested that i use access to save and then import somehow...?
-
-
Hi. What you ask is, for the most part, impossible. You cannot in general update an off-line copy of an Excel file and expect that you can subsequently update another copy of the file on a different workstation at a different time without overwriting other user's work.
It is not clear what the scope of the changes that might be made could be; are you (or other users) changing row values which might then clash? If so, how would you determine which rows to change in the master copy? Are they (or you) adding or deleting rows, worksheets and so on? If so, how are you going to merge these changes into the master copy?
I should stress that the reason for asking these questions is simple: if you want to automate a process then you must be able to describe precisely in words the steps undertaken to achieve your goal. If you can't describe the steps in a precise way there is no chance that it can be automated on your behalf.
In summary, the main problem with working on an off-line copy of a file is that there is no simple way of knowing which differences between two files are significant, and therefore which should be kept and which not when trying to merge two files.
-Stewart
PS using Access would not help at all unless you were working on the master copy from your home PC, via some kind of network connection. Taking it off-line via a memory stick solves nothing and leaves you with the same difficulty in reconciling differences between file versions.
Comment