Stupid Question. Reduce Data Base Size Cant Remember How

  • Thread starter ernie - willcox
  • Start date
E

ernie - willcox

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, I’ve been looking for this everywhere in the help
section and can’t seem to find it.

Regards,

Ernie
 
S

Shane Devenshire

It's not stupid, what it is is not clear!

Try this for starters, move down to the bottom row of data and select all
the rows from the next row all the way down to 65536, then press Ctrl+-
(control minus). Save the file. This will take care of Excel thinking your
database goes down 65000 rows.

Now as to making it a little large - what are you trying to do so that you
need to tell Excel the database is bigger than it really is?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Reduce size of Macro Enabled Excel File 1
How can the font and size of (all) citation numbers be altered? 1
How to export html text as word document with specific size and orientation 0
Reduce File size 3
How to modify and updte specific styles for specific paragraphs across the document 0
Need some PWA help 0
How do I reduce the file size in excel 2003 3
Finding the right style field in VBA 0

Top