Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sized in inexplicable way
Sergio,
You should delete empty columns and rows by right-clicking on the column and row headings and selecting delete from the popup menu. Also, you will probably have to save the workbook before any file size reduction takes place. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sergio Luis Martins" wrote in message... Hi All, I was working in workbook with some formats and some VBA codes that had about 90 Kb and, without I do nothing extraordinary, it got 1,6 Mb. Trying to discover what made happen the problem, I deleted all things but the size is already in 1,4Mb. I deleted: - All objects and comments - All entire rows and columns (All formats and contents) - All VBA code - All others sheets but 1 Is there something that I forgot to delete? TIA Sergio |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sized in inexplicable way
Hi Jim Cone,
Thanks for your reply but, before disturb you here, I already had done this many times, opening and saving the file in the Excel 2K, XP and, 2003 without success. Regards, Sergio "Jim Cone" wrote in message ... Sergio, You should delete empty columns and rows by right-clicking on the column and row headings and selecting delete from the popup menu. Also, you will probably have to save the workbook before any file size reduction takes place. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sergio Luis Martins" wrote in message... Hi All, I was working in workbook with some formats and some VBA codes that had about 90 Kb and, without I do nothing extraordinary, it got 1,6 Mb. Trying to discover what made happen the problem, I deleted all things but the size is already in 1,4Mb. I deleted: - All objects and comments - All entire rows and columns (All formats and contents) - All VBA code - All others sheets but 1 Is there something that I forgot to delete? TIA Sergio |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sized in inexplicable way
Sergio,
Your message said... "I deleted: ....All entire rows and columns (All formats and contents)" However, you must replace the empty rows and columns with new ones, not just clear them. Maybe this will explain it better... http://www.contextures.on.ca/xlfaqApp.html#Unused Regards, Jim Cone San Francisco, USA "Sergio Luis Martins" wrote in message Hi Jim Cone, Thanks for your reply but, before disturb you here, I already had done this many times, opening and saving the file in the Excel 2K, XP and, 2003 without success. Regards, Sergio "Jim Cone" wrote in message ... Sergio, You should delete empty columns and rows by right-clicking on the column and row headings and selecting delete from the popup menu. Also, you will probably have to save the workbook before any file size reduction takes place. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sergio Luis Martins" wrote in message... Hi All, I was working in workbook with some formats and some VBA codes that had about 90 Kb and, without I do nothing extraordinary, it got 1,6 Mb. Trying to discover what made happen the problem, I deleted all things but the size is already in 1,4Mb. I deleted: - All objects and comments - All entire rows and columns (All formats and contents) - All VBA code - All others sheets but 1 Is there something that I forgot to delete? TIA Sergio |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sized in inexplicable way
Hi Jim,
I'm sorry if my message isn't so understandable. Yes. I deleted all entire rows and columns, therefore all formats and contents were deleted too because all deleted rows and columns were substituted for new ones. As I said, the workbook is totally clean. Regards, Sergio "Jim Cone" wrote in message ... Sergio, Your message said... "I deleted: ...All entire rows and columns (All formats and contents)" However, you must replace the empty rows and columns with new ones, not just clear them. Maybe this will explain it better... http://www.contextures.on.ca/xlfaqApp.html#Unused Regards, Jim Cone San Francisco, USA "Sergio Luis Martins" wrote in message Hi Jim Cone, Thanks for your reply but, before disturb you here, I already had done this many times, opening and saving the file in the Excel 2K, XP and, 2003 without success. Regards, Sergio "Jim Cone" wrote in message ... Sergio, You should delete empty columns and rows by right-clicking on the column and row headings and selecting delete from the popup menu. Also, you will probably have to save the workbook before any file size reduction takes place. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sergio Luis Martins" wrote in message... Hi All, I was working in workbook with some formats and some VBA codes that had about 90 Kb and, without I do nothing extraordinary, it got 1,6 Mb. Trying to discover what made happen the problem, I deleted all things but the size is already in 1,4Mb. I deleted: - All objects and comments - All entire rows and columns (All formats and contents) - All VBA code - All others sheets but 1 Is there something that I forgot to delete? TIA Sergio |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sized in inexplicable way
Hi Sergio,
Very occasionally it's impossible to clear the "empty" used range with all the tricks in the book (at least all that I'm aware of!). Can occur if entire rows have been formatted and hidden columns, and after some other things. You could copy each sheet to new books (sheet tab menu) and look at file size of each. Rebuild and replace the offending sheet. Regards, Peter T "Sergio Luis Martins" wrote in message ... Hi Jim, I'm sorry if my message isn't so understandable. Yes. I deleted all entire rows and columns, therefore all formats and contents were deleted too because all deleted rows and columns were substituted for new ones. As I said, the workbook is totally clean. Regards, Sergio "Jim Cone" wrote in message ... Sergio, Your message said... "I deleted: ...All entire rows and columns (All formats and contents)" However, you must replace the empty rows and columns with new ones, not just clear them. Maybe this will explain it better... http://www.contextures.on.ca/xlfaqApp.html#Unused Regards, Jim Cone San Francisco, USA "Sergio Luis Martins" wrote in message Hi Jim Cone, Thanks for your reply but, before disturb you here, I already had done this many times, opening and saving the file in the Excel 2K, XP and, 2003 without success. Regards, Sergio "Jim Cone" wrote in message ... Sergio, You should delete empty columns and rows by right-clicking on the column and row headings and selecting delete from the popup menu. Also, you will probably have to save the workbook before any file size reduction takes place. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sergio Luis Martins" wrote in message... Hi All, I was working in workbook with some formats and some VBA codes that had about 90 Kb and, without I do nothing extraordinary, it got 1,6 Mb. Trying to discover what made happen the problem, I deleted all things but the size is already in 1,4Mb. I deleted: - All objects and comments - All entire rows and columns (All formats and contents) - All VBA code - All others sheets but 1 Is there something that I forgot to delete? TIA Sergio |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
File sized in inexplicable way
Thanks to Jim, Shailesh, and KrunoG to try to resolve the problem, but
unfortunately Peter T is right. Regards, Sergio "Peter T" <peter_t@discussions wrote in message ... Hi Sergio, Very occasionally it's impossible to clear the "empty" used range with all the tricks in the book (at least all that I'm aware of!). Can occur if entire rows have been formatted and hidden columns, and after some other things. You could copy each sheet to new books (sheet tab menu) and look at file size of each. Rebuild and replace the offending sheet. Regards, Peter T "Sergio Luis Martins" wrote in message ... Hi Jim, I'm sorry if my message isn't so understandable. Yes. I deleted all entire rows and columns, therefore all formats and contents were deleted too because all deleted rows and columns were substituted for new ones. As I said, the workbook is totally clean. Regards, Sergio "Jim Cone" wrote in message ... Sergio, Your message said... "I deleted: ...All entire rows and columns (All formats and contents)" However, you must replace the empty rows and columns with new ones, not just clear them. Maybe this will explain it better... http://www.contextures.on.ca/xlfaqApp.html#Unused Regards, Jim Cone San Francisco, USA "Sergio Luis Martins" wrote in message Hi Jim Cone, Thanks for your reply but, before disturb you here, I already had done this many times, opening and saving the file in the Excel 2K, XP and, 2003 without success. Regards, Sergio "Jim Cone" wrote in message ... Sergio, You should delete empty columns and rows by right-clicking on the column and row headings and selecting delete from the popup menu. Also, you will probably have to save the workbook before any file size reduction takes place. Regards, Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Sergio Luis Martins" wrote in message... Hi All, I was working in workbook with some formats and some VBA codes that had about 90 Kb and, without I do nothing extraordinary, it got 1,6 Mb. Trying to discover what made happen the problem, I deleted all things but the size is already in 1,4Mb. I deleted: - All objects and comments - All entire rows and columns (All formats and contents) - All VBA code - All others sheets but 1 Is there something that I forgot to delete? TIA Sergio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INEXPLICABLE FORMULA RESULT | Excel Discussion (Misc queries) | |||
Inexplicable VBA errors in formulas | Excel Discussion (Misc queries) | |||
Extracting variable sized strings from binary file | Excel Programming | |||
Inexplicable crash in VBA | Excel Programming | |||
Printing a legal sized document on letter sized paper | Excel Programming |