Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-15-2018, 08:10 PM
eduzs eduzs is offline Why my Docm file does not shrink in size? Windows 10 Why my Docm file does not shrink in size? Office 2010 32bit
Expert
Why my Docm file does not shrink in size?
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default Why my Docm file does not shrink in size?

Just for curiosity,
I have a DOCM file that I removed a dozen unnecessary text boxes in a userform and one or two subs etc., but the file sizes change so little or not at all.
Even when I just open the file and save the sizes grew (only once) with no modification at all from 283kb to +- 300kb.
Exactly at this moment I deleted 3 lines of the code and the size increased from 306kb to 309kb.


Thanks
Reply With Quote
  #2  
Old 09-15-2018, 10:01 PM
Guessed's Avatar
Guessed Guessed is offline Why my Docm file does not shrink in size? Windows 10 Why my Docm file does not shrink in size? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Is Revision Tracking turned on?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 09-16-2018, 12:47 AM
macropod's Avatar
macropod macropod is offline Why my Docm file does not shrink in size? Windows 7 64bit Why my Docm file does not shrink in size? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The compressibility of a given document in the XML format depends on what the content is, not just the amount of it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 09-16-2018, 04:13 AM
eduzs eduzs is offline Why my Docm file does not shrink in size? Windows 10 Why my Docm file does not shrink in size? Office 2010 32bit
Expert
Why my Docm file does not shrink in size?
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default

Thanks!

Is Revision Tracking turned on? No

I exported all 3 userforms and 2 modules, then created a new .DOCM file.
Then I imported all these content to the new DOCM file.
The size at the 1st save decreased from 310kb to 74kb, after using the file, it's grows* to 104kb, but still 1/3 the size of the original file.
* The file just auto save each time it's opened (form queryclose event) a docvariable with len 4 "0000" to save some parameters.
After using a few times, the size now ranges from 79ks to 101kb all (It has now stabilized in 95kb)
I suppose, somehow, it keeps deleted data (especially from excluded controls forms modules, causing this size difference).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to animate a photo to start zoomed in and then shrink to normal size? Tabathavm PowerPoint 2 05-05-2018 01:26 PM
any way to shrink size of embedded fonts? rod2 PowerPoint 0 06-03-2016 07:08 AM
Why my Docm file does not shrink in size? SaveAs docm file from template ptmuldoon Word VBA 7 03-09-2015 05:38 PM
Why my Docm file does not shrink in size? How to convert docm to dotm without opening the file Moz Word 1 12-20-2012 04:23 PM
Possible to shrink .DOC file? uoficowboy Word 0 06-09-2010 10:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft