Prev: This book has lost its VBA project, ActiveX controls and other fea
Next: Problem removing page break
From: Robert Crandal on 22 Feb 2010 17:35
Then why does Excel 2007 have a feature called
"Share Workbook"?? What is the purpose of this setting?
The help caption for this button reads: "Allows multiple people
to work in a workbook at the same time" Would this
benefit me in any way??

thank u B Lynn B


"B Lynn B" <BLynnB(a)discussions.microsoft.com> wrote in message
news:E812227C-75ED-4D55-B706-82CDDF050406(a)microsoft.com...
>
> Just don't do it. Excel file sharing for a purpose like this just creates
> more headaches than it's worth.
>
> If it's important to use excel instead of a database to collect data from
> users, then create a template file, give them each a copy, and have them
> store the copies in a common location with a consistent naming convention.
> Then use VBA to automate the collection of the data from their separate
> files.
>

 | 
Pages: 1
Prev: This book has lost its VBA project, ActiveX controls and other fea
Next: Problem removing page break