Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
G72 G72 is offline
external usenet poster
 
Posts: 1
Default CalculateFull in Excel 2002 (XP)

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 968
Default CalculateFull in Excel 2002 (XP)

Where is the application.calculatefull statement located?


Charles Williams
www.DecisionModels.com

"G72" wrote in message
...
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



Reply
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
Excel 2002 : Unable to open files in MS Outlook 2002 Mr. Low Excel Discussion (Misc queries) 1 June 29th 07 02:12 PM
Is it necessary to use CalculateFull command when in automatic mod Carl Excel Discussion (Misc queries) 2 November 18th 06 06:22 PM
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl scampbell Excel Worksheet Functions 0 February 22nd 06 06:31 PM
Can you print labels using Excel 2002 in a Word 2002 mail merge? Individual_ Excel Discussion (Misc queries) 3 December 17th 04 08:39 PM
Application.Calculatefull function Charlie Woll Excel Programming 3 July 20th 03 07:46 PM


All times are GMT +1. The time now is 03:02 AM.

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"