XL2007 workbook with multiple users?

[Ed from AZ]

I have an XL 2007 workbook on a server. The workbook must be accessed
by multiple users with full write/modify permissions. So far, not a
problem - until more than one person tries to access the workbook at
the same time! The workbook is saved as a Shared File, and there are
no protections.

The set-up of the workbook was intended to be as painless for the user
as possible - there is a "form" created from cells (not a User Form)
on one page. Most of the time, all they need to do is enter data into
the "form" and hit the button to run a macro that enters their data.
Occasionally, though, someone needs to create a new worksheet. I
tried doing that with a macro also, so the users would not have to
worry about correctly creating the new sheet so the data entry macro
would see it and properly enter the data, but Excel woulid not allow
those modifications.

I had thought about creating a VB6 (Classic) wrapper" for the
workbook, and put all the functions in the VB program, vice macros in
Excel. Would that alow greater flexibility for the multiple users?
Or is there a simple way to get XL 2007 to allow modifications by
multiple users across a server?

Ed

 

[Paul Clement]

¤ I have an XL 2007 workbook on a server. The workbook must be accessed
¤ by multiple users with full write/modify permissions. So far, not a
¤ problem - until more than one person tries to access the workbook at
¤ the same time! The workbook is saved as a Shared File, and there are
¤ no protections.
¤
¤ The set-up of the workbook was intended to be as painless for the user
¤ as possible - there is a "form" created from cells (not a User Form)
¤ on one page. Most of the time, all they need to do is enter data into
¤ the "form" and hit the button to run a macro that enters their data.
¤ Occasionally, though, someone needs to create a new worksheet. I
¤ tried doing that with a macro also, so the users would not have to
¤ worry about correctly creating the new sheet so the data entry macro
¤ would see it and properly enter the data, but Excel woulid not allow
¤ those modifications.
¤
¤ I had thought about creating a VB6 (Classic) wrapper" for the
¤ workbook, and put all the functions in the VB program, vice macros in
¤ Excel. Would that alow greater flexibility for the multiple users?
¤ Or is there a simple way to get XL 2007 to allow modifications by
¤ multiple users across a server?

Did you set the Share Workbook Editing option to allow changes by more than one user at a time?

The following may help troubleshoot the issue as well:

http://support.microsoft.com/kb/271513


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Ed from AZ]

Hi, Paul.

Did you set the Share Workbook Editing option to allow changes by more than one user at a time?

Yes, I did. The workbook is at work, and I'm still off on vacation
until next week, so I can't check specifics. But I do know I did
that. I just wanted to collect some insight before I go back and
start trying to craft a VB wrapper or dig into the workbook settings -
i usually make things worse that way!! 8>)

Ed