Shared workbook increase in size help needed

[I_know_nuffin]

I have a shared workbook that gets updated every morning with data from another main workbook via vba code to copy a range into the shared workbook

the problem I have is the shared workbook keeps getting bigger everytime its opened and closed from the main workbook
the shared workbook is so multiple staff can work on the data and update where necessary

Process is
main workbook opens shared workbook and copies the updated data and pastes back into a sheet in the main workbook

main workbook reloads data from a report, processes the data, X ref to the shared data for updates

the main workbook then copies the updated data back into the shared workbook

the problem I have is the shared workbook grows in size everytime its opened and closed via the main workbook

shared workbook start size 350K
after opening to copy out the updated data back to the main workbook size increases by about 200k to 550k
then after copying the data back from the main workbook size increases again by 200k to 750k

so in a week the shared workbook can be over 2000k which is a pain as it slows the whole process down

I can resolve this by unsharing the workbook and resharing again which sets it back to the 350k size

can anybody suggest a solution to stop this increase in size, or a way to automate the sharing - unsharing

any help greatly appreciated

 

[I_know_nuffin]

Hi

Can anybody suggest a solution to stop this increase in size, or a way to automate the sharing - unsharing

any help greatly appreciated