View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PullingMyHairOut PullingMyHairOut is offline
external usenet poster
 
Posts: 3
Default shared workbook growing in size

Hello, I have a document that is shared with 10-15 people. All of us have
either MO 2003 or 2007. The document has a few lines of code in VBA that run
on the selection change event that calculate due dates. Gradually throughout
the week the file increases in size from 120KB to 100,000KB although little
to no data is being added. The document then begins to open slowly and take a
long period of time when saving. I have the shared options set to not track
changes and I daily go in and remove users who have been in since the
previous day. I have researched online and the only solution I have found is
to use Access which is not viable because my co-workers are not familiar with
the program. Any ideas???? Thanks.