Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Reduction Tool
When making excel workbooks, I found that excel puts in a lot of extra
programming, therefore making the size of a workbook go up to 25MB. Which causes difficulty when e-mailing the workbook. A solution found is by deleting all extra empty cells, yet this is impractical. Is there a way to clean it up without having to manually erase all of the extra cells. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Reduction Tool
Rima
Debra Dalgleish has VBA code to reset the used range on each worksheet in a workbook. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote: When making excel workbooks, I found that excel puts in a lot of extra programming, therefore making the size of a workbook go up to 25MB. Which causes difficulty when e-mailing the workbook. A solution found is by deleting all extra empty cells, yet this is impractical. Is there a way to clean it up without having to manually erase all of the extra cells. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Reduction Tool
Thanks Gord,
I am able to do it, yet I was wondering if there is an actual tool that does that. When I searched on Google, I found that Sobolsoft has a tool. Yet due to the fact that all of the trial versions need you to actually sign up and pay to use it, I am reluctant to buy it without trying it. I want a tool that our users are able to use so they can fix this process themselves. Rima "Gord Dibben" wrote: Rima Debra Dalgleish has VBA code to reset the used range on each worksheet in a workbook. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote: When making excel workbooks, I found that excel puts in a lot of extra programming, therefore making the size of a workbook go up to 25MB. Which causes difficulty when e-mailing the workbook. A solution found is by deleting all extra empty cells, yet this is impractical. Is there a way to clean it up without having to manually erase all of the extra cells. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Reduction Tool
I have no knowledge of any third-party tool such as you describe. However, I did download the Sobolsoft Excel file reducer setup.exe and ran it. If you just keep clicking No to the "do you want to register etc." you can get the file reducer to work. It dropped the sizes on a couple of workbooks I had set up with artificially large used ranges. Sobolsoft deleted all the unused rows and columns on sheets, which Debra's code does. Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 09:10:02 -0700, Rima wrote: Thanks Gord, I am able to do it, yet I was wondering if there is an actual tool that does that. When I searched on Google, I found that Sobolsoft has a tool. Yet due to the fact that all of the trial versions need you to actually sign up and pay to use it, I am reluctant to buy it without trying it. I want a tool that our users are able to use so they can fix this process themselves. Rima "Gord Dibben" wrote: Rima Debra Dalgleish has VBA code to reset the used range on each worksheet in a workbook. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote: When making excel workbooks, I found that excel puts in a lot of extra programming, therefore making the size of a workbook go up to 25MB. Which causes difficulty when e-mailing the workbook. A solution found is by deleting all extra empty cells, yet this is impractical. Is there a way to clean it up without having to manually erase all of the extra cells. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Reduction Tool
Thanks Gord,
I did try it and the tool reduced the size of the file temendously. I am just curious, In a workbook where would the code be placed? Is there a certain page which would affect all of them? or would it have to be done page for page. Rima "Gord Dibben" wrote: I have no knowledge of any third-party tool such as you describe. However, I did download the Sobolsoft Excel file reducer setup.exe and ran it. If you just keep clicking No to the "do you want to register etc." you can get the file reducer to work. It dropped the sizes on a couple of workbooks I had set up with artificially large used ranges. Sobolsoft deleted all the unused rows and columns on sheets, which Debra's code does. Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 09:10:02 -0700, Rima wrote: Thanks Gord, I am able to do it, yet I was wondering if there is an actual tool that does that. When I searched on Google, I found that Sobolsoft has a tool. Yet due to the fact that all of the trial versions need you to actually sign up and pay to use it, I am reluctant to buy it without trying it. I want a tool that our users are able to use so they can fix this process themselves. Rima "Gord Dibben" wrote: Rima Debra Dalgleish has VBA code to reset the used range on each worksheet in a workbook. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote: When making excel workbooks, I found that excel puts in a lot of extra programming, therefore making the size of a workbook go up to 25MB. Which causes difficulty when e-mailing the workbook. A solution found is by deleting all extra empty cells, yet this is impractical. Is there a way to clean it up without having to manually erase all of the extra cells. Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel File Size Reduction Tool
Rima
The code from Debra's site would be copy/pasted to a General Module in the workbook or your Personal.xls if you want to have the macro available for all open workbooks. First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project by name and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. To place a button on a Toolbar...ToolsCustomizeCommandsMacros. Drag the smiley-face button to your Toolbar. Right-click and "Assign Macro". Select TOGGLECENTERACROSS and OK Note: when you right-click you will also see "Change Button Image". There are a bunch of button faces to pick from if you don't like smiley. Gord On Mon, 26 Jun 2006 12:39:02 -0700, Rima wrote: Thanks Gord, I did try it and the tool reduced the size of the file temendously. I am just curious, In a workbook where would the code be placed? Is there a certain page which would affect all of them? or would it have to be done page for page. Rima "Gord Dibben" wrote: I have no knowledge of any third-party tool such as you describe. However, I did download the Sobolsoft Excel file reducer setup.exe and ran it. If you just keep clicking No to the "do you want to register etc." you can get the file reducer to work. It dropped the sizes on a couple of workbooks I had set up with artificially large used ranges. Sobolsoft deleted all the unused rows and columns on sheets, which Debra's code does. Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 09:10:02 -0700, Rima wrote: Thanks Gord, I am able to do it, yet I was wondering if there is an actual tool that does that. When I searched on Google, I found that Sobolsoft has a tool. Yet due to the fact that all of the trial versions need you to actually sign up and pay to use it, I am reluctant to buy it without trying it. I want a tool that our users are able to use so they can fix this process themselves. Rima "Gord Dibben" wrote: Rima Debra Dalgleish has VBA code to reset the used range on each worksheet in a workbook. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 07:23:02 -0700, Rima wrote: When making excel workbooks, I found that excel puts in a lot of extra programming, therefore making the size of a workbook go up to 25MB. Which causes difficulty when e-mailing the workbook. A solution found is by deleting all extra empty cells, yet this is impractical. Is there a way to clean it up without having to manually erase all of the extra cells. Thanks Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
Excel file size too big | Excel Discussion (Misc queries) | |||
excel chart file size | Charts and Charting in Excel | |||
We have an excel file that is 52 megs in size and do not know why. | Excel Discussion (Misc queries) |