Hello all

i have a couple of workbooks that are copies of each other. i need to merge
them. it seems that you have to share the workbook before this function
works. is there anyway to turn this feature on with a workbook that is a copy?

understand that someone just copied and pasted the workbook to a different
folder, and now we have 2 workbooks which are almost exactly the same, but
different enough that i have to try a merge.

any suggestions?

If someone took an existing workbook, copied it whole, and made
changes, wouldn't that be the most updated workbook? If so, why would
you need the previous one?

--JP


On Aug 12, 2:42*pm, DawnTreader
wrote:
Hello all

i have a couple of workbooks that are copies of each other. i need to merge
them. it seems that you have to share the workbook before this function
works. is there anyway to turn this feature on with a workbook that is a copy?

understand that someone just copied and pasted the workbook to a different
folder, and now we have 2 workbooks which are almost exactly the same, but
different enough that i have to try a merge.

any suggestions?

Hello JP

cause i was making changes to the original. so now there are 2 copies that
have different data. :(

"JP" wrote:

If someone took an existing workbook, copied it whole, and made
changes, wouldn't that be the most updated workbook? If so, why would
you need the previous one?

--JP


On Aug 12, 2:42 pm, DawnTreader
wrote:
Hello all

i have a couple of workbooks that are copies of each other. i need to merge
them. it seems that you have to share the workbook before this function
works. is there anyway to turn this feature on with a workbook that is a copy?

understand that someone just copied and pasted the workbook to a different
folder, and now we have 2 workbooks which are almost exactly the same, but
different enough that i have to try a merge.

any suggestions?

That happens almost daily in my office it seems :) It's hard to
control when multiple people have access to a shared document. The
only thing I can suggest is roll up your sleeves, copy the second
workbook into the first, and start copying the new data. Then you can
put it on your list of accomplishments for the year, or add it to your
resume :) Or try to get the person who made the copy to do it.

--JP


On Aug 12, 5:09 pm, DawnTreader
wrote:
Hello JP

cause i was making changes to the original. so now there are 2 copies that
have different data. :(

"JP" wrote:
If someone took an existing workbook, copied it whole, and made
changes, wouldn't that be the most updated workbook? If so, why would
you need the previous one?

--JP

On Aug 12, 2:42 pm, DawnTreader
wrote:
Hello all

i have a couple of workbooks that are copies of each other. i need to merge
them. it seems that you have to share the workbook before this function
works. is there anyway to turn this feature on with a workbook that is a copy?

understand that someone just copied and pasted the workbook to a different
folder, and now we have 2 workbooks which are almost exactly the same, but
different enough that i have to try a merge.

any suggestions?