This is a totally valid feature request. Reply With Quote Dec 30th, 2011,10:59 AM #3 brunette Board Regular Join Date Aug 2003 Location Lisbon Posts 71 Re: File Error: Data may have been lost Thanks for the super When I try to open these files, I get the message:Excel could not open [filename] because some content is unreadable. Reply With Quote Dec 30th, 2011,11:20 AM #7 brunette Board Regular Join Date Aug 2003 Location Lisbon Posts 71 Re: File Error: Data may have been lost I can do that. 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
Sep 24, 2014 2:05 AM Helpful (0) Reply options Link to this post by marifilps364, marifilps364 Nov 29, 2014 1:34 PM in response to lastobelus Level 1 (0 points) Nov 29, Will bash about with it and give u feedback as soon as I'm done. How to repair corrupt Excel file using Stellar Phoenix Excel Repair? Beste regards, Ana Last edited by brunette; Dec 30th, 2011 at 10:56 AM.
This software efficiently repairs the damaged Excel sheet and restores its various features such as, tables, charts, formulas, clip arts, cell comments, etc. × Comment Reply Send Close User Comments They were created in 1998 Excel 8.0 (from Office 98), 2000 Excel 9.0 (from Office 2001), and 2001 Excel 10.0 (from Office v.X) (I'm assuming these were the versions I used The file that is producing an error is created via a macro that automatically appends the previous month's year and date to the end of the file name using this command: File Error Data May Have Been Lost Mac Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 30th, 2011,10:56 AM #2 VoG MrExcel MVP Join Date Jun 2002 Location 127.0.0.1 Posts 63,652 Re: File Error:
Apr 14, 2015 4:23 PM Helpful (2) Reply options Link to this post by defender96,Apple recommended defender96 May 21, 2015 8:39 AM in response to lanuguita Level 1 (10 points) May File Error Data May Have Been Lost Excel 2003 Which is fair enough. In the end I found that I could open my Excel file in Numbers! http://msofficerecovery.blogspot.com/2014/04/resolving-excel-error-file-error-data-may-have-been-lost.html 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,
Excel would crash with a EXCBADACCESS every time, on multiple machines and the most recent backup that would open meant losing several hours work. Sas Excel File Error Data May Have Been Lost morganchristiansson commented Jan 30, 2014 Yes my recommendation has been to use LibreOffice, but my colleagues are all using Office for Mac. 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 Very good!ReplyDeleteSandeep Sharma13 November 2015 at 04:31Good solution, Its worked for my fileReplyDeleteUnknown29 December 2015 at 01:04Very good solutionReplyDeleteCGStar20 January 2016 at 05:59How do I use a macro to extract the
However, if you do not have any updated backup then you should use an excel repair software such as Stellar Phoenix Excel Repair tool to repair the excel sheet. Owner zdavatz commented Jan 30, 2014 XLS for Mac may slightly deviate from the Windows XLS standards. File Error Data May Have Been Lost Excel 2007 Your Microsoft Excel sheet can get damaged or corrupt in case of the following circumstance: Virus attack Abrupt system shutdown Operating System corruption Human errorHowever, there are always ways out to File Error Data May Have Been Lost Ssrs Try this with a copy of the workbook http://office.microsoft.com/en-us/ex...010097017.aspx Share Share this post on Digg Del.icio.us Technorati Twitter HTH, Peter Please test any code on a copy of your workbook.
I had a largish file with some tangly formulas with indirect, dcount/dstdev, averageif, and some array formulas and it stopped opening. navigate here Consequently, the Excel sheet comes up with an error that means the file objects, such as charts, images, etc. This is how it SHOULD look like: DEF5Novembro 116AbertasFechadasPendentes71108110Totais_GrupoWorksheet FormulasCellFormulaD5=DATE(YEAR(EOMONTH(NOW(),0)),MONTH(EOMONTH(NOW(),0)),0)E7=D7-F7F7=IF(ISERROR(VLOOKUP("ADMINISTRACION",Pendentes!$A:$C,2,FALSE)),0,VLOOKUP("ADMINISTRACION",Pendentes!$A:$C,2,FALSE))E8=SUM(E7)F8=SUM(F7) This is what happens after I open the file after the error: DEF5#N/A6AbertasFechadasPendentes71108110Totais_GrupoWorksheet FormulasCellFormulaD5=#N/AE7=D7-F7F7=IF(ISERROR(VLOOKUP("ADMINISTRACION",Pendentes!$A:$C,2,FALSE)),0,VLOOKUP("ADMINISTRACION",Pendentes!$A:$C,2,FALSE))E8=SUM(E7)F8=SUM(F7) So I guess my question is: If Log on to your computer and open Microsoft Excel. File Error Data May Have Been Lost Perl
If excel cannot repair the file, some data may be lost.If I click Open and Repair, Excel hangs.Of course, being a Mac user since 1983, these files do not have those Personal Open source Business Explore Sign up Sign in Pricing Blog Support Search GitHub This repository Watch 34 Star 680 Fork 171 zdavatz/spreadsheet Code Issues 18 Pull requests 2 Projects I can add extensions (like .xls) to the file name, which changes the appearance of the icon, but Excel still hangs when trying to Open and Repair these files. Check This Out This will find all Excel spreadsheets on your computer, whether they were created in Excel 2007 or an earlier version.
Which version of Excel are you using? Open And Repair Excel 2013 How to Resolve Excel File Corruption Errors? I'm using Excel 2011.
Please type your message and try again. Fred L Johnson Level 2 (367 points) Mac OS X Q: Excel 2011 can't open old Excel 98 and Excel X files You can perform the following workaround 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 You signed in with another tab or window. Excel Recovery Tool Subscribe to: Post Comments (Atom) Search Popular Posts Recover The Accidentally Deleted/Unsaved Excel Worksheet MS Excel spreadsheet is quite popular application due to its ability of storing and maintaining massive data.
Owner zdavatz commented Jan 30, 2014 How was the Original File created, using what software? Share it with others Like this thread? Click on the small drop-down arrow at the right side of the "Open" button. this contact form As always, your help in this is greatly appreciated and I wish you all the very best for the New Year.
© Copyright 2017 martintools.net. All rights reserved.