Workbook level recalculation

  • Thread starter Thread starter Lavneet Singh
  • Start date Start date
L

Lavneet Singh

An Excel exe can open many workbooks. My application is hooked to one
workbook. How can I trigger recalculation in only the workbook that my
application hooked to? I tried Application.Calculate(), but it triggers
recalculation in all open workbooks.
 
Not sure about workbook level, but you could use
Worksheets("Sheet1").Calculate and repeat for all sheets in the book.
 
Hi Ian,

Thanks for you reply.

The Worksheet.Calculate can be used to trigger recalculation in a sheet
at a time. Using it for all sheets of a workbook should do the job. The
only problem we might face is: what if the sheets are inter-dependent
and, therefore, a sheet gets changed after it has been recalculated (by
using Worksheet.Calculate) due to recalculation in other sheet.

Thanks,
Lavneet.
 
I'm not sure how you could get round this. Maybe you could tie a worksheet
change event into it somehow?
 

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

Need Calculations Done Event 1
Recalculation Done event? 5
Custom Function Problems when multiple workbooks are open 1
Problems with Custom Functions and Muiltiple open workbooks 8
Excel Protection 2
excel 2000 to excel 2007 2
Selective Recalculate 2
Is this expected behavior? 2

Back
Top