Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File size growing growing exponentially | Excel Discussion (Misc queries) | |||
Shared workbook - font size problem | Excel Discussion (Misc queries) | |||
Shared workbook file size becoming very large | Excel Discussion (Misc queries) | |||
Shared Workbook inexplicably grows in size | Excel Discussion (Misc queries) | |||
Shared Excel File keeps growing........ | Excel Discussion (Misc queries) |