Workbook level recalculation
 

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.


--
Lavneet Singh
------------------------------------------------------------------------
Lavneet Singh's Profile: http://www.excelforum.com/member.php...o&userid=28942
View this thread: http://www.excelforum.com/showthread...hreadid=486765

Workbook level recalculation
 

Not sure about workbook level, but you could use
Worksheets("Sheet1").Calculate and repeat for all sheets in the book.

--
Ian
--
"Lavneet Singh"
wrote in message
news:Lavneet.Singh.1yu7qp_1132560627.9239@excelfor um-nospam.com...

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.


--
Lavneet Singh
------------------------------------------------------------------------
Lavneet Singh's Profile:
http://www.excelforum.com/member.php...o&userid=28942
View this thread: http://www.excelforum.com/showthread...hreadid=486765

Workbook level recalculation
 

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.


--
Lavneet Singh
------------------------------------------------------------------------
Lavneet Singh's Profile: http://www.excelforum.com/member.php...o&userid=28942
View this thread: http://www.excelforum.com/showthread...hreadid=486765

Workbook level recalculation
 

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

--
Ian
--
"Lavneet Singh"
wrote in message
news:Lavneet.Singh.1yul5y_1132578002.4461@excelfor um-nospam.com...

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.


--
Lavneet Singh
------------------------------------------------------------------------
Lavneet Singh's Profile:
http://www.excelforum.com/member.php...o&userid=28942
View this thread: http://www.excelforum.com/showthread...hreadid=486765