Workbook level recalculation  
Author Message
jsooy





PostPosted: Mon Nov 21 03:05:10 CST 2005 Top

Excel Programming >> 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.hide-link.com/ ;userid=28942
View this thread: http://www.hide-link.com/

Excel358  
 
 
Ian





PostPosted: Mon Nov 21 03:05:10 CST 2005 Top

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

--
Ian
--



>
> 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?action=getinfo&userid=28942
> View this thread: http://www.excelforum.com/showthread.php?threadid=486765
>


 
 
Lavneet





PostPosted: Mon Nov 21 06:59:20 CST 2005 Top

Excel Programming >> 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?action=getinfo&userid=28942
View this thread: http://www.excelforum.com/showthread.php?threadid=486765

 
 
Ian





PostPosted: Mon Nov 21 11:52:25 CST 2005 Top

Excel Programming >> 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
--



>
> 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?action=getinfo&userid=28942
> View this thread: http://www.excelforum.com/showthread.php?threadid=486765
>