Back to Community Threads
1
"The Specified file is in Use"
Problem reported by Ronnie Edward Roberts - 1/18/2016 at 4:57 PM
Resolved
I keep getting the following pop up when attempting to do an import "The specified file is in use. Please close the file before proceeding" and I know the file is not open.

15 Replies

Reply to Thread
0
Steve Replied
1/19/2016 at 3:50 AM
Employee Post
Can you please save the file in the XLS (97-2003 Excel Workbook) format and retry the import.
Steve Batten
0
Libby Biittner Replied
2/2/2016 at 6:39 PM
Hello, I am haing the same problem as Ronnie. The file I am attempting to upload is an .xls file, and I did not have any version of excel running on my computer when I attempted to upload. Any tips?
0
Steve Replied
2/3/2016 at 3:01 AM
Employee Post
You must save the file within Excel to change it to XLS. We are fast tracking this fix now.
Steve Batten
0
Libby Biittner Replied
2/3/2016 at 9:32 PM
Thanks. For my uploads, I always do "save as" and save the workbook as 97-2003 xls format. The same error continues to pop up when I try to upload the file in that format.

I browsed to several old xls files that I successfully uploaded a couple of months ago, and I get the same error message with all these files.
0
Steve Replied
2/3/2016 at 11:51 PM
Employee Post
Sorry can you try Tab delimited and see if that works.
Steve Batten
0
Libby Biittner Replied
2/4/2016 at 6:09 PM
Saving the file in tab delimited format allowed me to complete the upload, thanks!
0
Jay B Mercer Replied
3/7/2016 at 11:17 AM
Yep I am getting the same pop up "The specified file is in use" while trying to import to QuickBooks Online. (File is not open) Also trying to switch companies. Have disconnected and re-connected but file previous file still remains. Downloaded Excel invoice templete so it is 97-2003 .xls type. Any ideas anyone?
Jay B. Mercer
0
Steve Replied
4/8/2016 at 4:19 AM
Employee Post
Can you raise a ticket with Support and attach the XLS file and we will have a look to see if this is caused by another issu
Steve Batten
2
Liz Reinkens Replied
10/18/2017 at 7:23 PM
I get that message before even choosing a file... I get it as soon as I connect to QuickBooks.
0
Steve Replied
10/24/2017 at 11:27 PM
Employee Post
Ok can you please follow the steps on this page http://support.zed-systems.com/Main/
Steve Batten
0
Josh Anda Replied
10/29/2017 at 8:28 AM
After I re-saved a file in .xlsx, Axis could open it. When it was in .xls, I always got the "The Specified file is in Use" message.

Also, I commented out Location in the registry by re-naming it "Location_rem" because I also got an error message every time Axis is connected to QuickBooks.
0
Josh Anda Replied
10/29/2017 at 10:04 AM
Even if the file is in .xls, it can be opened by Axis if it's already opened by MS-Excel. That means we must open a specified file by MS-Excel before opening it on Axis.

All these problems started after I updated Windows 7 on my computer. So, installing important update files onto Windows 7 affected Axis, I guess.

Anyways, I have no problem using Axis for the time being. I am just worried I may encounter problems again after I install future Windows updates. I wish Axis were a bit more trouble free.
0
manju george Replied
11/8/2017 at 12:22 PM
Hi , Tried all the above solutions but the same pop message keep coming up. Could you please help out.
0
Steve Replied
3/23/2018 at 3:23 AM
Employee Post Marked As Resolution
IMPORTANT ANNOUNCEMENT: Zed Axis users experiencing error "Specified file in use" or "Error" when importing into QuickBooks.
STATUS: Resolved
Issued: 12/10/2017 10:17 AM Sydney Time Last Updated: 15/10/2017 14:35 PM Sydney Time

Occurs: We are aware of an issue affecting Zed Axis users when opening a file or applying a map. Axis is unable to open the file or the map is not getting applied correctly to the data.

Cause: We believe that a recent automatic Security update around 11th October to Windows has adversely impacted a data connector component that we use, we are also hearing reports that this is affecting many other Windows apps that use the Microsoft Jet Database Driver.

Resolution: Issue has been resolved in an updated version of Zed Axis V12.1 released on 15/10/2017 14:35 AEST, all V12 license holders and Plus subscribers with upgrade protection can download the latest trial version, first uninstall your current version of Axis and then install the latest download and activate using your serial number, your maps and settings will be retained.

If you are using a pre V12 licence you can continue using Zed Axis but you will need implement the fix for this which involves uninstalling the last Windows Security Update (KB4041676, KB4041681, KB4041678, KB4041690, KB4043763) and skipping these updates, Microsoft may address this issue in a future update or hotfix. Alternatively you can upgrade to V12
Steve Batten
0
Brie Replied
5/4/2022 at 7:49 PM
This issue is happening on V15 Zed. Please advise how to fix? 
Back to Community Threads

Reply to Thread

Tags

Zed Axis