Saving changes in shared workbooks

G

Guest

Hi, I have a shared workbook that I've been using for years with 4 - 5 users
being able to use and update concurrently. All of a sudden we're experiencing
problems when we try to save changes if there's more than one current user on
the file. Permissions seem ok. Users can save if they alone have opened the
file. When more than one person is on we get errors like 'Excel cannot
complete this task with available resources. Choose less data or close other
applications.' Interestingly enough I have no other applications running and
I've got 512MB RAM on a 3.6MB file. The file is not read only when opened by
more than one user.

Any suggestions.
 
G

Guest

Check Help in vb Editor
There is a reference to UpdateChanges. I cannot remember specifics.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Some users not able to open excel shared workbook 2
shared workbook - shared workbook options grayed out 0
Qestion for share workbook 2
Shared Workbook 2
Shared Workbook Locked 2
corrupted shared excel workbook 1
Problem with multiple users opening a workbook 3
Shared Workbook is "in use by another user" 3

Top