Huge Number of Formulas

  • Thread starter Thread starter ZipCurs
  • Start date Start date
Z

ZipCurs

I am working in Excel 2007, although I don't think the problem is specific to
this. I have a workbook with about a 100 worksheets and 10's of thousands of
formulas. Basically, most but not all of the formulas are not calculating on
their own. I believe I have fixed this in the short term by using the
following sledgehammer when I am done with each worksheet.

Cells.Select
Cells.Replace What:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

This really slows things down. Is there a more elegant way to do this
either with macros, computer settings, Excel settings, or something else?
Eventually I will work to reduce the number of equations, but can't do this
in the near term. Thanks in advance.
 
What does this "sledgehammer" do? I don't understand what you're doing.
 
Hello Mike,

I got the method from the Excel General Methods Discussion page.
Apparently, by doing the equivelent of rewriting the equation, it will
actually calculate. It is kind of stupid, but it works. Otherwise, about
1/3 of the equations don't calculate.

I hope that there is a better way.
 
You must log in or register to reply here.

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

Printing Macro 4
Using Find and Replace to replace " in a macro 1
Skip or Ignore Missing Worksheets 1
Help with a loop please. 10
find and replace multiple values in one statement 3
Slow Macro 7
Macro for deleting non-printable characters from EXCEL 2
How to add "'" into string? 8

Back
Top