Excel DECREASING SIZE OF EXCEL FILE from Mr Excel


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

DECREASING SIZE OF EXCEL FILE
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

OWAIZ
Board Regular


Joined: 21 Jun 2002
Posts: 78


Status: Offline

 Reply with quote  

DECREASING SIZE OF EXCEL FILE

I HAVE AN EXCEL FILE WITH LOTS OF FORMULA'S AND CONDITIONAL FORMATTIG, THE SIZE IS TOUCHING 40 MB, CAN SOMEBODY GUIDE ME TO DECREASE THE SIZE OF THIS FILE, SO THAT THIS CAN BE ACCESSSED FASTER.

THANKS & REGARDS
OWAIZ

Post Thu Dec 11, 2003 8:33 pm 
 View user's profile Send private message Send e-mail

pennysaver
Board Master


Joined: 15 May 2003
Posts: 2270
Location: San Diego, California
Flag: Usa

Status: Offline

 Reply with quote  

Re: DECREASING SIZE OF EXCEL FILE

For starters, delete all unused ranges.

(And then type in sentence case - it's much easier to read icon_wink.gif )

Smitty

Post Thu Dec 11, 2003 8:40 pm 
 View user's profile Send private message Visit poster's website MSN Messenger

Mat
Board Master


Joined: 17 Sep 2003
Posts: 457
Location: Montréal, Québec
Flag: Canada

Status: Offline

 Reply with quote  

Re: DECREASING SIZE OF EXCEL FILE

Can I suggest you taking a look at this topic :

http://www.mrexcel.com/board2/viewtopic.php?t=49751

Have a special look at:

Point 3 in first part
Point 12, 13, 14 of second part
_________________


Mat


"I will not compromise my ideals, music or nap schedule" - Trent Lane

Post Thu Dec 11, 2003 8:40 pm 
 View user's profile Send private message

gaynard_nelson
Board Master


Joined: 05 Dec 2002
Posts: 139
Location: Tempe, Arizona
Flag: Usa

Status: Offline

 Reply with quote  

Re: DECREASING SIZE OF EXCEL FILE

quote:
Originally posted by OWAIZ:
I HAVE AN EXCEL FILE WITH LOTS OF FORMULA'S AND CONDITIONAL FORMATTIG, THE SIZE IS TOUCHING 40 MB, CAN SOMEBODY GUIDE ME TO DECREASE THE SIZE OF THIS FILE, SO THAT THIS CAN BE ACCESSSED FASTER.

THANKS & REGARDS
OWAIZ


A common mistake that drastically increases the size of a file is formatting entire rows or columns. Try this to find out. Press Ctrl+Home to go to the top left of the active sheet (usually A1) unless you have clicked on Freeze Panes. Then press Ctrl+End, this will take you to the lower right hand corner of the active sheet. You should have data entered in rows and columns showing. If the cursor goes to never-never land. You need to select the area from where your active data ends and do a Edit Clear All. save the file (Excel does not release this area from memory until it is saved). If this does not release the area you may have to delete Rows and/or Cols and save to free up this memory.

I have spreadsheets with 106 sheets which do not excedd 3 MB's in size.
_________________
Started building macros in Lotus 123, moved to Quattro Pro and now program in Excel VBA.

Gaynard Nelson

The race is not always to the swift
But to those who keep on running

Post Thu Dec 11, 2003 8:48 pm 
 View user's profile Send private message Send e-mail

santeria
Board Master
Board  Master


Joined: 07 Oct 2003
Posts: 1498
Location: Tallahassee
Flag: Usa

Status: Offline

 Reply with quote  

Re: DECREASING SIZE OF EXCEL FILE

Excellent pointer
Worth noting, very much

Ta

icon_bow.gif
_________________
"Don't Ruin an Apology with an Excuse"...

Post Thu Dec 11, 2003 8:54 pm 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.