Excel 2000 - Temp file when saving - can it be changed

cpugsley

New Member
Joined
Aug 17, 2007
Messages
1
Hi,
Excel when saving a file creates an 8 character random filename which it saves the file into, then after it is complete it renames the temp file name to the actual file name
e.g. myfile.xls --> save file --> temp file called 63ECD800 --> save completes --> myfile.xls deleted --> 63ECD800 renamed to myfile.xls --> save complete.

http://support.microsoft.com/kb/814068 ...explains this

:eek: Question - can this TEMP FILE NAME be forced to be something else?
e.g. 63ECD800.tmp or ~myexcelsheet.tmp


Reason - windows desktop search tries to access the temp file while excel is still using it. This causes excel to leave the filename at the temp name.
If I can add a .tmp to the file name I can tell windows desktop search to ignore it.
(this problem seems to be fairly widespread; but most users can't diagnose the fault. I only noticed it one day when the search kept the file locked..)
Unfortunately trying to get the message to the W.D.S. developers is impossible!!

I googled this and did not really turn up anything.
Thanks
Craig.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,214,920
Messages
6,122,269
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top