View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zimme Zimme is offline
external usenet poster
 
Posts: 2
Default Excel freeze when ran from server drive

Hello Everyone:

Good day and best regards.

I work from a shared server drive "eg: Shared on 'Company\Public (G:)". In
this folder there are two files, one Access mdb the other Excel with macros.
The mdb is to store the thousands of records. The Excel file would have to
extract selected records from the mdb for graphing.

When I ran the Excel file copied and stored in my own computer say C: drive,
importing the mdb info, the macros ran as intended. This is the case
regardless if the mdb was in the server or not.

But if the Excel file were in the server G: drive, the Excel freeze (not
running) on me.

How do I be able to run the Excel from the G:?

Thanks for your support.

Zimme