Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Error Copying File or Excel : Excel Add-in (.xla) file

Posted on 2010-09-24
9
333 Views
Last Modified: 2012-05-10
Hello Experts,
I have this weird problem of not been able to copy an excel add-in file to our network shared folder.

All our developed excel add-in files are on the shared network folder from where each user machine is referring. On each user machine we add the add-in by selecting the file from the network and saying NO to the prompt that asks to create a copy of the add-in to the local drive on the user's machine.

Till now if we have to update the add-ins, we just overwrite the file on the network and just ask users to close and start excel. When excel restarts it picks up the update add-in from the network.

Recently I am not able to copy the add-in file to the user if the user is accessing the add-in (meaning excel is open with that respective add-in). It gives the file in use error.

Has anyone come across such behavior? I am not able to understand whether it is a an excel add-in compilation issue OR excel add-in issue OR change in network drive security features OR issue with my machine that compiles the add-in.

Thank you very much for your time.

Regards,
$wapnil
0
Comment
Question by:spattewar
  • 4
  • 4
9 Comments
 
LVL 3

Expert Comment

by:timbraun
ID: 33760875
Always when I have my excel open I cannot replace the addin that is in use by excel. When I need to replace the addin with a newer version I always have to close excel to allow the file to be replaced.

When you select no when it asks if you want to copy to local location then it is being accessed at the network location. If you have had excel open before and you could replace the file then you have probably copied the addin to the local pc.

Hope this helps.
Regards, Tim
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 33768800
Did you make the add-in read-only on the network share?
0
 
LVL 22

Author Comment

by:spattewar
ID: 33769778
Hi Rory,

No that add-in is not read only.

When the user close the excel then I am able to copy the file. I definitely remember that I was able to overwrite the add-in file on the network even though the users were using the add-in. That is the reason we went with this solution. But now it seems that some setting has changed which is not allowing me to copy the update add-in.

Tim,
The add-in is never copied to the local pc. I know this because earlier I use to copy the new version of the add-in and the users used to get the new version just by restarting excel. if it had been a local copy then they would have never got the new version.

Thank you for your time on my issue...

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 33770053
You should make the add-in read-only. Then the users can't lock it.
0
 
LVL 22

Author Comment

by:spattewar
ID: 33770147
oh. I understand. But then will it allow me to overwrite the file with the new version of the add-in. Thanks.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 33771468
When you want to overwrite, you remove the read only attribute, save the new version, then reset the read only attribute.
0
 
LVL 22

Author Comment

by:spattewar
ID: 33771544
I will give it a try and will let you know.

Thanks for all the help!
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 33771875
IIRC, Ken Puls has an article and some code for this at excelguru.ca
0
 
LVL 22

Author Comment

by:spattewar
ID: 33772206
It helped!!

Thanks Rory!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question