Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size...
Howdie...
I have a small workbook (3sheets) that uses advanced filter to copy and paste data from sheet A to Sheet C. The total list of data in sheet A is just 10 lines, and my filter selects and copies two lines of this to a sheet c, but yet my file size is 4 megs. Sheets A and Sheets C are the big ones (If I delete them file size drops) but as they contain hardly any data I dont know why... Any macros or ideas that I can do to solve the problem... are most welcome... Regards D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size...
in sheet A, do Edit=Goto=special and select last cell.
If you go way past row 10, then that is your problem. You need to go to the namebox, then type in 11:65536 and hit enter. Then Edit=Delete Repeat in Sheet C. Now save the workbook. these resets the number of Cells Excel is maintaining detailed information on. -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Howdie... I have a small workbook (3sheets) that uses advanced filter to copy and paste data from sheet A to Sheet C. The total list of data in sheet A is just 10 lines, and my filter selects and copies two lines of this to a sheet c, but yet my file size is 4 megs. Sheets A and Sheets C are the big ones (If I delete them file size drops) but as they contain hardly any data I dont know why... Any macros or ideas that I can do to solve the problem... are most welcome... Regards D *** Sent via Developersdex http://www.developersdex.com *** |
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) | |||
Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming |