Free Microsoft Excel 2013 Quick Reference

Recover Excel file that was saved over

I accidentally saved over a worksheet with another file. Can I recover the
original. I have searched and the most recent backup is from Feb. I do not
have a system that automatically backs up my files. I have tried auto
recovery, restoring the system to a previous date, searching my complete
computer. Any suggestions?


Post your answer or comment

comments powered by Disqus
I was working in excel and wrongly I closed the excel file without saving the
file.

I wish to recover my workdone in excel workbook that was closed without
saving.

Please let me know the steps I need to follow for retrieving my data.

Regards,

how do I get my orginal excel file back after saving over it?

I do not have a backup of the file that I lost. I saved over the file after
deleting the information from the file that was opened and saved without
renaming the new file.

I exited an excel file prior to saving it. Is it possible to recover the
file in its entirety?

I know this sounds strange, but yesterday I spent nearly 4 hours on a document and I naturally save every 20-30 seconds or so. I'm POSITIVE that within this time frame I saved my work, however when I came back to it it was not there. Here's a chronology of events that happened:
1) received file from superior via hotmail, opened the file, saved it and started work on it
2) consistently saved the file throughout the work day
3) closed my computer without closing anything (perhaps then causing a force shut down). I did not properly 'shut down' my computer so perhaps is this where the problem initiated?

I tried to find it in Search and only the original file from my superior comes up, no changes made to it. I looked in the Excel - Recover files? folder and it was empty.

somebody PLEASE help...

I inadvertently saved a blank Excel file over an existing file. E.g., I had
a file called "web info". I opened a new Excel worksheet and saved it as
"web info". So the original file was overwritten with a blank file. Can I
retrieve the original "web info" file and the data?

I inadvertently saved a blank Excel file over an existing file. E.g., I had
a file called "web info". I opened a new Excel worksheet and saved it as
"web info". So the original file was overwritten with a blank file. Can I
retrieve the original "web info" file and the data?

I have an excel spreadsheet that was created and saved to the A: drive (3.5
floppy). It has been opened and updated several times without a problem, now
all of a sudden, it lags to open and then i get an error stating it cant be
opened and my be a read only file. Why all of a sudden is this file unable to
be opened?

How do I stop excel from opening the last file that was saved prior to
closing Excel?
There has to be a check box some where, right??

I typed up some History notes and saved it. I wanted to use the same format
from those History notes for some new History notes and I saved over on my
old work. How can i retrive my old saved work? My work was in Word not Excel
But I could not find a place to ask a question in the Word help section.

I saved over an EXCELL file that someone sent to me in OUTLOOK, after adding
hours of data. Unfortunately I clicked "save as" but did not change the
directory.
It has saved my EXCEL FILE in a folder called OLKE9.
I have searchjed the path, but cant fnd the file (I am displaying hidden
files).

Please help, I need this file in only 8 hours time or my life will be a
misery.

Hi there!

So I have some VBA code that saves to network drive Excel files based on their store number, after it all finishes to process using the VBA script, it creates a log sheet which shows me all the Excel files that were saved and processed. The log file is just a plain sheet that records the locations of the save in the network drive and the excel file name.

I send a notification to employees, they use those files and fill in some data into the sheets and then at the end of the month, we need to grab those files back from the network drive for analysis. The files are in the same exact network path and the file names will not change, what would be the best way to grab those files back from the network drive and import them into a workbook using VBA ?

I was thinking of using something that would be able to work by selection, or I select the rows and then have Excel import the selected files into a single workbook, to give an example:

Let say that I have 5 rows in the Log sheet in column A and each row represents a successful save:

COLUMN A

Row1: networklocationlistsregion1Excel_doc_1.xls
Row2: networklocationlistsregion1Excel_doc_569.xls
Row3: networklocationlistsregion2Excel_doc_587.xls
Row4: networklocationlistsregion2Excel_doc_2.xls
Row5: networklocationlistsregion2Excel_doc_6.xls

I would like to be able to play a VBA script, it would allow me to highlight by selection the range that I want to process, so in this example I would highlight A1:A5 and then I would continue the VBA procedure and Excel would import those 5 Excel files into a single workbook, so 5 sheets in this case, each representing the document imported ?

I was looking into Application.GetOpenFilename, but I am not sure what the best way is yet, I figured I would start here and get every ones opinion.

Thanks a lot in advance for your help and assistance.

I have a Macro running currently and saving the Excel file to two locations. I would like to have the Excel file that was previously saved updated to include several excel files as separate tabs and save the file with a new name.

