View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Betts Richard Betts is offline
external usenet poster
 
Posts: 1
Default Memory hungry worksheets and workbooks

I use a shared workbook with approximately 8 users constantly updating
information and saving throughout the working day. When I recreate the data
in a new workbook the file size is 384kb so it is not too bad. Within two or
three days teh file size increases to 10mb and causes problems with both
opening and saving with multiple users.

Any thoughts on how I can cur this problem without constantly recreating teh
workbook by copying data from original, closing original and saving new over
original file name.


--
Richard Betts - UK