<div>
Is the workbook shared? &nbsp;That can lead to file size increases... <br />
<br />
also your figures above are pretty huge - 3964 mb = 4gb!!?!<br />
[unless you're using european continental numbering, where commas are used instead of full stops.]
</div>


<div>
try <b>sheet1.range(&quot;A1&quot;).ClearCo<wbr />ntents</b><br />
or <br />
<b>sheet1.range(&quot;A1&quot;).Clear</b>
</div>


<div>
This can often happen. Very often Excel becomes confused about the real UsedRange. Google excel bloat and there's lots of articles like this one<br />
<br />
<br />
<br />
<a href="http://chandoo.org/wp/2014/01/17/big-trouble-in-little-spreadsheet/" rel="ugc">Fixing Excel Bloat</a>
</div>


<div>
@Qlemo: There are 4 cell's that have to be saved for a unique numbering of the reports<br />
<br />
@DanCh99: The workbook isn't shared and yes I’m European so 3964 kb<br />
<br />
@aikimark: I will try that to see if it makes a difference.<br />
<br />
Thanks for the fast responses.
</div>


<div>
If this growth can't be fixed, could you run some monthly housekeeping task to revert back to an original version?<br />
<br />
Have you seen what happens if you take a whole month's data and add it again to the original file - does it bloat to the same size as it does with the incremental changes?
</div>


<div>
After some testing i found out that it's really the macro's that are increasing and not the sheets.<br />
I have no clue why this happens, anybody an idea?<br />
<br />
I solved it by not saving the workbook like suggested by Qlemo.
</div>


<div>
How can the macros increase?<br />
<br />
Try using <a href="http://www.appspro.com/Utilities/CodeCleaner.htm" rel="ugc">Rob Bovey's Code Cleaner</a>
</div>


<div>
I don't know but that's what happening.<br />
<br />
Thanks for the tip, i'm already using it ;-)
</div>


<div>
How do you know that the macro size is increasing? Have you tried removing the code and comparing the size?
</div>


<div>
I checked every sheet and they all were cleared as it should. Then I used the code cleaner and the file size decreased back to it's original size. A decrease of 1mb
</div>


<div>
The code should not cause problems. If you read the explanation of why Rob Bovey developed the code 
<blockquote>
During the process of creating VBA programs a lot of junk code builds up in your files. If you don't clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files.
</blockquote>
<br />
The problem should be resolved by running code cleaner after development has finished. It should not be an ongoing problem
</div>


<div>
That's what I also thought, but after the file is used for 20 times the file size is increased 1mb and when I run then the code cleaner the file is back it's &nbsp;original size.
</div>


<div>
I've not come across this problem before. You can call the code cleaner from within your code.
</div>


<div>
I didn't know that, how do I run the code clean from a macro?
</div>


<div>
There's instructions with the download I believe<br />
<br />
The instruction are in the help files and the code is also available to use, check out the installation files usually<br />
<br />
C:\Program Files (x86)\AppsPro
</div>


<div>
Ok thank you for the information
</div>


<div>
<div class="content wysiwyg-content">
Dear all,<br />
<br />
I'm creating a macro enabled workbook (.xlsb) in excel for our technicians to use in order to facilitate the making of their reports.<br />
It's still a work in progress but i stumbled on a problem.<br />
Currently the workbook size is 3,694 mb.<br />
When it's used for the first time the size increases to 4,070 mb and the size keeps increasing (+- 20 kb) every time it's used but not as much as the first time it's used.<br />
When the workbook is used they insert all the data that's needed and the necessary documents are printed in pdf.<br />
After the documents are printed, all the inserted data is erased and the workbook closes automatically.<br />
To erase all the inserted data i unload all userforms and clear all &nbsp;the inserted data on the worksheets like the example below:<br />

<pre><code class="code-1 nolinks" id="code-10-28927829-1"><span>sheet1.range(&quot;A1&quot;).value=&quot;&quot;</span>
</code></pre>
<br />
How can i avoid the workbook size increase every time they use it?<br />
<br />
Best regards,<br />
Manu
</div>
</div>


Dear all,

I'm creating a macro enabled workbook (.xlsb) in excel for our technicians to use in order to facilitate the making of their reports.
It's still a work in progress but i stumbled on a problem.
Currently the workbook size is 3,694 mb.
When it's used for the first time the size increases to 4,070 mb and the size keeps increasing (+- 20 kb) every time it's used but not as much as the first time it's used.
When the workbook is used they insert all the data that's needed and the necessary documents are printed in pdf.
After the documents are printed, all the inserted data is erased and the workbook closes automatically.
To erase all the inserted data i unload all userforms and clear all  the inserted data on the worksheets like the example below:
(CODE)

How can i avoid the workbook size increase every time they use it?

Best regards,
Manu

XLSB workbook size increase

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.