| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.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.excelforum.com/member.php...o&userid=28942 View this thread: http://www.excelforum.com/showthread...hreadid=486765 |
|
#2
Posted to microsoft.public.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 -- "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 |
|
#3
Posted to microsoft.public.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...o&userid=28942 View this thread: http://www.excelforum.com/showthread...hreadid=486765 |
|
#4
Posted to microsoft.public.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 -- "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Global or Workbook level variables. | Excel Programming | |||
| Full recalculation when opening a workbook | Excel Programming | |||
| Workbook-level public variables | Excel Programming | |||
| Decalring Workbook level arrays. | Excel Programming | |||
| Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming | |||
Linear Mode
