Limit On Formulas??

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

Joe Gieder

Is there a limit on the number of formulas you can have
on a workseet? I'm using Excel 2000 and can't copy my
formulas into all the cells I need to have. As I copy
down the spreadsheet the formula only fills in so far and
then leaves the rest blank. Any ideas?

TIA
Joe
 
Thanks Norman. I guess I somehow need to shrink and
accelerate my formulas. What a MAJOR PAIN that's gonna be.

Joe
 
Hi Joe!

You might look first at replacing "one off" formulas with their
current values.

Also, if you for example use a total of a long row of formulas and
don't use the individual elements, you might consider cutting and
pasting the data to another workbook.

Then there's upgrading to Excel 2003. See Charles' comments on size
obtained!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top