ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Running Macros when on the LAN (https://www.excelbanter.com/excel-discussion-misc-queries/49053-running-macros-when-lan.html)

Bettergains

Running Macros when on the LAN
 
Hello:

I've been experiencing a recurring phenom. When my system is connected to
our internal lan, the spreadsheet hangs and sometimes crashes. When I run the
spreadsheet when unconnected from the lan, it runs smoothly. Wkbk A runs
macros that open & manipulate other wkbks; Wkbk B contains forms that run
manipulate the wrkbk's own data. I'm wondering if there is some Option in
Excel to set, some system config to change, or some routine that is left
"open" for example. I notice that when I shut down, one of these wkbks
flickers, even if its been hours since its been open.

Thanks for your expertise, Germaine


All times are GMT +1. The time now is 02:06 PM.

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