I have about 10 users on a terminal server running Excel. Office is not installed on the server, just Excel. There is a custom spreadsheet that access various databases that they need to use. I'd like to save the spreadsheet as a template, si I can update, secure, and maintain it in one place, and then give them shortcuts to create a new spreadsheet from that template whenever they need to use it so that they are not messing with the original.
I'm open to different methods of doing this. My first attempt was to use the workgroup template folder location, but the only referene I could find to changing that was via Word, which isn't on that machine. I am doing it now with a powershell script that launches Excel and creates a new copy from the template, but I'm having a problem with that where it doesn't clean up the instances of Excel32.exe after close, so there's a memory leak. I also don't like the security issues involved with enabling ps scripts on a terminal server.
Any suggestions?
I'm open to different methods of doing this. My first attempt was to use the workgroup template folder location, but the only referene I could find to changing that was via Word, which isn't on that machine. I am doing it now with a powershell script that launches Excel and creates a new copy from the template, but I'm having a problem with that where it doesn't clean up the instances of Excel32.exe after close, so there's a memory leak. I also don't like the security issues involved with enabling ps scripts on a terminal server.
Any suggestions?
