It is applications who create temporary files, not Windows.
And what's the connection between Passwords and Excel? Storing passwords in Excel means you need Excel to retrieve them. Plain text file with added personal encryption (like shifting letters, subtracting numbers etc) would be much better approach. Using USB key with built-in encryption would be the best (I don't know about your Apricorn).