Shared workbook keeps increasing in the data back to the shared book

I_know_nuffin

Board Regular
Joined
Nov 17, 2022
Messages
145
Office Version
  1. 2021
Platform
  1. Windows
Hi All
I have a shared workbook that other staff update - its shared so multiple staff can work on it at the same time

Every morning I run a report that copies the data from 1 tab in the shared sheet into my reporting workbook
this is all done via a VBA routine
open shared book, copy data, paste into reporting workbook, close shared book, the bit I don't understand is why the shared workbook increases in size by about 100k when it closes

Once I have run the days reports I copy the results back into the shared book
open shared book, empty data TAB, copy data, paste into shared workbook, save and close shared book, the other bit I don't understand is why the shared workbook now increases in size by about 300k

Can anybody shed any light on why the size keeps increasing, and suggest how to stop it

Thanks

David
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,215,745
Messages
6,126,630
Members
449,323
Latest member
Smarti1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top