Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Compressing an Excel Workbook?
- Thread starter mlrmlr
- Start date
Hi there,
Not in the traditional sense, no. You can zip the file if you have a zip program, but you'd need to unzip it for use. The only way to streamline your workbooks is to make it streamlined yourself. Is there a specific issue here you're looking at?
Regards,
Zack Barresse
Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci
Not in the traditional sense, no. You can zip the file if you have a zip program, but you'd need to unzip it for use. The only way to streamline your workbooks is to make it streamlined yourself. Is there a specific issue here you're looking at?
Regards,
Zack Barresse
Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci
- Thread starter
- #3
More info for you...
Access databases accumulate blank space as records are deleted . Excel workbooks are different because the entire file is rewritten whenever you Save it, compared to Access which simply adds new records to the end of the database.
It is possible to compress excel workbooks if you have them stored on a NTFS volume. NTFS support compressed files where the file is compressed and uncompressed automatically as needed and is invisible to the user.
Right-click the file in Windows Explorer, click Properties, click the Advanced button, and tick the Compress Contents checkbox. Click Ok to get out, and it's done. You can see how much space is being used compared to the actual file size in that same Properties window.
Access databases accumulate blank space as records are deleted . Excel workbooks are different because the entire file is rewritten whenever you Save it, compared to Access which simply adds new records to the end of the database.
It is possible to compress excel workbooks if you have them stored on a NTFS volume. NTFS support compressed files where the file is compressed and uncompressed automatically as needed and is invisible to the user.
Right-click the file in Windows Explorer, click Properties, click the Advanced button, and tick the Compress Contents checkbox. Click Ok to get out, and it's done. You can see how much space is being used compared to the actual file size in that same Properties window.
- Status