LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File size growing growing exponentially Steve Excel Discussion (Misc queries) 3 May 24th 09 06:29 PM
Shared workbook - font size problem Jeza Excel Discussion (Misc queries) 0 September 4th 07 04:02 AM
Shared workbook file size becoming very large Phrank Excel Discussion (Misc queries) 0 August 28th 07 01:50 AM
Shared Workbook inexplicably grows in size Bob Excel Discussion (Misc queries) 0 August 18th 06 01:29 PM
Shared Excel File keeps growing........ [email protected] Excel Discussion (Misc queries) 1 March 2nd 05 08:24 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"