| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I compress a large file?
I have a large Excel file - multiple tabs that is approximately 320,000 KB.
I am having trouble with the file because it is so large. Some of the data in the file is linked from other files, I have used conditional formating on the sheets and various other forumals throughout the file. Any thoughts on how to reduce the file size? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compress a large file?
You can make sure that you don't have any blank rows in the document that
contain formatting, or used to contain data at some point. The following web address has a tip sheet on removing dead wood from your file by removing columns and rows that are no longer in use. Additionally, you might want to cut back on some of the formatting as well to knock some bytes off the size of the file. -- Kevin Backmann "BUD1888" wrote: I have a large Excel file - multiple tabs that is approximately 320,000 KB. I am having trouble with the file because it is so large. Some of the data in the file is linked from other files, I have used conditional formating on the sheets and various other forumals throughout the file. Any thoughts on how to reduce the file size? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compress a large file?
Kevin:
Thanks for your cooments but I don't see the website. Can you supply that again? Thanks. "Kevin B" wrote: You can make sure that you don't have any blank rows in the document that contain formatting, or used to contain data at some point. The following web address has a tip sheet on removing dead wood from your file by removing columns and rows that are no longer in use. Additionally, you might want to cut back on some of the formatting as well to knock some bytes off the size of the file. -- Kevin Backmann "BUD1888" wrote: I have a large Excel file - multiple tabs that is approximately 320,000 KB. I am having trouble with the file because it is so large. Some of the data in the file is linked from other files, I have used conditional formating on the sheets and various other forumals throughout the file. Any thoughts on how to reduce the file size? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compress a large file?
Sorry about that, you caught me in a Ready/Fire/Aim moment.
Here's the link: http://www.contextures.com/xlfaqApp.html#Unused -- Kevin Backmann "BUD1888" wrote: Kevin: Thanks for your cooments but I don't see the website. Can you supply that again? Thanks. "Kevin B" wrote: You can make sure that you don't have any blank rows in the document that contain formatting, or used to contain data at some point. The following web address has a tip sheet on removing dead wood from your file by removing columns and rows that are no longer in use. Additionally, you might want to cut back on some of the formatting as well to knock some bytes off the size of the file. -- Kevin Backmann "BUD1888" wrote: I have a large Excel file - multiple tabs that is approximately 320,000 KB. I am having trouble with the file because it is so large. Some of the data in the file is linked from other files, I have used conditional formating on the sheets and various other forumals throughout the file. Any thoughts on how to reduce the file size? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compress file to a smaller size without using 3rd party applicatio | Excel Discussion (Misc queries) | |||
| How can I further compress a zipped Excel file that is 148MB? | Excel Discussion (Misc queries) | |||
| Compress big Excel file | Excel Discussion (Misc queries) | |||
| Compress file | Excel Discussion (Misc queries) | |||
| How to compress an Excel file once deleting extra worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
