Macro crashes from time to time when running from another computer

I have developed a Macro in excel 2010 that runs perfectly on my computer.
The issue is: When trying to use it from another computer with Office 2007 sometimes it crashes giving a runtime error 1004.
all what I have to do to fix it is to open it from my computer and save it then it works on the other computer before it crashes after few times.