I would say that I haven't got a clue what this automagic is as when I read that it had Macros the I just ignored it.
No-one should ever download a file that contains macros unless you wrote it yourself or know the author very well.
This is a rule recommended by many people, and one that I always stick to, in fact I won't take a zipped excel file from a friend any more as it's more difficult to scan.This is after a nasty experience I once had.
Nick.