| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I minimize the file size of an Excel spreadsheet?
I have a multi-page Excel spreadsheet. Each page only uses an 8.5 x 11 inch
area, yet the file is 22 megabytes. It takes a long time to open and save. |
|
#2
|
|||
|
|||
|
If you hit ctrl-end (on each worksheet), do you go way past where you know the
data ends? If yes... Visit Debra Dalgleish's site for some techniques for resetting that lastusedcell. http://www.contextures.com/xlfaqApp.html#Unused And if you have pictures/objects/comments embedded on those worksheets, they could be causing trouble. Eileen Adams wrote: I have a multi-page Excel spreadsheet. Each page only uses an 8.5 x 11 inch area, yet the file is 22 megabytes. It takes a long time to open and save. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel chart file size | Charts and Charting in Excel | |||
| VLOOKUP blows up file size | Excel Worksheet Functions | |||
| We have an excel file that is 52 megs in size and do not know why. | Excel Discussion (Misc queries) | |||
| How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
