Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can i reduce my file that's 29 MB but filled with blank cells?
I used a macro to import data into a new worksheet. there isn't a great deal
of info the spreadsheet (probably about 29KB) but the worksheet has a size in excess of 29MB. It seems to be filled with blank cells (no formulae) as the scroll bar on the right is tiny and if you drag it to the bottom the row number shows 60-odd thousand. How can I reduce this file so it just saves the cells with data? The worksheet itself does not have a macro within it. |
#2
|
|||
|
|||
zapadias, have a look here and see if this helps
http://www.contextures.com/xlfaqApp.html#Unused -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "zapadias" wrote in message ... I used a macro to import data into a new worksheet. there isn't a great deal of info the spreadsheet (probably about 29KB) but the worksheet has a size in excess of 29MB. It seems to be filled with blank cells (no formulae) as the scroll bar on the right is tiny and if you drag it to the bottom the row number shows 60-odd thousand. How can I reduce this file so it just saves the cells with data? The worksheet itself does not have a macro within it. |
#3
|
|||
|
|||
Check Debra Dalgleish's website:
http://www.contextures.com/xlfaqApp.html#Unused -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I used a macro to import data into a new worksheet. there isn't a great deal of info the spreadsheet (probably about 29KB) but the worksheet has a size in excess of 29MB. It seems to be filled with blank cells (no formulae) as the scroll bar on the right is tiny and if you drag it to the bottom the row number shows 60-odd thousand. How can I reduce this file so it just saves the cells with data? The worksheet itself does not have a macro within it. |
#4
|
|||
|
|||
save it as a .CSV file? -- saybut ------------------------------------------------------------------------ saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949 View this thread: http://www.excelforum.com/showthread...hreadid=396798 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reduce size file | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
How do I reduce the size of an exel file? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) |