Home > File Error > File Error Data May Have Been Lost Excel 2000

File Error Data May Have Been Lost Excel 2000

But, if the file does not open, then it might be corrupt. This project is pretty much done if I can figure out how to fix this damn "resource problem". It is a totally blank VBA message box with the 'vbCritical' icon on it (red circle with the white X in it) with 'OK' and 'Help' buttons. Now it just dawn on me, this is an array correct so ctrol,shift, enter may be needed??

PPT is a presentation file, which is... Some number formats may have been lost". Please try the request again. How can I suppress if not resolve another way. news

Any ideas? Do you want to open the file now?" If I click "Yes", I get another VBA error: "Run time error 53. Has worked fine for over a year until yesterday it started giving the 'File Error: data may be lost' when they open it, then lots of clicks thru error messages.

more info here: Best fix is move to .xlsx or .xlsm formats, only save to .xls to send to people without 2007. File error: data may have been lost - Excel Troubleshooting When transferring a spreadsheet that works on one system to a similarly configurated PC, I get this error message and cannot I tried the following: - Renaming - Converting to a different file format (didn't work, it won't let me) - Opening in notepad...etc doesn't work. These processes usually help but every so often the problem comes back.

If I try to open it from the existing window (even when I close this file and reopen it in the same window), I get "Path/File access error", and when I I have tried the usual formatting of cells, painting formats from other sheets, copying and pasting formats all to no avail. More than happy to try opening it and see if it plays up my end, assuming you are able/willing to send it out - your call. Tbird2340 Reply With Quote 02-09, 09:15 PM #8 Re: File Error: Data May Have Been Lost Not sure to be honest as I would have expected the Break links option to

I read the function GETPIVOTDATA. Doesn't alter it in any way. View 11 Replies View Related File Not Found Error 563 Dec 17, 2009 The error that pops up has no information other than "File not found" in a dialog box with Check the spelling of the file name, and verify that the file locations is correct.

Then open the copy you made and save it - now that file will fail to show up in the Search ! ! You only have a problem with files made with XLC in Excel 2003 which give you the error when opened in Excel 2000? The text files do have a header, but that shouldn't be an issue... Is there a way I can change this back?

Could this be part of the problem?) It crashes on this line If Sheets(3). navigate here Make efficient Access Database File repair with Microsoft Detect and Repair tool Microsoft has incorporated a tool named Detect and Repair in MS Office XP, Office 2003, and Office 2007 using You need to impor... I receive the error message "excel could not save all the data and formatting you recently added to the file".

Any ideas for help? Microsoft office excel may be able to save the file by removing or repairing some features. How can I open these files, change them, and then save the new files? Check This Out in forum Microsoft InfoPath Replies: 3 Last Post: 06-30, 10:00 PM Bookmarks Digg StumbleUpon Google Posting Permissions You may not post new threads You may not post replies You may

In other words what has taken 2-3 weeks so far i can now recover and probably take me a couple of days. But not for them at all. I have tried playing with the command, but I really don't know what I am doing and have had no luckDoes anyone know of a way to retrieve that stored data

So i am extremely grateful for your help.

Stay logged in Welcome to PC Review! To Cancel Saving the file, click cancel... 2. If the cells it is referencing are empty, it is blank. Simplify VBA Coding for Common Functions ' These modules exist just to make other VBA code easier to write and more readable ' For example, you can just ent ...

Also please try this - using Windows Explorer, copy the good file and then redo the Search. View 3 Replies View Related Lost Formatting Nov 9, 2008 I have a workbook that is used by others and has been working reasonably well for several years. File contains some VBA.... this contact form View 2 Replies View Related Macro Assignment Lost When File Name Is Changed Nov 17, 2007 When I use customize and assign a macro (to a button) I set the "Marco

This is so perplexing that I have placed 2 zip Sample files on my website for you to Download Unzip the two files to any folder. View 3 Replies View Related File Might Have Been Damaged Error Dec 14, 2009 I have some very important excel spreads that are returning this error..."The file might have been damaged MMC Cory Guest When I opened a large excel 2007 file I received the following error message: "File error: data may have been lost". Thanks for any comments!

The file will open, in a flash, and the macros don't work. So it must be out there in a file...? The whole sheet is effected so that new entries appear the same way although the correct format appears in the formula bar.I don't know if this is relevant but the sheet The file opens but has lost all the XLC input.

the program seems to work fine the majority of the time but every so often we recieve an error message that causes excel to not save, or to crash and shut This didn't work. View 3 Replies View Related Home Submit Resource Tracker Forum Advance Search Privacy Policy| Terms of Use & Service| Contact Us| Copyrights Notice Copyrights 2005-15, All rights reserved

Favoured: 0 Page: < End>> TOPIC: File error: data may have been lost Forum Tools Post New Topic Pdf Show latest posts RulesHelp #1369 burmie (User) Tadpole

Jul 9, 2013 I created a macro to run with my daily reports in excel. it gives another message " Excel encountered errors during save. i want to keep the same formulas but reference the tabs on blank file.Is there a quicker way to do this rather and going into all the cells and changing reference sumardi, Nov 5, 2009 #2 Advertisements Simon Murphy Guest That error message is normally caused by opening a .xls format file that had some analysis toolpak functions in it.

I also tried numerous Search Utilities (Agent Ransack, File Boss, PowerDesk File Finder, Turbo Search, etc) and they all have the SAME problem. File Attachment: File Name: Book2.xlsFile Size: 15360 Logged Training, engineering consultancy and finite element analysis. This file is being generated by the Java program. It's happening quite often with some of her files, and we can't save as a new file each time, as it will cause confusion, and she already printed the wrong file

© Copyright 2017 All rights reserved.