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.