Data Validation Crashing Excel

[kshelmidine]

I have a workbook that contains a data validation list. I have a table and graph linked to data that changes based on what is chosen from the list via lookup formulas. Randomly, but VERY often, when I pick a new value from the list, Excel crashes. I get a message that says "Microsoft has stopped working".

Does anybody have any experience with this? Any thoughts on what could be causing it?

 

[starl]

The network part of the article isn't Sharepoint exclusive - I was just asking.

From previous link:
[h=5]Where the file is stored[/h]Moving the file locally will help determine whether there is something wrong with the file or with where the file is saved. Several issues can arise when you save an Excel file over a network or to a web server. It is a good idea to save the file locally. This should be done in the following scenarios:

• Redirected "My Documents" folder to server location

• Offline files

• Opening files from Webfolder or SharePoint

• Remote Desktop/Citrix

• Network appliances

• Virtualized environment. For more information about Microsoft software that is running in a virtualized environment, click the following article number to view the article in the Microsoft Knowledge Base: 897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software