M
Morpheseus
I have an excel file that I use to manage clients. I have 1067
clients. I have 8 people in my department that edit the file. I have
another 200 staff that have read only access to the file.
Most of the time the file is about 1.3 MB in size. However, on
occassion the file gets very slow and swells to about 25 mb. When I
go to "tools" "Shared Workspace" it will show everyone who is
currently signed on to edit the file. Sometimes however, it shows the
same guy on three times. When this happens, the file creates a tmp
file in the directory.
It seems to me that excel is trying to remember what everyone is doing
so it can harmonize the saves. Is there any way of making the program
drop the earlier sign ons? Ie.. is there a better way I should be
maintining this file?
M.
clients. I have 8 people in my department that edit the file. I have
another 200 staff that have read only access to the file.
Most of the time the file is about 1.3 MB in size. However, on
occassion the file gets very slow and swells to about 25 mb. When I
go to "tools" "Shared Workspace" it will show everyone who is
currently signed on to edit the file. Sometimes however, it shows the
same guy on three times. When this happens, the file creates a tmp
file in the directory.
It seems to me that excel is trying to remember what everyone is doing
so it can harmonize the saves. Is there any way of making the program
drop the earlier sign ons? Ie.. is there a better way I should be
maintining this file?
M.