Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Excel Creating Temporary File After Saving

I have one user in the office when they save there excel document it creates
a *.tmp file in the current file folder.

Now I checked - Select Tools|General Option and put a check against the
Always Create Backup box before you save the file. But that is not it.

The file created is something like this. dhti4345$0buget200243~.tmp

IF anyone could help that would be greatly appreciated.

I also looked into editing the registry and increasing the cache size but I
would prefer not to do that.

thanks again


Post your answer or comment

comments powered by Disqus
For some reason, on just a a few of our shared Excel files, when saved by the
client Excel creates a temp file in the directory. It has created somewhere
near 180 of them in the past few days.
Most of the clients are Excel 2003 w/current SP but it doesnt seem to matter
what version they are using.
Any ideas?

hi community

Dear All,

I have started work in Excle 2007. my all file made in Excle 2003.

Now I have save file in Excle 2007 through ^S, every time Excle 2007 created
new *.tmp file. if i save file for 30 time, than 30 *.tmp file in my folder.

please give me suggestion for don't creating *.tmp when i save a file

Thanks & Regards

Bhavin

Hi,
when I save the file, excel creates tmp file in the same dicectory as the
original file is placed. Everytime i click to save this document, it creates
another tmp file.
When I leave Excel application, tmp files are not deleted.
Is it possible to solve this problem?

I have what seems an innocuous bit of VBA code.

Private Sub App_WorkbookBeforeSave(ByVal WB As Workbook, ByVal
SaveAsUI As Boolean, Cancel As Boolean)

.....
Dim wbName As String
wbName = WB.name
Set WB = Nothing
getLog().wDebug "re requesting WB with no modules(" & wbName & ")"
Set WB = Application.Workbooks(wbName)
getLog().wDebug "Saving Changes(" & WB.name & ")"
WB.Save
Cancel = True
getLog().wDebug "ENDING overloaded before save event for (" &
WB.name & ")"
ErrorHandler:

End Sub

This catches the event of saving a worksheet.

But on the '.save' method excel goes into a flat spin and creates a
massive temporary file that continues to grow until excel dies
horribly.
In my log file I see this

DEBUG-26/09/2007 14:33:36-thmedlan-re requesting WB with no
modules(CRexPortfolioBuilder.xls)
DEBUG-26/09/2007 14:33:36-thmedlan-Saving
Changes(CRexPortfolioBuilder.xls)

Which seems to suggest the '.save' method is to blame. I have taken
the stack trace of what excel was doing at the time. Does anyone have
any ideas as to what I am doing wrong? and why workbook.save behaves
so badly?

Thanks
Tom

ntoskrnl.exe+0x584d
ntoskrnl.exe!KeQueryRuntimeThread+0x5e8
hal.dll+0x2ef2
hal.dll!HalRequestSoftwareInterrupt+0x3c
ntoskrnl.exe!Kei386EoiHelper+0x237d
SYMEVENT.SYS!EventObjectCreate+0xa20
SYMEVENT.SYS!SYMEvent_AllocVMData+0x5de9
ntoskrnl.exe!Kei386EoiHelper+0x237d
ntoskrnl.exe!ZwSetSystemInformation+0x23
ntdll.dll!KiFastSystemCallRet
ole32.dll!CoWaitForMultipleHandles+0x15be1
ole32.dll!WriteClassStm+0x2eb3
ole32.dll!WriteClassStm+0x2fd5
ole32.dll!StgCreateDocfile+0x691
ole32.dll!StgOpenStorageOnHandle+0xcfb
ole32.dll!CoFreeAllLibraries+0x185b
ole32.dll!WriteClassStm+0x5096
ole32.dll!WriteClassStm+0x5380
ole32.dll!WriteClassStm+0x3b06
ole32.dll!WriteClassStm+0x39d6
ole32.dll!WriteClassStm+0x365f
ole32.dll!WriteClassStm+0x3852
ole32.dll!WriteClassStm+0x374e
VBE6.DLL!rtcShell+0x25cc8
VBE6.DLL!rtcShell+0x24f3c
VBE6.DLL!rtcShell+0x254cc
VBE6.DLL!rtcShell+0x27ff7
VBE6.DLL!rtcShell+0x27f9b

When a co-worker of mine saves an excel file that I e-mailed her it creates a text file also. Does anyone know why this is happening?

Thanks in advance

I created a simple spreadsheet (30 colums, approx 15 rows) with Excel '07. No macros, lookups, etc - only some conditional formatting and some countif() calculations.

I saved the sheet in .xls format so I could send it to co-workers using Office '03. I later tried to re-open the same file with '07, and it only opened part way then froze and I had to close Excel. It opens fine in '03.

I have had similar problems with other files created with '07, but saved as '03 compatible. The common factor appears to be conditional formatting.

Have searched MSKB and Google - but the only thing I find that comes close is KB937911. I obtained that patch and attempted to install it, but was 'told' by the installer program that it has already been installed.

