Mac Forum / Applications / Excel / October 2008

On 5/8/08 2:43 PM, in article
456d9add-4f03-4c44-bd90-e15fc93ef2f3@b1g2000hsg.googlegroups.com, "Jon
Connell" <ciamabue@googlemail.com> wrote:

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

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

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:

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

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.

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.

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.

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!!

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

I managed to recover my file two ways:

1. I sent it to Patrick McMillan at Microsoft and he recovered it using a PC and he saved it to .xls
2. A buddy recovered it using iWork and exported it to .xls, this retained more of the formatting than the previous.

Many thanks to Pat, great support.

I managed to recover my file two ways:

     1. I sent it to Patrick McMillan at Microsoft and he recovered it using
     a PC and he saved it to .xls 2. A buddy recovered it using iWork and exported
     it to .xls, this retained more of the formatting than the previous.

     Many thanks to Pat, great support.

Just like chime in that I too experienced the corruption issue and was able to recover it using the iWork import/export functionality.

The spreadsheet in question made heavy use of conditional sums but was otherwise fairly ordinary - no graphs, charts, enormous size, etc.

There was no prior crash/problem closing that would have been an obvious trigger for file corruption.

The file was saved in the .xlsx format.

I hope this issue is able to be identified quickly and resolved.

So, there doesn't seem to be any quick fix it is there? I was working on a spread sheet yesterday, and now its have the same described error. Renaming it doesn't seem to have helped.