• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

pasting from a file without remote references

D

droopy

New Member
I'm working on a shared file, and one of my teammate needs also to work on the same file simultaneously.


I know we are not performing changes to the same tabs in the file, so there will be no overlap.


So I chose to work on a copy of the file, so as to keep progressing.


Now, when she will rearchive the file, I'll need to apply my changes to the latest version of the file.


There are many complex formulas that are relative to a raw data tab in the file.


I'd like to copy/paste the areas I changed in my local copy to the reference file.

However, if I do that, I'll end up with formulas referring the local copy.


Say reference file is named... ReferenceFile, and local copy LocalCopy.


I don't want to see in the reference file formulas with
Code: 
=sumproduct(LocalCopy!myRange)  but rather =sumproduct(myRange)
.


One option is to do my copy/paste, and then "play" with find&replace to remove any reference to LocalCopy!.


But I'm wondering if there is a less painful (and more elegant) option.


Thanks for your help
 
If there's no overlap, why not just use the shared file as is? There should be no need to make a copy.


Find & replace shouldn't be too painful. Actual formula referencing another workbook looks like:

=[OtherWorkbook.xlsx]SomeSheet!MyRange


So you can just do a find and replace for

[*.xls*]

to remove the workbook portion.
 
Luke, thank you for your answer. They are always fast and efficient.


blockquote If there's no overlap, why not just use the shared file as is? There should be no need to make a copy. /blockquote


Because the file is archived on sharepoint, and both my teammate and I picked version x.0 but after my teammate archives it it will be version y.0


So I'll still have to apply the changes to version y.0. If I simply rearchive on top of Y.0 version, I'll lose my teammate changes.


As I suspected, I'll have to go through a F&R. I hoped there could be some feature allowing me doing w/o that. There are so many of them I don't know yet ;-)


Thanks again.

Catherine (a.k.a droopy)
 
Ah, thanks for clarifying Catherine. I misunderstood "shared workbook" as using the shared workbook feature in XL, not an single workbook shared between people. =P
 
You must log in or register to reply here.
Back
Top