dark_moonx1
New Member
- Joined
- May 22, 2011
- Messages
- 1
Hi,
I have a friend who is trying to run a query on an Excel 2007 file. When she's the one updating the raw data itself, her query runs fine. However, when one of here colleagues tries to update the file, the query is unable to resolve the new data. It just ignores the column where the data is located.
So my friend then goes to update it herself then everything goes back fine. The said column is shown in the query table.
The workbook isn't a shared workbook so only one person can update/open it a given time.
Any help is appreciated.
I have a friend who is trying to run a query on an Excel 2007 file. When she's the one updating the raw data itself, her query runs fine. However, when one of here colleagues tries to update the file, the query is unable to resolve the new data. It just ignores the column where the data is located.
So my friend then goes to update it herself then everything goes back fine. The said column is shown in the query table.
The workbook isn't a shared workbook so only one person can update/open it a given time.
Any help is appreciated.
