reduction of excel file size
Hi
I have a excel file which contain many formula but the problem is it is consuming more time to open and even the excel file is too heavy . how can i reduce the file size?
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 488 guests online.
New Excel Experts
Current Excel / VBA Jobs |
reduction of excel file sizeHi |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
take a look
take a look here:
http://excelexperts.com/Excel-Tips-Why-Is-My-Excel-File-So-Big
Workbook Filesize too big, worksheet too big.
If you Hit Ctrl & End and the cell selected is way past you actual worksheet, then you probably have formats in unused cells.
Just for an example exercise:
Open a new Workbook.
Make a small Excel Table 3 rows down and 3 columns accross. Select A1 and hit Ctrl & End keys. This will select C3.
Select E5 and click the Align text left icon, but do not enter anything into that cell.
Select A1 and then hit Ctrl & End Keys. E5 is now selected, even though it is empty.
Do the same for F100, you will see that F100 is now the end of the sheet.
Another indication of a sheet being to large is the size of the scroll bars. If they are smaller than you think they should be.
Select the very last Cell on the sheet and set the format but leave it empty.
Select A1, you see you only have a 3 x 3 table but look how small your scroll bars are.
Save the workbook as Test or anything you want.
Make it small again.
Select Column D by clicking on the D Use the keys Shift & End & Right Arrow key to select all the way to the last column. Select the Clear Icon, in xl'07 it is located on the Home Ribbon. Select "Clear All"
Note: The delete key will not work for this excercise, the delete key only clears the contents
Select Row 4 by clicking on the 4, Use the keys Shift & End & Down Arrow key to select all the way to the last row. Clear the rows the same way as you cleared the columns.
You will see that the scroll bars are still small. Hit the save button and they should instantly become the proper size again.
Select A1 and hit Ctrl & End, C3 should be selected.
So in a nutsheel.
"Clear All" the Empty Columns
"Clear All" the empty Rows
Resave sheet.
Dave
davesexcel.com/