Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
Is this possible (Excel 2002)
We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
i agree
"Deborah" wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
SCROLL LOCK must be ON. Turn that OFF
-- Jacob (MVP - Excel) "Deborah" wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
Sorry, but what has scroll lock got to do with it?
"Jacob Skaria" wrote: SCROLL LOCK must be ON. Turn that OFF -- Jacob (MVP - Excel) "Deborah" wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
Oops..Please ignore the post (It was wrongly posted)
"Deborah" wrote: Sorry, but what has scroll lock got to do with it? "Jacob Skaria" wrote: SCROLL LOCK must be ON. Turn that OFF -- Jacob (MVP - Excel) "Deborah" wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
The easiest approach would be to say that you're only supporting the single
official version. Tell your bosses to tell your coworkers that they'll have to reenter their changes into that official version. If the boss finds out that there is an unapproved version still floating around (after xxx days), then that person is in big trouble. Yeah, I know. This won't happen. The real problem that I see is that even after you looked at each piece of data, how would you know what version to keep. (And this is a miserable job just to find the differences!) If I had to do this, I'd make a 4th workbook and with 15 worksheets (one for each of your sheets). Then I'd start copying the data from each of the 3 workbooks (all 15 sheets) into each of the new sheets. But I'd offset the data -- drop it in column B. Column A would contain the name of the workbook/worksheet that the row came from. Then if you're lucky, you could sort/filter/look for changes in each group. Mark each change (additional column per field??? or a single column for a change found???). Then start manually updating the records. (Ugh!) Ron de Bruin has lots of macros that could do the merging. http://www.rondebruin.nl/tips.htm (look for the "Copy/Paste/Merge examples" section. ============ As long as multiple people need access to the data (simultaneously???), you may want to consider dropping excel and using a different application -- a real database program (like Access???) that is made for keeping one version of that data. Deborah wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
Nothing.
Jacob posted this to the wrong message. Deborah wrote: Sorry, but what has scroll lock got to do with it? "Jacob Skaria" wrote: SCROLL LOCK must be ON. Turn that OFF -- Jacob (MVP - Excel) "Deborah" wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop People Copying a Workbook
There is no way to stop people from copying a workbook. Copying of files is
handled by your operating system. The XL file has no say in whether it gets copied or not. Even if the copy was made by doing a save as in XL it is your operating system that is ultimately doing the copy. I am with Dave on this one. If you need to share information among many users concurrently then XL is not a great choice. Databases are designed for concurrent access. -- HTH... Jim Thomlinson "Deborah" wrote: Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3 versions as obviously someone has created a copy and entered info in that one and not the original - there are 15 sheets in each one and now I have the horrible job of trying to work out which sheets in each are most up to date and merge them back into one - GRRR! |
#9
|
|||
|
|||
Quote:
try this link http://www.formulasoft.com/download.html - download Excel compare.
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - How to protect my workbbok from people copying my des | Excel Discussion (Misc queries) | |||
Workbook working on by two people | Excel Discussion (Misc queries) | |||
Stop the 'intelligent' copying? | Excel Discussion (Misc queries) | |||
Can i stop people from deleting my excel file | Excel Discussion (Misc queries) | |||
how do I stop people opening an excel sheet? | Excel Discussion (Misc queries) |