So recently I created an worksheet for our field personnel, in this worksheet there is one vba-function, and three subroutines. I sent the sheet out, and the field guys have been filling the sheet out and sending it back to me.
After working great for a few weeks, now when they send the sheet back, the vba function does not work (#Value not #Name?) - the code is still there, so there should be no reason it's not working. When I call the field guys they say it works fine and they can see all the numbers on their end, but after emailing I see nothing but #Value.
Any ideas as to how to fix this? I have already been through the obvious such as making sure we have the same excel version, checking for the same references etc.
There is no reason it shouldn't work - alas here I am
Thanks for the help
Bookmarks