Temporary Excel files.

  • Thread starter Thread starter y
  • Start date Start date
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
 
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.
 
Back
Top