LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Stupid Question. Reduce Data Base Size Cant Remember How

My data field is a fixed size of 23000 or so numbers long. My sheet keeps
the size at around 65000 long. Every time I past a formula in a column it
sends it all the way to the bottom. How do I make my data base size just a
little larger than my data field?

This is never a problem for me but now I'm using a formula that compares two
sheets and pulls information from the other one. If I reduce the file size
it will speed up this process.

I know this is simple but I just can't remember how to do it. . .Any help
would be appreciated, Ive been looking for this everywhere in the help
section and cant seem to find it.

Regards,

Ernie

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to set sheet size to reduce file size LJ Excel Discussion (Misc queries) 1 November 26th 06 02:35 AM
How to Reduce the Excel File Size? & Make it work with huge data Satish Excel Discussion (Misc queries) 4 November 24th 06 03:06 PM
reduce file size Cruz Excel Discussion (Misc queries) 2 October 6th 06 11:14 PM
Not as stupid a question; this time about data from multiple sheet Ben Karlin Excel Worksheet Functions 1 May 27th 06 12:45 AM
Reduce size file tempêtje Excel Discussion (Misc queries) 2 March 29th 05 12:19 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"