CalculateFull in Excel 2002 (XP)

G

G72

Hi,


We have a VBA formula that requires all formulas on all
worksheets in a workbook to be recalculated.

We are having a problem with code that works in Excel
2000, but not Excel 2002 (XP).

The line
Application.CalculateFull

returns error 1004: Method 'CalculateFull' of
object '_Application' failed

I have not found anything in the KB or elsewhere that
this is a known bug, but we cannot get anything to work.

Any ideas?

Thanks,
G72
 

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

CalculateFullRebuild vs CalculateFull 3
Run-time error 1004 from workbook attached to Outlook email 0
Error when opening Embedded Excel File in Word 1
Workaround for Excel 2002/2003 UDFs recalculating and changing cel 9
error 1004 6
Sort bug on Excel 2007 6
Communication between two Excel COM add-ins 0
Problem transferring Excel macros to another language 1

Top