Workbook level recalculation

[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 is hooked to? I tried Application.Calculate(), but it triggers recalculation in all open workbooks.

[Ian]

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

--
Ian
--
"Lavneet Singh" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Lavneet Singh]

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.

[Ian]

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

--
Ian
--
"Lavneet Singh" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>