ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What is going on during a workbook opening? (https://www.excelbanter.com/excel-programming/400472-what-going-during-workbook-opening.html)

clara

What is going on during a workbook opening?
 
Hi all,

Could you tell what is going on during a workbook opening? Sometimes it
opens fast, sometimes it opens slowly.


Clara

thank you so much for your help

JLGWhiz

What is going on during a workbook opening?
 
The little guy inside is running around checking all the memory chips for
places to put the workbook data and also looking for any instructions to be
carried out like a workbook open event code or some calculations that trigger
with a date change. Then he races over to the library to see if all the
necessary reference books are available and hooks up any links that are
needed to make the workbook do what it is supposed to do. These are a few of
the things that happen. There are more I am sure but they usually happen
pretty fast. The speed of the opening depends on the content of the workbook
and what the user has designed into the workbook that the opening event
algorithm will trigger.

"clara" wrote:

Hi all,

Could you tell what is going on during a workbook opening? Sometimes it
opens fast, sometimes it opens slowly.


Clara

thank you so much for your help



All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com