Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Size
We have an Excel price sheet that is over 2mb. If we copy and paste all the
information into a new Excel book, the file size is less that 1mb. What can I change on the larger workbook in order to reduce the size? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Size
If you do CTRL-End on one of the sheets, does the cursor go beyond
where you think (know!) the data stops? Excel is not very good at claiming back memory from rows or columns whose contents have been deleted. This link to Debra Dalgleish's site explains how you can recover this manually: http://www.contextures.com/xlfaqApp.html#Unused Hope this helps. Pete On Aug 12, 10:32*pm, Conley wrote: We have an Excel price sheet that is over 2mb. *If we copy and paste all the information into a new Excel book, the file size is less that 1mb. What can I change on the larger workbook in order to reduce the size? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Auto size a pivot table to a page size | Excel Worksheet Functions | |||
custom size (page size) missing in excel 2003 | Setting up and Configuration of Excel | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) |