Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 8, 2013, 09:18 PM   #1
Cairbreo
macrumors newbie
 
Join Date: Jan 2013
A Curious Excel 2008 file Problem..

Hi,

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,
Cairbre
Cairbreo is offline   0 Reply With Quote
Old Jan 8, 2013, 09:24 PM   #2
McGiord
macrumors 68040
 
McGiord's Avatar
 
Join Date: Oct 2003
Location: Dark Castle
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?
McGiord is offline   0 Reply With Quote
Old Jan 9, 2013, 12:24 AM   #3
Cairbreo
Thread Starter
macrumors newbie
 
Join Date: Jan 2013
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!

Thanks,
Cairbre
Cairbreo is offline   0 Reply With Quote
Old Jan 9, 2013, 01:36 AM   #4
applebai
macrumors newbie
 
Join Date: Jan 2013
I also can open the file again.
__________________
http://www.disk-partition.com
applebai is offline   0 Reply With Quote
Old Jan 9, 2013, 01:45 AM   #5
Cairbreo
Thread Starter
macrumors newbie
 
Join Date: Jan 2013
Applebai..you can? Fantastic! Could you tell me how?...I would be forever grateful.
Cairbreo is offline   0 Reply With Quote
Old Jan 9, 2013, 04:06 AM   #6
seveej
macrumors 6502a
 
seveej's Avatar
 
Join Date: Dec 2009
Location: Helsinki, Finland
Quote:
Originally Posted by Cairbreo View Post
I would be immensely grateful for any possible solutions to the problem, as I have three weeks to my masters thesis submission ...
Ouch! I feel the pain. I know it might too late for you know, but keeping backups is a habit which you cannot learn too early.

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.

RGDS,

----------

P.S. This might be outlandish...

Quote:
Originally Posted by Cairbreo View Post
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.
So excel might really think it has loaded the file? But either will not or can not show it?
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?

HTH,
__________________
MP 3,1 'nuff RAM, 3 HDD's, 1 SSD, AMD 5770, 10.6
2009 Mini, as server
, and a lot of other gear.
seveej is offline   0 Reply With Quote
Old Jan 9, 2013, 04:52 AM   #7
Cairbreo
Thread Starter
macrumors newbie
 
Join Date: Jan 2013
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!
Cairbreo is offline   0 Reply With Quote
Old Mar 6, 2013, 04:32 AM   #8
JoelBarry
macrumors newbie
 
Join Date: Mar 2013
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.

Thanks
JoelBarry is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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

Forum Jump

All times are GMT -5. The time now is 09:50 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC