XL2007 workbook with multiple users?
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 |
XL2007 workbook with multiple users?
On Mon, 29 Dec 2008 11:56:46 -0800 (PST), Ed from AZ wrote:
¤ 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) |
XL2007 workbook with multiple users?
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 On Dec 29, 1:14*pm, Paul Clement wrote: On Mon, 29 Dec 2008 11:56:46 -0800 (PST), Ed from AZ wrote: ¤ 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) |
All times are GMT +1. The time now is 04:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com