|Jan 8, 2013, 09:18 PM||#1|
A Curious Excel 2008 file Problem..
I have a problem with an important .xlsx excel spreadsheet that I cannot solve with my best efforts, and hoping that the MacRumours community might be able to help.
I was working on an excel file (188KB), and began to copy charts to Microsoft Office. There seemed to be a problem with this so I closed both applications and reset the computer. From that point on I have not been able to reopen the excel file. No error message appears when I double click on the file. Excel starts, and the loading bar appears, and then nothing happens, no spreadsheet appears. When I double click on the file again a message pops up saying that the file is already open. When I use 'Quick Look' I can see everything in the file, so I am hopeful that it can still be opened. The file can also be viewed with the OpenOffice application, however, all the linked data is missing, and so if possible I want to restore the original file. I tried opening the file on another mac and a PC but the same thing happens...nothing! I have also updated the excel 2008 version, with no luck.
I would be immensely grateful for any possible solutions to the problem, as I have three weeks to my masters thesis submission, and could use the Master Data Sheet.
Thanks for reading,
|Jan 8, 2013, 09:24 PM||#2|
With MS software and a corrupt file, sometimes it is better to copy the data to a new file, re-create the graphs and move on.
What do you mean you by: copied the graph from Excel to MS Office?
Have you tried using a newer version of Office?
And now what is NeXT?
|Jan 9, 2013, 12:24 AM||#3|
Thanks for the reply McGiord.
Yes, if I could open the file again I would certainly copy the data to a new file and re-create the graphs.
What I meant with copying the graphs was: When I finished creating the charts in the excel file, I then began to copy and paste them into a Word Document. However, when I tried to paste the first one into the Word Document, an error box came up and it refused to paste. In a quick attempt to resolve this issue, I closed down both applications and upon restarting the problem began.. Presumably, I may have upset the file during that incident.
I have not yet tried to open the file with a newer version of Office, i must try that!
|Jan 9, 2013, 04:06 AM||#6|
The actual problem seems to be that you've somehow corrupted the file. If you do not have any backups (like a two days old version) you can restart with, you need to try to force yourself into the file one way or the other.
Excel usually has had two routines for opening files, one is the doubleclick file -approach, the others based on File->open (these actually do slightly different things, so if one does not work, you should try the other). Also, as it's an xlsx, you should have a go at it with all excel versions which natively support the format, on both Mac and pc, enlist your friends to help if necessary.
Also, as you've already noticed, other spreadsheet applications may be able to recover some parts of your data (a disagreeable scenario, but better than nothing). Again, unless your data is confidential, send copies of the file to a few friends and ask them to try with different approaches.
Corrupted files are the worst part of working with computers, because they might be unsalvageable. I'll hope for the best.
P.S. This might be outlandish...
Once you've opened the file, check around if it is "open but not showing". Is it listed in the menu of windows? Can you do a save as? Doesn't allow you to export?
MP 3,1 octo, 8GB RAM, 3 HDD's, 1 SSD, AMD 5770, 10.6
MP 5,1 octo, 12GB RAM, 2 HDD's, 1 SSD, AMD 5770, 10.6
2009 Mini, as server
, and a lot of other gear.
|Jan 9, 2013, 04:52 AM||#7|
Seveej my Finish friend, what a wonderful contribution! Indeed, the classic not-backing-up rookie mistake, never again! ...Although I remember saying that the last time it happened a few years ago too.
I will try your suggestions, there must be a way to force into the file one way or another, as you so eloquently put it. When it opens in the Quick View its like I'm looking in the window from outside but can't get in and touch the data!
..Just as I was about to send this message I thought i'd first try your suggestion of double clicking the file and checking around to see if it's "open and not showing" as you said. Outlandish you said?? As I was browsing around, i clicked on the Window tab and there was a button that said 'Unhide'. Unhide?? Why would it hide in the first place?? Did I hide it? I don't think so. What I do know is that, Seveej my friend, you have solved the curious case of the unopenable file. When I clicked the Unhide button the file popped up as if it never left. You are a genius and I thank you a million times for your great direction and help!
|Mar 6, 2013, 04:32 AM||#8|
Almost all inaccessible data of infected Excel sheet can be successfully retrieved by the RecoveryFix for Excel Recovery tool. Moreover, you can evaluate the performance of the software with the available free demo version. This demo version effectively extracts user data from corrupt Excel file and shows all retrieved data in list.
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Chart in excel 2008||grkprncezz||Mac Applications and Mac App Store||0||Oct 21, 2013 10:32 AM|
|2008 Excel Crashing||mojoart||Mac Applications and Mac App Store||0||Nov 25, 2012 08:25 PM|
|How to create the list of worksheets in an excel file? 2008||oyl2008||Mac Basics and Help||1||Nov 17, 2012 08:20 PM|
|Office 2008 Excel||fluidlives||Mac Basics and Help||2||Aug 30, 2012 05:40 AM|
|MS Excel 2008 Help||mic j||Mac Applications and Mac App Store||0||Aug 13, 2012 02:47 PM|
All times are GMT -5. The time now is 05:31 PM.