Excel Workbook for Multi User Access

  • Thread starter Thread starter shahzad4u_ksa
  • Start date Start date
S

shahzad4u_ksa

Hi,

I want to prepare VBA Application for the Multi users with different
rights. how to prepare it.?

I want to know what is the Excel workbook Limitations, I mean If the
workbook goes to 5 MB OR 10 MB then what will happen. with the
database it effect the speed .... or what.

I want to use one workbook for 3 users at one time it is possible ?

Pls provide me the information regarding the above 3 questions.

Thanks in Advance.



Syed shahzad zafar
Madinah - KSA.
 
For multi users you would want a Shared workbook (Tools-Share Workbook) and
save it to a public drive accessible by all users. VBA will not run in
shared mode, but it will display the results of macros that are ran in
normal mode. In-cell changes can be made in shared mode for all to see. In
order to update a shared workbook with macros it would need to be opened by
one person only (probably the owner), unshare the workbook, run your macros,
then set workbook to Share again, and save it back to the public drive.

As far as workbook size and speed, obviously bigger is slower. The
limitations are governed by the computer that is opening the workbook, CPU,
RAM, network MBps, etc. A computer running WindowsXP, Excel 2003, dual core
CPU and 2 G of ram should have no problem with a 30 MB file.

Mike F
 
Back
Top