Sudden slow in access

[edhan]

There's no fun if you don't step in it! LOL

Opps. Did I take a wrong step?

[BigD]

Hello edhan

Since it is the network-stored file that is giving the problem, is there any possibility of a file sharing conflict?

Which version of Excel are you using? And which Excel file format is that of any file in question?

Does the file contain any macros?

Does the file contain any external links?

[edhan]

@BigD: Nope. Individual user opening their own folders in network. They are using Excel 2007. Yes, there are macros. No external links.

The strange thing is it happened one month ago as it was fine all along that puzzled me.

[BigD]

Hello edhan

Have you debugged and compiled the macros in the month since things started slowing down?

[weegillis]

Opps. Did I take a wrong step?

No. I did. Walked right in it...

[deepsand]

When the problem occurs, does it happen 100% of the time on all Excel files?

If not, what characteristics differentiate the problem class from the non-problem?

[edhan]

@BigD: No, the macros are not compiled. I will check on this and see how it goes.

[edhan]

@deepsand: Those are the most current project files that are being used and are having issues. Have not tested on others since they are no longer in the project. Will test this out as well.

[deepsand]

You might take a look for real time security scans being run on data transfers.

[edhan]

You might take a look for real time security scans being run on data transfers.

Any recommendation for the security scan?