Oddly enough - I was able to open it with OpenOffice, save-as .xls, and then open it in Excel '07 with all formatting intact.

Would appreciate any suggestions.

MS word has a feature where you can copy remotely stored files onto your
computer, and update the remote file when saving.

Does Excel have such a feature?

We have network shares where people have write access to a file so Excel is
not able to delete the temporary files when it closes.

I am having an issue with Excel creating a duplicate file when logged in as a user with restricted permissions on our network. If I modify a file while logged in as another user, excel will save the file but will also create a duplicate file with an eight character random name and no file extension. For example if user "Dave" opens a file called test.xls and saves it, in that same folder on the server a file named 296E9E20 will be created. Users are using Windows XP SP3 boxes and the server is running Win 2003. I am not sure why this only happens with Excel.

Hi again

I've created a little macro to save the file with a pre-determined filename, however it always closes the file after saving... I've trolled this forum and the internet and can't quite seem to find a code to keep the workbook open after it preforms the file save/as.

I've seen how to close the workbook "ThisWorkbook.Close" but there doesn't seem one to open/keepopen?

Thanks from Ottawa

Hi all,

I run an fairly large Excel 2007 workbook everyday. Over the last few days, I noticed that the calculation in the workbook is acting strangely. Specifically, calculation is very slow when the workbook does not have focus (ie. I have an explorer window open and selected) but only after I save the workbook. If I open it and do not save, I can move my focus to the explorer window or another application and it continues to calculate normally. However, if I save the workbook I notice that the save takes longer than usual to start and when it's done I cannot take focus off of the workbook or calculation will be extremely slow. Saving the workbook always took a while, but I noticed that it now takes several seconds before the progress bar for the save operation shows in the bottom right of the window.

Some information about the setup:
* Rebooting the machine does not help. The workbook calculations are fine upon reopening it but as soon as I save the problem comes back and I must keep focus on the workbook to keep the calculations from getting slow.
* Calculation is set to automatic with no iteration in Excel.
* No Excel settings have been changed (for this or any other workbook)
* Machine is Windows XP with the latest service pack (the latest OS updates are installed manually every 2 weeks and were not installed around the time this started happening)

Does anyone have any idea what might be causing this slow calculation after saving when the workbook does not have focus?

Thanks,
Bob

hai buddies,
i am having a file with macros and i want to copy this file to other file without macros when user press a button in excel.
i am having one cell with value Y or N. if it is Y then the file is saved else if N then not saved.
i am checking this cell while copying this data to other file. if this cell is Y then copy the sheet or else alert user that save and then click this button.. blah .. blah.
there is a prob here....
Say if user entered some data & saved, then this will set to Y.now he can upload. say if user edited the excel again and then click the button to save other copy then this cell is still Y insted of N.
So basically I want to modify the field (Y or N) based on modofications done to file after saving the excel.
how can i do this.
thanks & regards,
Mahesh

The subject says it all really... am using Excel 2003 SP2. On each
save, I get a fresh TMP file which, on my now retired workstation
(same setup) were deleted on close:

Xmas lunch.xls
Xmas lunch.xls~RF1783b6.TMP
Xmas lunch.xls~RF21684e.TMP
Xmas lunch.xls~RF22d4bf.TMP
Xmas lunch.xls~RF397407d.TMP

Have Googled but found no answer.

And the anti-virus software we're using (Norman) is set up on this PC
in the same way as my old workstation, so suspect AV behaviour not the
answer.

Thanks for any pointers.

My code saves my workbook as a pdf file. However, this leaves me with two of the same files, one an xls and the other a pdf.

I would like to delete the xls file after the pdf file has been saved.

Can anyone assist please?

Hi!
Any one know of a way to find out which version of excel was used to create
a file?

Best Regards!

Eirik

I am trying to move a file after import however the code will not run. Is anybody able to tell me what I've done wrong?

Thanks in advance

Hi,

I've a workbook Data Form.xls where users input 6 fields (cells) of data on one sheet, eg B1:G1, B2:G2 etc. As data is entered, each set of 6 fields is concatenated, comma seperated, into one cell in Col A.
Thus 35 cells in Col A are eventually populated A1:A35.

At this point, the workbook needs to be saved and the user clicks Button2. The workbook Data Form.xls is stored on a USB drive, hence use of relativePath to save the file.

Next, the values only in A1:A35 need to be stored in a .csv file that must be located in the same relativePath as the workbook.

Once the .csv file is saved, both the .csv file and Data Form.xls can be closed.

I can't seem to get the right syntax for saving the .csv file correctly, and have tried a dozen or so means of saving and storing the .csv file. In the code below, the code stops at '.SaveAs Filename:="patient_import" etc etc'. Something silly I'm missing for sure. Any pointers would be greatly appreciated.