For example: The file is saved to My Data & the Server as Summary 01-05-2008.xls. I want to add six Excel files that are saved in My Data to the file that was saved as Summary 01-05-2008.xls as separate tabs for each file. Once these tabs have been added to the report, then I would like to save the file in My Data & the Server as Details 01-05-2008.xls.

Is this possible???

Thanks!
Jen

I need to open an Excel file that was saved with password protection in Excel
2003 but using Excel 2000. I know the password, but when I try to open the
file I get the message: "The password you supplied is not correct. Verify
that the CAP LOCK key is off and be sure to use the correct capitalization".

The File opens fine in Excel Viewer but this doesn't allow me to see the
formulas - just the calculated worksheet. Is there a free workaround /
program / utility that will allow me to remove the password protection so
that I can open the file in my version of Excel? Unfortunately I don't have
access to a later version of the Excel software.

I appreciate any help !

I have an excel file that I save in a csv format. There are some columns
that have numbers in them with zeros as the first numbers that have to remain
(i.e. 001234). The zeros are in the excel file with whatever cell format I
use, but when I save it as a csv and then bring up the csv file, the zeros
are dropped. Any ideas?

I have a very important document that needs to be restored. Typically, I
edit the info and then use the "save as" button to store it as something
else. However, today I clicked "save" in the middle by accident.

Please help me!!!

How do you check if an excel file has been saved in VBA? That is, if I have
an excel file open, what property tells me if the file has been saved yet?

I am thinking of an instance where I open a new workbook and forget to save
it. I want to run a macro that tells me that although the file is open, it
has not been saved yet.

Thanks

I had a Excel file that was worked on using a Office XP machine, and
know it is back on my Mac. But know everytime I save I keep on getting
this message using Office 98 for Mac.

"This file was created using a later version of Microsoft Excel. If you
save this file using Microsoft excel 98, information created with
features in the later version may be lost."

I have tried the following.

1) Saving as a new file and renaming it
2) Saving as Excel 5.x, and then back to Excel 98
3) Deleting the Cell comments that I created in Excel XP, and redoing
them in Excel 98

Thanks,

John

I have written a Matlab program to do some data analysis. The results are then exported to an Excel-file. I'm am planning to distribute this Matlab-script among my colleagues. However, some of their computers will use the point as a decimal separator (English system locale), whereas others use the comma (Dutch system locale). Matlab exports its data with a point as decimal separator, which gives incorrect results if the program is run on systems with the comma separator.

I have noticed that numbers with decimals, in an Excel-file created on a system using a decimal point, are automatically converted by Excel when the file is opened on a system with a decimal comma (so 2.56 becomes 2,56). So the Excel-format must include some information on the decimal separator or locale of the system at the last save (otherwise Excel wouldn't know that it had to convert the numbers). I am wondering whether I can set this decimal separator or locale myself for the exported Excel-file? This way, an Excel-file created by Matlab on a system with a comma as separator will be recognized as an Excel-file that was created on a system with a decimal point. Then Excel should automatically convert the numbers.

The other day I tried to open an excel file that I had created on my
mac on a Windows computer. When I went to do this all of the formatting
I had done on the Mac was lost and everything was set to the Windows
Default. I had the font, sizing, and placement of everything different
and it all went back to the Windows Default format.

Does anyone know how to get around this?? So for when I send an Excel
file I created on my Mac to a Windows computer it LOOKS exactly the
same as far as formatting.

Thanks

Neil

I would like to write a macro that will open a designated excel file, (really
doesn't have to open it visibly, I just need to be able to insert items in
the next empy row) Order Form.xls, find the first empty row, insert values in
certain cells in that row based on values from the excel file that called the
macro, save the Order Form.xls file, close (if opened) and return to the
original excel worksheet. I have a function currently that does something
similar into an access file. Are the methods similar?

I have a excel file that went from 646 kb to 4787 kb for no reason. I only
added a few things to the file. I have had the same spreedsheet for over a
year and it gets bigger everymonth but only by about 10 kb at a time. Could
I have a viruis or is ther an easy fix to make it smaller agian. It is very
hard to work wioth the file now.

Hi,
I have an Excel file that scrolls slowly and is 1.7 MB big when it really shouldn't be. Change tracking is of, there are no formulas and no VBA code. I have stripped everything out of the spreadsheet, deleted every row/column and did a "Clear All" on the entire thing and it is still 1.7 MB. There are no hidden or very hidden sheets.

Has anyone ever encountered this? Exporting out the text and starting over really isn't an option, so I hope someone can help me.

Thanks.

I have a very important document that needs to be restored. Typically, I
edit the info and then use the "save as" button to store it as something
else. However, today I clicked "save" in the middle by accident.

Please help me!!!


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