If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unusual File Size Increace
I have a problem with an Excel file which is 1.5MB in size
even though there is only one sheet with 20 lines of data. Have tried cutting and pasting data into a new file, deleting all blank data, as well as all rows oustside data area, none of which made any difference to file size. In fact deleting all data in the spreedsheet still does not rduce the size, so I now have a spreedsheet without any data visable and the size is still 1.5MB. I am using Ver 2002. |
#2
|
|||
|
|||
Unusual File Size Increace
Selecting a row or column and applying cell formatting all the way to the
last row is the usual cause of bloated spreadsheets. If you suspect this is problem-- 1. Beginning at the row after the last row of data, click on the row number and drag down to the last row. It'll take a minute to get there. 2. Right click in the selected area and choose Delete This will remove all cell formatting and hopefully reduce the size of your spreadsheet. -- Mark Henri Excel Support Technician www.canhelpyou.com ---------------------------------------------------------------------- Every member of the CanHelpYou team holds at least a Microsoft Level 1 Excel certification. In addition, we have experts in PowerPoint, Word and other products such as IIS, SQL Server 2000, network connectivity. We're here to help whenever you need us. |
#3
|
|||
|
|||
Unusual File Size Increace
Mark
SHIFT + END + DownArrow takes a blink. Why scroll when you can use shirtcut keys? Gord Dibben Excel MVP On Wed, 28 Jan 2004 08:22:21 -0800, "Mark Henri" wrote: Selecting a row or column and applying cell formatting all the way to the last row is the usual cause of bloated spreadsheets. If you suspect this is problem-- 1. Beginning at the row after the last row of data, click on the row number and drag down to the last row. It'll take a minute to get there. 2. Right click in the selected area and choose Delete This will remove all cell formatting and hopefully reduce the size of your spreadsheet. |
#4
|
|||
|
|||
Unusual File Size Increace
Pehaps if you use the fill handle to copy individual cell formats down
but if your format the entire column it should be fine, a single format. In fact your solution of formatting partially down a column is doing individual formatting instead of for a group. In fact if you color the entire column at one time, there will be NO change in file size but if you color the top cell and use the pattern tool and move the curser down increasing the number of cells being formatting as you go down you will greatly increase the filesize. This has always been true. Format what you need all at the same time. Possible this would have to be verified in Excel XP, because Excel XP does consider a format change to be a calculation event, but I would be surprised if Excel XP were different.. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mark Henri" wrote in message ... Selecting a row or column and applying cell formatting all the way to the last row is the usual cause of bloated spreadsheets. If you suspect this is problem-- 1. Beginning at the row after the last row of data, click on the row number and drag down to the last row. It'll take a minute to get there. 2. Right click in the selected area and choose Delete This will remove all cell formatting and hopefully reduce the size of your spreadsheet. -- Mark Henri Excel Support Technician www.canhelpyou.com ---------------------------------------------------------------------- Every member of the CanHelpYou team holds at least a Microsoft Level 1 Excel certification. In addition, we have experts in PowerPoint, Word and other products such as IIS, SQL Server 2000, network connectivity. We're here to help whenever you need us. |
#5
|
|||
|
|||
Unusual File Size Increace
SHIFT + END + DownArrow takes a blink.
Why scroll when you can use shirtcut keys? I like to make 'em work for it. Also, beginners often get weirded out with the shortcut keystrokes. |
#6
|
|||
|
|||
Unusual File Size Increace
I've had luck in the past with the delete attempt reducing the size of the
book. However, let's go at it from a different approach-- 1. Create a new blank workbook 2. Copy and Paste only those cells which have information into into the new book. Sometimes, this was the only way to lose spreadsheet corruption occurring in the lower cells. But it doesn't always work if the problem is in the cells that they copy. Mark |
Thread Tools | |
Display Modes | |
|
|