software

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.
--
Creator

Check Help in vb Editor
There is a reference to UpdateChanges. I cannot remember specifics.quot;Creatorquot; wrote:

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

Hi, I'm not using any macros.
--
Creatorquot;exceluserforemanquot; wrote:

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