asingh
09-09-2006, 07:36 AM
Hi,
I have an Excel Spreadsheet, which has two (2) tabs. Each tab has around 3000 Rows * 40 Columns of extensive formulas. [DBASE, Vlookups, Array Functions, CSE Functions, Index Calculations]. When ever a user applies a filter to the columns the sheet obviously re--calculates, and it takes quite a while. At times before the sheet reaches 100% calcuation status, the users click on the sheet or press ESCAPE, and the sheet does not calculate the whole way. And I get a FLOOD [believe me many...!] of mails saying "My values are incorrect, something is wrong with the sheet". I advised them to use F9 --- to force calculations, but they forget or are too impatient.
What I want to do is LOCK UP the sheet for user interaction until the calculations are complete. So ideally a programe flow would be like this:
Calculations Start ----- Sheet LOCKS UP ----- Calculations Reach 100% ---- Sheet OPENS UP for user Interaction.
I am not sure how to TRAP the calculation event, and then lock up the sheet...any ideas..............! [I am tired of receiving complaints...........!]
thanks a lot,
regards,
asingh
I have an Excel Spreadsheet, which has two (2) tabs. Each tab has around 3000 Rows * 40 Columns of extensive formulas. [DBASE, Vlookups, Array Functions, CSE Functions, Index Calculations]. When ever a user applies a filter to the columns the sheet obviously re--calculates, and it takes quite a while. At times before the sheet reaches 100% calcuation status, the users click on the sheet or press ESCAPE, and the sheet does not calculate the whole way. And I get a FLOOD [believe me many...!] of mails saying "My values are incorrect, something is wrong with the sheet". I advised them to use F9 --- to force calculations, but they forget or are too impatient.
What I want to do is LOCK UP the sheet for user interaction until the calculations are complete. So ideally a programe flow would be like this:
Calculations Start ----- Sheet LOCKS UP ----- Calculations Reach 100% ---- Sheet OPENS UP for user Interaction.
I am not sure how to TRAP the calculation event, and then lock up the sheet...any ideas..............! [I am tired of receiving complaints...........!]
thanks a lot,
regards,
asingh