Hi All
excel 2007
I went to load up a speadsheet and was amazed what came up when excell loaded it
excell has recovered the following files. save the ones that you want to keep
I select a file then excell crashes
I can put the spreadsheet in my other computer and they work fine with no problem
I have uninstalled office then re installed it , just the same
checked for virus none
I'm stuck what to do
Have you come across this before
all the files are fine nothing wrong with them at all
So why does excel on this computer keep tell me that they have repaired them,
I cannot load them up and use them
Thank you
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
excel 2007 keeps asking to recover files
0
Discussion
Hello zacrock,
The files which Excel says it has recovered are ones from when Excel crashed. Since these are versions of the original file which caused Excel to crash, they too will cause Excel to crash. These are recovered files not repaired files.
It's possible that the file contains links to other files which are not on the computer where it crashes.
Have you ever run this problem file on the problem computer in the past?
It's possible that the computer doesn't have the resources (memory, CPU power) to handle the file. Was this problem file created with a later version of Office (2016, 2021,365) ? If so, there could be elements in the file which Excel 2007 and/or your computer can't handle.
Is it possible you could up lolad the file so we can give it a look? (Don't upload the file if it contains sensitive or personal information that should not be made public)
The files which Excel says it has recovered are ones from when Excel crashed. Since these are versions of the original file which caused Excel to crash, they too will cause Excel to crash. These are recovered files not repaired files.
It's possible that the file contains links to other files which are not on the computer where it crashes.
Have you ever run this problem file on the problem computer in the past?
It's possible that the computer doesn't have the resources (memory, CPU power) to handle the file. Was this problem file created with a later version of Office (2016, 2021,365) ? If so, there could be elements in the file which Excel 2007 and/or your computer can't handle.
Is it possible you could up lolad the file so we can give it a look? (Don't upload the file if it contains sensitive or personal information that should not be made public)
WillieD24 (rep: 557) Dec 2, '23 at 6:58 pm
Many thanks for getting back to me
The files which Excel says it has recovered are ones from when Excel crashed
Nope did not or has crashed.
==========================
It's possible that the file contains links to other files which are not on the computer where it crashes.
No no links to other files.
============
Have you ever run this problem file on the problem computer in the past?
Yes that is where I made the S/S and never on any other computer
=========================
It's possible that the computer doesn't have the resources (memory, CPU power) to handle the file.
Yes it has plenty of the above, like I say above made it on this computer
=============================
Was this problem file created with a later version of Office (2016, 2021,365) ? If so, there could be elements in the file which Excel 2007 and/or your computer can't handle.
Like I say above the S/S was made on this computer. and was made with 2007
The funny thing is other spread sheets that I have run all okay.
also what I cannot understand is if i take it to another computer with the same setup as this one the S/S RUN ALL OKAY. so the S/S cannot be faulty
So i'm stuck to what to do
The files which Excel says it has recovered are ones from when Excel crashed
Nope did not or has crashed.
==========================
It's possible that the file contains links to other files which are not on the computer where it crashes.
No no links to other files.
============
Have you ever run this problem file on the problem computer in the past?
Yes that is where I made the S/S and never on any other computer
=========================
It's possible that the computer doesn't have the resources (memory, CPU power) to handle the file.
Yes it has plenty of the above, like I say above made it on this computer
=============================
Was this problem file created with a later version of Office (2016, 2021,365) ? If so, there could be elements in the file which Excel 2007 and/or your computer can't handle.
Like I say above the S/S was made on this computer. and was made with 2007
The funny thing is other spread sheets that I have run all okay.
also what I cannot understand is if i take it to another computer with the same setup as this one the S/S RUN ALL OKAY. so the S/S cannot be faulty
So i'm stuck to what to do
zacrock (rep: 6) Dec 2, '23 at 7:29 pm
zacrock,
Just to clarify again: recovered files are not repaired files. These are files which Office/Excel recovered when Excel or the computer crashed.
The only other suggestion I have (something which worked for me in the past) is to ignore the "recovered" files and simply open the file you originally selected. I have found "recovered" files can sometimes be problematic.
Cheers :-)
Just to clarify again: recovered files are not repaired files. These are files which Office/Excel recovered when Excel or the computer crashed.
The only other suggestion I have (something which worked for me in the past) is to ignore the "recovered" files and simply open the file you originally selected. I have found "recovered" files can sometimes be problematic.
Cheers :-)
WillieD24 (rep: 557) Dec 2, '23 at 8:28 pm
Zacrock (aka John). Sorry but I haven't encountered that start-up issue (but have ignored the recovery options, as Willie suggests).
With Excel closed, try taking a look in the AutoRecover file location- you can find it from Excel 2007's Save options but it's probably like mine:
where the bit in bold is my user name (and should be replaced by yours if different).
If there are temp files in there (ones starting with the tilde ~), delete them then boot Excel again.
If that doesn't work, I saw this YouTube video from a quick search: Microsoft Excel Is Trying to Recover Your Information FIX. That might get Excel back and you can start re-enabling macros etc.
Good luck!
With Excel closed, try taking a look in the AutoRecover file location- you can find it from Excel 2007's Save options but it's probably like mine:
C:\Users\John\AppData\Roaming\Microsoft\Excel\where the bit in bold is my user name (and should be replaced by yours if different).
If there are temp files in there (ones starting with the tilde ~), delete them then boot Excel again.
If that doesn't work, I saw this YouTube video from a quick search: Microsoft Excel Is Trying to Recover Your Information FIX. That might get Excel back and you can start re-enabling macros etc.
Good luck!
John_Ru (rep: 6142) Dec 3, '23 at 8:03 am
Hi John Ru
Have you changed your email?
CLUE Mick Tunecliff
PROBLEM
The problem with that link it is not my version of excel 2007, so have not got what he is telling me .
cannot find the files any where .
Have you changed your email?
CLUE Mick Tunecliff
PROBLEM
The problem with that link it is not my version of excel 2007, so have not got what he is telling me .
cannot find the files any where .
zacrock (rep: 6) Dec 3, '23 at 10:39 am
ignore the "recovered" files and simply open the file you originally selectedYes that is what I did from the start . All I do is just double the file and it loads up inexcel
zacrock (rep: 6) Dec 3, '23 at 10:43 am
@zacrock
The reason you never got the recovered files on a different coputer is because the recovered files are not on that computer.
Have you deleted the "recovered" files? If yes, good. If not you can try one of these methods: 1) when Excel presents the "Recovered Files" pane at the left, try right clicking on one of the file names and see if you get the sub menu with "open file location". If you do, click on it to get to the folder where these files are at and delete all of them from there; 2) make note of the file name of one of the "recovered" files (richt click and copy it if you can). Then open File Explorer, select your root drive (C:/) and paste the file name into the search box and search for it. This may take a while. You will then be able to get to the folder where that file(s) are located and delete them. Once the files are deleted you should not get the "Recovered Files" pane.
Cheers :-)
The reason you never got the recovered files on a different coputer is because the recovered files are not on that computer.
Have you deleted the "recovered" files? If yes, good. If not you can try one of these methods: 1) when Excel presents the "Recovered Files" pane at the left, try right clicking on one of the file names and see if you get the sub menu with "open file location". If you do, click on it to get to the folder where these files are at and delete all of them from there; 2) make note of the file name of one of the "recovered" files (richt click and copy it if you can). Then open File Explorer, select your root drive (C:/) and paste the file name into the search box and search for it. This may take a while. You will then be able to get to the folder where that file(s) are located and delete them. Once the files are deleted you should not get the "Recovered Files" pane.
Cheers :-)
WillieD24 (rep: 557) Dec 4, '23 at 9:45 am
Willie24
Okay this is what I have done so far.
C:\Users\build\AppData\Roaming\Microsoft\Excel\
Nothing in that folder
==========================
ignore the "recovered" files and simply open the file you originally selected
Excel crashes
===========================
Have you deleted the "recovered" files?
none to be found anywhere
===========================
when Excel presents the "Recovered Files" pane at the left, try right clicking on one of the file names and see if you get the sub menu with "open file location".
No, only get open, save file , show repairs.
====================================
Cannot copy it
NOW the funny thing is when I click show repair it comes back with
no errows detected this file does not need repairing.then crashes
==========================================
This is one of the files that is listed
J Jones file 2 9 2023
Version creaded last time the
00:00 01 january 1601
====================================
Now I have unistalled office complete with revo uninstaller complete
Took out ref to office and excel in the regedit files.
Took off ALL REF to the spreadsheet on the compter so there is no ref to that S/S at all
Installed office 2007 again
Diasabled AVG AND ZONE ALARM.
Rune excell SAME dam thing list that file on the left.
How can it list the files when they are NOT ON THE computer
Okay this is what I have done so far.
C:\Users\build\AppData\Roaming\Microsoft\Excel\
Nothing in that folder
==========================
ignore the "recovered" files and simply open the file you originally selected
Excel crashes
===========================
Have you deleted the "recovered" files?
none to be found anywhere
===========================
when Excel presents the "Recovered Files" pane at the left, try right clicking on one of the file names and see if you get the sub menu with "open file location".
No, only get open, save file , show repairs.
====================================
Cannot copy it
NOW the funny thing is when I click show repair it comes back with
no errows detected this file does not need repairing.then crashes
==========================================
This is one of the files that is listed
J Jones file 2 9 2023
Version creaded last time the
00:00 01 january 1601
====================================
Now I have unistalled office complete with revo uninstaller complete
Took out ref to office and excel in the regedit files.
Took off ALL REF to the spreadsheet on the compter so there is no ref to that S/S at all
Installed office 2007 again
Diasabled AVG AND ZONE ALARM.
Rune excell SAME dam thing list that file on the left.
How can it list the files when they are NOT ON THE computer
zacrock (rep: 6) Dec 4, '23 at 3:53 pm
To remove Office you could have done that through Control Panel. When you say "Took off ALL REF to the spreadsheet on the computer so there is no ref to that S/S at all", have you deleted the "recovered" files as well. It is these recovered files that are the problem. You need to delete these files to prevent the file recovery pane from popping up.
Recovery files are stored at:
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
Recovery files will have the extension: XLSB (binary format) or XLK.
If the file is stored on a flashdrive, here is something else you could try. Open the file on the computer where there is no issues. Save it, and plug the flashdrive into the "problem" computer and open the file. If you still get the "Recovered Files" pane that means the recovered files still exist. Try renaming the file (ex: add "1" to the end) and try opening. There should be no recovered files because threcovered files do not refer to the new name.
Hope this helps'
Recovery files are stored at:
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
Recovery files will have the extension: XLSB (binary format) or XLK.
If the file is stored on a flashdrive, here is something else you could try. Open the file on the computer where there is no issues. Save it, and plug the flashdrive into the "problem" computer and open the file. If you still get the "Recovered Files" pane that means the recovered files still exist. Try renaming the file (ex: add "1" to the end) and try opening. There should be no recovered files because threcovered files do not refer to the new name.
Hope this helps'
WillieD24 (rep: 557) Dec 4, '23 at 7:21 pm
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
Recovery files will have the extension: XLSB (binary format) or XLK.
Yes done that and it does not list that folder at all.
I use a very good program called " everything" which is far faster than the M\S search
they is no files with them extention at all.
Done all the above but still the same.
I have made a new partition and installed win 10 on that
used EASYBCD booted into the new partition
installed Office 2007
Then put the file on that partition then double clicked it
WOW it works all okay.
NOW here is the very strange thing
Shut down computer booted back into my first win ten where excell did not work
Now it all works on tha computer
How strange
Any ideas?
Recovery files will have the extension: XLSB (binary format) or XLK.
Yes done that and it does not list that folder at all.
I use a very good program called " everything" which is far faster than the M\S search
they is no files with them extention at all.
Done all the above but still the same.
I have made a new partition and installed win 10 on that
used EASYBCD booted into the new partition
installed Office 2007
Then put the file on that partition then double clicked it
WOW it works all okay.
NOW here is the very strange thing
Shut down computer booted back into my first win ten where excell did not work
Now it all works on tha computer
How strange
Any ideas?
zacrock (rep: 6) Dec 5, '23 at 6:43 am
Hi zacrock,
I'm glad to hear that all is now working as it should. You certainly had to jump through a lot of hoops to get to the end of this. I have never encountered a situation like yours which couldn't be remedied via normal methods.
It is odd that your computer couldn't find "C:\Users\AppData\Local\Microsoft\Local\UnsavedFiles. That begs the questiion as to where was it pulling the recovered files from.
For clarity, this was an Excel file issue, not an Excell issue. If it was Excel itself, there would be issues with all workbooks, not just one particular file.
Knowing the root cuase of this issue would be great, but you may never learn the real reason that caused your grief. I would just accept the fact things are working and move forward.
Cheers :-)
I'm glad to hear that all is now working as it should. You certainly had to jump through a lot of hoops to get to the end of this. I have never encountered a situation like yours which couldn't be remedied via normal methods.
It is odd that your computer couldn't find "C:\Users\AppData\Local\Microsoft\Local\UnsavedFiles. That begs the questiion as to where was it pulling the recovered files from.
For clarity, this was an Excel file issue, not an Excell issue. If it was Excel itself, there would be issues with all workbooks, not just one particular file.
Knowing the root cuase of this issue would be great, but you may never learn the real reason that caused your grief. I would just accept the fact things are working and move forward.
Cheers :-)
WillieD24 (rep: 557) Dec 5, '23 at 10:27 am
Hi Willied24
I think it might have been somthing to do with me making another partition on that computer.
I have put ALL my S/S back now and all is working fine so far.
Thank you very much for your help also John Ru
do I goto the bottom of this page and say answer to mark it solved?
Many thanks
I think it might have been somthing to do with me making another partition on that computer.
I have put ALL my S/S back now and all is working fine so far.
Thank you very much for your help also John Ru
do I goto the bottom of this page and say answer to mark it solved?
Many thanks
zacrock (rep: 6) Dec 5, '23 at 3:09 pm
Zacrock, please don't Answer (that should deliver a solution).
Instead mark Willie's Answer as Selected, as mentioned in the Rules section, here: Select an Answer to a Question
Instead mark Willie's Answer as Selected, as mentioned in the Rules section, here: Select an Answer to a Question
John_Ru (rep: 6142) Dec 5, '23 at 4:41 pm
zacrock,
Good to hear everything is back to normal. Happy to help.
You won't be able to select my "answer" as selected (as John recommends) because I only responded with discussion points. We help people on a voluntary basis without any compensation. If you want, I can create an answer reply so can can give me credit. Just let me know.
Cheers :-)
WillieD24 (rep: 557) Dec 5, '23 at 5:11 pm
@Willie- sorry, I assume the answer from wjwestcott was yours. sorry.
John_Ru (rep: 6142) Dec 5, '23 at 5:43 pm
Hi Willied24
If you want, I can create an answer reply so can can give me credit.
Yes please
with instructions please
Kind Regards
If you want, I can create an answer reply so can can give me credit.
Yes please
with instructions please
Kind Regards
zacrock (rep: 6) Dec 6, '23 at 2:35 pm
@zacrock,
Done. At the very bottom of this post.
Done. At the very bottom of this post.
WillieD24 (rep: 557) Dec 6, '23 at 10:41 pm
Answers
0
Selected Answer
Hello zacrock,
This situation/problem can be very frustrating.
The files which Excel says it has recovered are ones from when Excel or the computer crashed. If an Excel file is open and changes have not been saved when a crash happens, Excel will create a version of the file at the time of the crash.
These are recovered files not repaired files. These are files which Office/Excel created when Excel or the computer crashed. A crash can happen for a variety of reasons: software issue, corrupted file, power blip/outage or dead battery to name a few.
It's possible that the file contains links to other files which are not on the computer where it crashes.
It's possible that the computer doesn't have the resources (memory, CPU power) to handle the file.
You mention other spread sheets all run okay. This indicates this was an Excel file issue, not an Excel issue. If it was Excel itself, there would be issues with all workbooks, not just one particular file.
The only other suggestion I have (something which worked for me in the past) is to ignore the "recovered" files and simply open the file you originally selected. I have found "recovered" files can sometimes be problematic.
The reason you never got the recovered files on a different computer is because the recovered files are not on that computer.
Recovery files are stored at:
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
Recovery files will have the extension: XLSB (binary format) or XLK. You need to find these files and delete all of them so Excel won't try to open them.
Once the files are deleted you should not get the "Recovered Files" pane.
If this information solves your problem please mark my answer as selected.
Cheers ;-)
0
Another reason for having recovered files is that your computer shutdown or crashed with an open/modified/unsaved excel file, and if your workbook has a fault which causes excel or the laptop to crash it will still be trying to recover next time you open it.
You will need to try to recover it without executing the code.
One possibly might be by holding down shift key when you open excel.
Or deleting the recovered file if you can find where it is stored. In one of your office applications select File / Options / Advanced / file locations.
Discussion
This is what I suggested in my discussion point above (Dec. 2 @ 7:28 pm)
WillieD24 (rep: 557) Dec 3, '23 at 10:25 am