J
John
I work for a large company which uses a shared excel file on a network drive
to track jobs that are being worked. 15 (+/- 5) people access this document
several times a day and input dates to track milestones of every job which at
any one time could have 6-8 people using it simulatiously. The normal file
size is around 2 megabytes and has 4 modules, 1 form and a fair amount of
code which I manipulate data and parce workable jobs from non-workable and
have excel automatically email dynamically created workbooks to the field to
show which jobs are workable. We have an issue where some of the users are
staying locked in the file overnight which I assumed was due to them not
shutting down excel properly. Once locked the file size grows quickly until
I am able to boot them out and unshare and re-share the file. This was the
old solution that no longer works. I've removed data and sheets from the
workbook one by one while saving to isolate the problem but with no data on
the worksheets its still over 10mb. The only solution I have is to delete
the worksheet tab with the data completely and recreate the data which brings
it back down to 2mb. Some cache or hidden force is keeping this file huge
which I suspect is related to tracking changes but turning that off does not
offer help. The data amount is roughly 48 columns wide by 600-800 rows long
and a few of the fields have more then 256 characters to describe the work to
be performed. I've researched this issue now for 3 hours before creating
this post and have tried searching for objects via F5, deleting unused cells
and nothing resolves this issue. Only 4 picture objects on the file which
are buttons I created to show the form and do other minimal tasks. Sorry for
being long-winded but I wanted to make sure all is out there for review.
to track jobs that are being worked. 15 (+/- 5) people access this document
several times a day and input dates to track milestones of every job which at
any one time could have 6-8 people using it simulatiously. The normal file
size is around 2 megabytes and has 4 modules, 1 form and a fair amount of
code which I manipulate data and parce workable jobs from non-workable and
have excel automatically email dynamically created workbooks to the field to
show which jobs are workable. We have an issue where some of the users are
staying locked in the file overnight which I assumed was due to them not
shutting down excel properly. Once locked the file size grows quickly until
I am able to boot them out and unshare and re-share the file. This was the
old solution that no longer works. I've removed data and sheets from the
workbook one by one while saving to isolate the problem but with no data on
the worksheets its still over 10mb. The only solution I have is to delete
the worksheet tab with the data completely and recreate the data which brings
it back down to 2mb. Some cache or hidden force is keeping this file huge
which I suspect is related to tracking changes but turning that off does not
offer help. The data amount is roughly 48 columns wide by 600-800 rows long
and a few of the fields have more then 256 characters to describe the work to
be performed. I've researched this issue now for 3 hours before creating
this post and have tried searching for objects via F5, deleting unused cells
and nothing resolves this issue. Only 4 picture objects on the file which
are buttons I created to show the form and do other minimal tasks. Sorry for
being long-winded but I wanted to make sure all is out there for review.