Temporary Excel files.

Y

y

Hi,
does anyone know where Excel stores its temp files to managing
multiple opened copies of the same workbook?
Word stores its lock files in same directory of the opened document, but
Excel?

Thanks in advance for the answers.

Alex
 
D

Dave Peterson

On a single user (non-networked pc), excel will put a few files in your windows
temp folder.

But I think it does more than just that. (Just guessing!) When the workbook is
on a network, excel/windows is smart enough to be able to tell that second
person the the file is in use.

If the only indicator were on the first user's temp file, then the second person
would never see those files.

I know that sometimes when excel locks a workbook that's stored on a network
drive (and subsequently crashes), then sometimes the only way to free that file
is to reboot the server.

But I'm not smart enough to know how excel/windows does it. I've looked for
extra files, but never found any. I'm not sure how files are locked by the
operating system in general.

I guess my real response is what do you want to do with those files anyway? The
only thing I've ever done is to delete them (with excel closed) if excel crashed
and the file stayed locked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top