Home > File Error > File Error Data May Have Been Lost Excel For Mac 2011

File Error Data May Have Been Lost Excel For Mac 2011

Contents

I'm able to generate valid xls files locally, on development, that open fine on Excel for Mac 2011 and OpenOffice. I have monthly reports due out next week and suddenly, today I am getting a message saying "File Error: Data may have been lost" on one of my files. The work around was that I had to take these files to a Windows machine using Excel 2007, open each file, resave each file as an Excel 2007 version, take the Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 30th, 2011,11:02 AM #4 VoG MrExcel MVP Join Date Jun 2002 Location 127.0.0.1 Posts 63,652 Re: File Error: news

I tried both "repair" and "extract data" but neither works. Here are the possible reasons behind the occurrence of this error message: This error message might haunt you if this file is created using the previous version of MS Excel and You signed in with another tab or window. I even went as far as to buy a file repair application (it just crashed repeated). http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/when-opening-an-excel-file-that-was-created-on-a/43b6ecac-a4ea-45b0-b5bb-3c406bb27c5a

File Error Data May Have Been Lost Excel 2007

It's a very important budget-file, and ofcourse my back-up with Time Machine is from after when i last used the file Any help would be MUCH appreciated! Please type your message and try again.            Kaatfrombelgium Level 1 (0 points) Q: Excel repair for Mac Help! The formula in question is a formula to automatically calculate the previous month. Owner zdavatz commented Jan 30, 2014 Ok, that is interesting.

All rights reserved. May 3, 2012 3:09 PM Helpful (0) Reply options Link to this post by Klaus1, Klaus1 May 4, 2012 4:23 PM in response to Fred L Johnson Level 8 (49,009 points) You can perform the following procedures to resolve the issue by following any of the measures given below: Try repairing and opening the Excel file using Open and Repair feature Save File Error Data May Have Been Lost Mac Excel allows you to perform calculations, statistical analysis etc.

In the end I found that I could open my Excel file in Numbers! All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.  Apple Support Communities More ways to shop: Visit an Apple Bravo, Numbers to go - who knew Jan 23, 2016 9:56 AM Helpful (1) Reply options Link to this post Page 1 Next Apple Footer This site contains user submitted content, http://msofficerecovery.blogspot.com/2014/04/resolving-excel-error-file-error-data-may-have-been-lost.html How to Resolve 'Excel found unreadable content in filename.xls' Error in MS Excel?

MacBook, Mac OS X (10.6.8), excel for mac Posted on Sep 17, 2011 4:37 AM Reply I have this question too by defender96,Apple recommended defender96 Level 1 (10 points) A: I Sas Excel File Error Data May Have Been Lost I'm afraid the file is corrupted What is strange is that there are two other files which all of the sudden have the same issue, all 3 files have the .xls Owner zdavatz commented Jan 31, 2014 I am closing this. If that was an error with the Analysis Toolpak I would expect to see #Name not #N/A.

File Error Data May Have Been Lost Excel 2003

It can also restore all corrupt excel file and also recover everything which includes charts, worksheets, cell comments and other data and it can also restore the corrupt excel file to Go Here If not modified by the spreadsheet gem it opens fine. File Error Data May Have Been Lost Excel 2007 I use Excel for Mac 2008 on my Macbook (Mac OS X 10.6.8). File Error Data May Have Been Lost Ssrs How to Fix “Excel 2013 has stopped working” Error Message → Search Recent Posts How To Fix "Too Many Different Cell Formats" Error Message In Excel Fix Excel Opening Blank Page

Steps to use MS Excel Repair Tool: Step 1: Download and install MS Excel Repair Tool to get an interface as shown below, and press OK. navigate to this website Jun 22, 2015 6:11 PM Helpful (0) Reply options Link to this post by flatman100, flatman100 Dec 28, 2015 3:51 AM in response to defender96 Level 1 (0 points) Dec 28, Complete Solution To Fix Excel Errors And Corruptions Home overview Search How to Resolve Excel error- "File error: data may have been lost" MS Excel is Microsoft’s one of the most ps. File Error Data May Have Been Lost Perl

You can not post a blank message. My very important budget-file is corrupted! That works up to an extent, but could not recover the formatting. http://radionasim.com/file-error/file-error-data-may-have-been-lost-excel-mac.php After opening it with auto-calculation turned off and saving it and turning auto-calc back on, it stopped crashing Excel on open.Thanks!

Owner zdavatz commented Jan 30, 2014 XLS for Mac may slightly deviate from the Windows XLS standards. Open And Repair Excel 2013 I've created a gist for the script to reproduce it here: https://gist.github.com/morganchristiansson/8707434 2nd issue Also a 2nd issue, without the following code, affecting the same spreadsheet file. Owner zdavatz commented Jan 30, 2014 yes, so this basically means that saving the file with Office for Mac corrupts the file.

In case a correct backup copy is not available or the backup has gone corrupt, you can use excel recovery solutions to repair your corrupt Excel files.

Sometime error messages are encountered by the users when they try to open an Excel file. The software is very easy to use and can be used by any novice user. 15012 Total Views 45 Views Today How to Resolve Excel error- "File error: data may have Ltd. Excel Recovery Tool Regs, Ana Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread?

However, when in production, the file opens fine on OpenOffice, but fails on Excel for Mac 2011 with the error message "Excel could not open file.xls because some content is unreadable. Reload to refresh your session. Sep 12, 2013 5:31 AM Helpful (0) Reply options Link to this post by Jeffrey Tashman, Jeffrey Tashman Dec 12, 2013 12:40 PM in response to ibizamauigirl Level 1 (0 points) click site If not, how to I overcome this?

Open Menu Close Menu Apple Shopping Bag Apple Mac iPad iPhone Watch TV Music Support Search apple.com Shopping Bag : CommunitiesSign inPostBrowse discussionsContact SupportSearchCommunitiesContact SupportSign inContentPeopleSearch Support CommunitiesiWorkNumbers for Mac Please All rights reserved. I'm not using an earlier version to open later versions. Will bash about with it and give u feedback as soon as I'm done.

Many o... This application allows you to perform calculations and statistical analysis, etc. Do you want to open and repair this workbook? I recently used the file but now when I want to open it it says 'The file you are trying to open is possibly read-only or the location you are trying

Then one of my friends suggested me Mac Excel Recovery software from Stellar. When saved in Excel for Mac 2011 and re-written using spreadsheet gem it opens fine in LibreOffice, but gives “File error: data may have been lost” and contains invalid formula (#REF) Seems that the file has been corrupted or damaged. In the end I found that I could open my Excel file in Numbers!

If it's going to keep causing an error, I might as well scrap the entire macro and just do the entire thing manually, since I'd have to go back and check Generated Wed, 23 Nov 2016 19:20:01 GMT by s_wx1196 (squid/3.5.20) {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software & Apps Office Windows I'm getting really desperaty here! Compact and Repair Utility to Repair MDB Files Just like any other data file, MS Access database files are also not able to safeguard themselves from damage, error, and corruption.

We recommend upgrading to the latest Safari, Google Chrome, or Firefox. However, if the issue still persists, then you can use powerful data recovery software like Kernel for Excel to repair the affected Excel file. I'm emailing spreadsheet files to zdavatz at gmail dot com Owner zdavatz commented Jan 30, 2014 so this book.worksheets.each do |sheet| sheet.each(0) { |row| row.replace row } end actually fixes your