I have a view on a SQL Server 2000 database that returns a list of companies to be worked on. All of the people in the department have read/write access to the database.
I have an Excel spreadsheet that uses Microsoft Query to pull the data from this view. The spreadsheet is stored in a folder that is read/write for everyone in the department.
The spreadsheet has the following macro:
Private Sub Workbook_Open()
I always get the current list whenever I open the spreadsheet. However, a few people in the department appear to get 'old' data. When they call to complain, I open the spreadsheet and get the current data. If they try again, after I have opened/closed the spreadsheet, they then get the current data. I know that they are opening the correct spreadsheet because I watched them open it, and saw the incorrect results.
I've never seen this situation with Data Query and am at a loss as to why the data is not current for everyone.