Posted 22 February 2009 - 02:26 PM
We're using a WINDOWS NT server and Excel files that are linked only by firing macros to pull in data from one file to another. All Excel files are located in one shared network folder. With permissions set on the folder to prevent accidental deleting of the files, there seems to be a problem with the temp file creation. The temp file 'boots out' the original file (error message says cannot save the original file). Coding in the Excel file prevents Save As anyway to keep the macro formulas correct. Is this a glitch in WINDOWS NT or in Excel? I can set the permissions to allow all users to have 'write' privileges, and this seems to solve the problem of the ghost temp files taking over. But then I run the risk that a user will delete a file. Is this really an "all or nothing" choice or is there something else I can do?