Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jim.bahr
 
Posts: n/a
Default Excel data query locks source file


I have set up a series of spreadsheets on our organisation server. They
read data from each other using Data Query and PivotTable. Some of
these run automatically when the file opens, some are updated manually.
The problem is that once the data query runs, this locks the source file
for an indefinite period. When I try to open the file, I get "The source
file is currently in use by USERNAME", although it is not. USERNAME is
always the last person who successfully opened the file; so sometimes
this is even my username! The only way I found to reliably get access
again is to restart our server. This is obviously not a workable
solution. Is there a problem with Excel, or is there something going on
with our network? Can anyone help??


--
jim.bahr
------------------------------------------------------------------------
jim.bahr's Profile: http://www.excelforum.com/member.php...o&userid=24175
View this thread: http://www.excelforum.com/showthread...hreadid=377977

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
File Error: Data May Have Been Lost Tbird2340 Excel Discussion (Misc queries) 8 March 20th 05 06:31 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 11:50 PM
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 12:46 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"