Excel cannot open this file. The file might have been damaged ormodified from it's original format.

J

Jon Connell

I've had this twice now with the same spreadsheet (quite a large one)
and Excel has now irrevocably lost data for me. I have a version in
backup, but all is lost for what recent data Excel 2008 has destroyed
in its mangling it seems. Older versions of Excel used to be able to
do data recovery, but I guess this is now impossible?

Before I go back to Office 2004 (which I intend to do), is there any
way to recover the data?

Oh ... and how does consumer law work in the US (where I bought the
software)? It's obviously not fit for purpose as UK consumer law would
understand it, but do I stand a chance of a refund?

Cheers,

Jon
 
B

Bob Greenblatt

I've had this twice now with the same spreadsheet (quite a large one)
and Excel has now irrevocably lost data for me. I have a version in
backup, but all is lost for what recent data Excel 2008 has destroyed
in its mangling it seems. Older versions of Excel used to be able to
do data recovery, but I guess this is now impossible?

Before I go back to Office 2004 (which I intend to do), is there any
way to recover the data?

Oh ... and how does consumer law work in the US (where I bought the
software)? It's obviously not fit for purpose as UK consumer law would
understand it, but do I stand a chance of a refund?

Cheers,

Jon
All you have to do for a refund is to take it back to the retailer where you
bought it.
 
A

Alan

I've had this twice now with the same spreadsheet (quite a large one)
andExcelhas now irrevocably lost data for me. I have a version in
backup, but all is lost for what recent data  Excel2008 has destroyed
in its mangling it seems. Older versions ofExcelused to be able to
do data recovery, but I guess this is now impossible?

Before I go back to Office 2004 (which I intend to do), is there any
way to recover the data?

Oh ... and how does consumer law work in the US (where I bought the
software)? It's obviously not fit for purpose as UK consumer law would
understand it, but do I stand a chance of a refund?

Cheers,

Jon

Hi,

There is a tool called Advanced Access Repair. I have used it to
repair many corrupt Access MDB files on my damaged disks successfully.
Its homepage is http://www.datanumen.com/aar/ Maybe you can have a
try.

Alan
 
L

lantheaume

Besides Alan's ever so not useful comment I don't see a resolution listed here.

I'm having the same issue with a spreadsheet I made in Excel 2008.

It's not large though.

What can I do to get my data out of the file?
 
P

Pat McMillan

I can't find the earlier posts to this thread. Can you please summarize your
scenario again? Did your file stop opening after running an updater or did
it stop opening after taking some action in Excel and saving? Is there any
chance you could send me the affected workbook? ([email protected])

Thanks,

Pat
 
L

lantheaume

I found a solution of sorts from this thread - <http://www.officeformac.com/ProductForums/Excel/1539/0>.

making a copy, and changing the extension to .xml worked.

I then re-saved the file over the old one as an xlsx and it saved and reopened fine.

I think what triggered it was the "Conditional Sum" I have going (it's under Tools), as it's the only thing unique compared to my other docs.

Anyone else have any experience with conditional sum and issues?
 
V

vickyquintana

Hi,
I have an Excel spreadsheet with an attached pivot table and the file keeps crashing. The error message that I get is that "Excel has encountered a problem and needs to close". I re did the file on a new worksheet and that hasn't helped. I've changed the extension to xml and xlsx and that doesn't seem to help either. I just upgraded to Excel 2008 in hopes that, that might help and nothing. I need to work on my file and I don't know what to do.
Can anyone help me?

thank you,
vicky :frown:
 
P

Pat McMillan

Vicky and I talked about this offline. As it turns out, she was running
12.0.0 and we fixed the bug that was causing this in a subsequent update.

Thanks,

Pat
 
M

MRCLBONE

I just encountered this problem on my MacBook OS 10.5.3 in Excel 2008. The workbook is not that large. Pat, I'll send you the file.
 
P

Pat McMillan

Thanks so much. I'll check out the file you've sent and let you know what I
find.

Pat
 
J

jmix

Hi Pat,
I am having the same problem. Excel 2008 file (with a pivot table) crashed and refuses to open. Renaming the extension does not help. I just emailed you the file. I really appreciate any help you can give me in salvaging the data.

Thanks,
Jason
 
M

MacJohnD

Excel2008 with Leopard10.5.3
I lost my file too!
Data and bar plots. No "conditional" items, etc.
Only 140KB.
I had performed periodic saves.
Tried copy and renaming as suggested.
Nothing has worked.
Another file that was open as the time of crashing was recovered and is okay.
Whatever is good about 2008 is far overshadowed by it ruining a day's work.
 
M

MacJohnD

More on the problem.

Todays ruined file was updated from a previous version. I attempted to open that file( saved yesterday as xlsx). It also generates the error now!

The version of the file before that was in .xls format and it does open.
As an experiment, I made a copy of it and changed the extension to .xlsx. The same error is generated.
 
M

MacJohnD

A solution?

Opened on XP machine with Excel 2007. It gave an error message, but opened. Saved as xlsx. It opens okay with Excel 2008.
 
P

Pat McMillan

Hi,

Is there any chance you can send me a copy of the file (the corrupted
version that no longer opens in Mac Excel 2008)? It would help us track down
the issue.

Thanks,

Pat
(e-mail address removed)
 
R

Robotdude

Hey this worked for me! Thank god. I believe the issue was that excel
crashed and opened the file via autosave. Once I went to save the file, I
chose save as and clicked on the original file. Once I did that I could no
longer open the file "which was password protected. I would put in the
password and then get the error we are talking about in this thread. I
copied the file, renamed it to .xml and it opened perfectly. Saved my ^$$
 
N

Nolie_Rules

I've just had the same problem.

I get the Excel cannot open this file the file may have been damaged or modified from its original format

I'm running:
- Mac OS X 10.5.4
- Excel 2008 for Mac 12.1.1

The file I'm having trouble with is a .xls, about 2.2MB file in size, has twelve good sized worksheets and a few graphs interspersed. It closed cleanly and now I get the error message.

Tried to save it as a .xml and .xlsx and re-open to no avail.

Help please!!
 
N

Nicolas de Biolley

I have a XLS file that works as a charm.
Open it, save it in "xlsx", and the problem EVERY single excel users in our
company encounters pops up (cannot open file blahblah).

So I can reproduce the problem, wich is the first way to a solution I
hope.... Because unfortunately, renaming it to xml doesn't work.

If you want this file, how can I attach it to this message? I'm no longer
using a usenet program, so posting via the microsoft website which doesn't
allow attach it seems.
 
F

Fergal Condron

Can you email the file to me at: (e-mail address removed)

Thanks,
Fergal.

Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
 
W

Wayne_Sandy

Hi MVPs,

After my wife spent 7 hours on an Excel file of our home budgets, full of Pivot Tables, last night, the aforementioned file -- now corrupted -- won't open in Excel at all.

At first, I thought this was happening because there are two versions of Excel on our G5 iMac (running Mac OS 10.4.11), and the file was having a hard time picking the most up-to-date version to open it. Solved that issue, but still couldn't open the file.

Tried NeoOffice, but the some of the file's contents vanished. Our old Windows laptop with MS Office, however, did open the file and it's now saved with another name we can read on the iMac.

Question: Is there a utility on the newest version of MS Office for the Mac that can fix previously usable, but now corrupted, Excel files? I'm not convinced that upgrading to a newer version will help in the future.

Thanks for any help and advice y'all can provide,

Wayne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top