PHP Code: 
Sub CommandButton2_Click()

    Dim relativePath As String
        relativePath = ThisWorkbook.Path & "" & "Data Form.xls"
        Application.DisplayAlerts = False
        ActiveWorkbook.SaveAs Filename:=relativePath
        Application.DisplayAlerts = False
    
    ActiveSheet.Unprotect Password:="open"
    Range("A1:A35").Select
    Selection.Copy
    
Sub AddNew()
    Set NewBook = Workbooks.Add
        With NewBook
            .Title = "patient_import.csv "
            .SaveAs Filename:="patient_import" & ".csv", _FileFormat:=xlCSV
         Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
        End With
       
        ActiveSheet.Protect Password:="open"
        Application.DisplayAlerts = False
        ActiveWorkbook.Save
        Application.DisplayAlerts = False
        Application.Quit

End Sub 


Can not save files

Security issues caused i must set NTFS permission for users somethings like this:
- Administrators (Full Controll)
- Creator Owner (Full Control)
- XYZ Group (Read, Write & Execute) --> it mean user can create new file or modify old file but can not delete that file

When users used MS office 2003 we didn't got any problem with these NTFS settings, but after i advised upgrade from MS Office 2003 to MS Office 2007 the problem had come.
After few days checked i saw that problem due to NTFS security, because when you open excel or word file, after you edit the contents and try to save file, first thing MS Office 2007 will create new temporary file named something like this (94FBD000). After that MS Office tried to delete the old file (for exam XYZ.xls), if deleting succeeded it will rename temporary file to XYZ.xls which one just deleted. So, if users don't have NTFS permission can delete the file it caused problem for user.
Anyone can answer me how can solve this problem, we don't want set NTFS permission for users can delete the files because it's very dangerous when user got mistake delete the files of someone else in the same folder
Thanks for your helping Jimmy

I am very new to VB. I tried looking for this in a search as requested but could not find any that were unique to what I need. And since I heard somewhere that there are no stupid questions....

I have a data source that loops through and populates a template, all in Excel, creating a new file for each entry in the data source (~ 150). After the file is created I rename it to the last four letters in the first column. Leaving me with a file name that looks like "2586.xls" each one is unique. After I have renamed it I need a way to close the file so that I do not have 150 files trying to open on my desktop. Since the name changes for each file how do I get it to close the file?

I have attached the code that I used to change the file name and the worksheet name.

Any help with this would be greatly appreciated.


	VB:
	
Sheets("Template").Select 
Sheets("Template").Name = Range("A2").Value 
 'Changes the name of the worksheet to the site ID number located in the GSMID field
 
wbtemp.SaveAs Filename:=Right(Range("A2").Value, 4), _ 
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ 
ReadOnlyRecommended:=False, CreateBackup:=False 
 'Saves the file as the GSMID minus MO/KS

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


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

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 does not allow to Undo/Redo previous actions after the file has been
saved. In other words, if the user has made changes to the file, but wants to
keep the previous version and forgets to rename the file and clicks the save
button, the user cannot utilize the Undo/Redo options to go back and correct
this. On the other hand, Word does allow this. Why doesn't Excel?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hi,

Situation: I open Excel 2002 (XP), choose a file to open (eg
"myfile.xls") and work in it.

I save a copy via File / Save as. I name it "mynewfile.xls" and click
OK.

File correctly saved; the original still exists on disk. The filename
appears correctly in the File menu in the list of recently used files.

But: the information in the Excel's title bar didn't change: it still
displays the filename of the first file.

If I understand Excel well, it saves a copy of the original file to a
new one, and keeps working with the new one. So the new filename
should appear in the title bar.

I continue working in the new file; I close Excel, open it and open
the copy (mynewfile.xls), all changes I made after the first "save as"
are well kept and saved, and now, Excel displays the correct filename
in the title bar.

Has anyone an idea how to correct the issue with the title bar
information which isn't changing after a "save as"?

I use Excel XP SP3 English (10.6713.6735) and have full local admin
access on my PC / all xls files are stored locally.

thanks in advance for any reply, information, tip or solution!

Dominic

Hi all.
I had an excel file which I use as a sort of template.
I inadvertantly changed the file and saved it under the original name...
Looking for help I got to an article called: How To Recover MS Excel File If
Unwanted Changes Are Made (Article ID : 150368 -
http://support.microsoft.com/kb/150368
That article specifically says that the original version of the file is
deleted after the new version is saved which means that it is still on the
HD, albeit deleted. The article also says that it IS possible to recover the
file, but it doesn't say how...
I can't find the file in the recovery bin. I stopped using the computer as
soon as I found out so as not to write anything on that file's space.
Please help.

Excel does not allow me to save changes I have made to my files. It states
that it is has saved them as a temporary file and I need to open them and
rename them. The files are not protected or read-only. In addition, it will
not allow me to delete files. It looks as if it is being deleted, but it
does not remove the program. Any suggestions?

After saving my Excel files I automatically have a .tmp file created for each
one. It is an exact duplicate. I do not need these .tmp files. It places them
in the same folder as my originals.


No luck finding an answer? You could always try Google.