Prev: You cannot choose a connection file that is incompatible
Next: worksheet sliding when cell is tabbed
From: Dave Peterson on 5 May 2010 08:45
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
From: Jim Thomlinson on 5 May 2010 10:09
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!
From: bala_vb on 5 May 2010 13:41

Deborah;951267 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!

I would like to recommend a software tool that helps you to compare the
spreadsheets. This is going to be some manual task also

try this link
http://www.formulasoft.com/download.html
-> download Excel compare.




--
bala_vb
First  |  Prev  | 
Pages: 1 2
Prev: You cannot choose a connection file that is incompatible
Next: worksheet sliding when cell is tabbed