If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
File Error: Data May Have Been Lost
This sounds a lot like a problem I am having. Have a workbook with
macros/formulas that I e-mail to others when I update it. 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. Then it opens with data gone. Odd thing is it still works fine for me at my home and work PC's. But not for them at all. If I send them a previous version, that one works fine too, so I am very confused. Is probably important to note that this newest update contains new info copy/pasted from other's worksheets that I did not create. But I do not know enough about this problem to search in the new data and fix. Can't go back to older version because too many changes in the new. If anyone can assist, much appreciated. "Ken Wright" wrote: Not sure to be honest as I would have expected the Break links option to work. If you know where the links are then you can do it manually, or by all means send it to me and I'll take a quick look for you. You would need to take the NOSPAM bit out of my email addy. You can also try Bill Manville's excellent FINDLINK addin:- http://www.bmsltd.ie/mvp/ -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Tbird2340" tbird2340(AT)hotmail.com wrote in message ... I tried the file detect repair and that didn't do anything... However, the file in question has links that can't be updated. Apparently the user that created this template lnked it to files on his desktop and then published the template to the network.. There are 3 links.. I'm going to "Edit Links" and I'm trying to break the links to the three files... I can break the link to one of the files but the other two stay there when I try to break the links.. Any ideas?? I think this may have something to do with the data loss.. How can I break these other two links? Thanks! |
#2
|
|||
|
|||
What versions Excel?
File sounds like it may be partially corrupted. Excel 2002 upwards has a File / Open & repair option that may help -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Anthony" wrote in message ... This sounds a lot like a problem I am having. Have a workbook with macros/formulas that I e-mail to others when I update it. 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. Then it opens with data gone. Odd thing is it still works fine for me at my home and work PC's. But not for them at all. If I send them a previous version, that one works fine too, so I am very confused. Is probably important to note that this newest update contains new info copy/pasted from other's worksheets that I did not create. But I do not know enough about this problem to search in the new data and fix. Can't go back to older version because too many changes in the new. If anyone can assist, much appreciated. "Ken Wright" wrote: Not sure to be honest as I would have expected the Break links option to work. If you know where the links are then you can do it manually, or by all means send it to me and I'll take a quick look for you. You would need to take the NOSPAM bit out of my email addy. You can also try Bill Manville's excellent FINDLINK addin:- http://www.bmsltd.ie/mvp/ -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Tbird2340" tbird2340(AT)hotmail.com wrote in message ... I tried the file detect repair and that didn't do anything... However, the file in question has links that can't be updated. Apparently the user that created this template lnked it to files on his desktop and then published the template to the network.. There are 3 links.. I'm going to "Edit Links" and I'm trying to break the links to the three files... I can break the link to one of the files but the other two stay there when I try to break the links.. Any ideas?? I think this may have something to do with the data loss.. How can I break these other two links? Thanks! |
#3
|
|||
|
|||
I tried Open/Repair, but since the file is not having problems on my side, I
am not sure if it fixed anything. Wont know unless I e-mail to my partners and they tell me. If it is partially corrupted, why would it work OK on my end? I get no error at all. Just my partners get it. versions Home - 2002 - works ok work - 2000 - works ok customer site - Not sure which but they are pretty up to date. I believe it is the same version that worked before. I sent a 2-week old verion of the file to them yesterday as a test and that one still works OK for them. Leads me to believe that something crept into my latest update of the file itself that is causing this. In general, what kinds of things can cause this? "Ken Wright" wrote: What versions Excel? File sounds like it may be partially corrupted. Excel 2002 upwards has a File / Open & repair option that may help -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Anthony" wrote in message ... This sounds a lot like a problem I am having. Have a workbook with macros/formulas that I e-mail to others when I update it. 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. Then it opens with data gone. Odd thing is it still works fine for me at my home and work PC's. But not for them at all. If I send them a previous version, that one works fine too, so I am very confused. Is probably important to note that this newest update contains new info copy/pasted from other's worksheets that I did not create. But I do not know enough about this problem to search in the new data and fix. Can't go back to older version because too many changes in the new. If anyone can assist, much appreciated. "Ken Wright" wrote: Not sure to be honest as I would have expected the Break links option to work. If you know where the links are then you can do it manually, or by all means send it to me and I'll take a quick look for you. You would need to take the NOSPAM bit out of my email addy. You can also try Bill Manville's excellent FINDLINK addin:- http://www.bmsltd.ie/mvp/ -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Tbird2340" tbird2340(AT)hotmail.com wrote in message ... I tried the file detect repair and that didn't do anything... However, the file in question has links that can't be updated. Apparently the user that created this template lnked it to files on his desktop and then published the template to the network.. There are 3 links.. I'm going to "Edit Links" and I'm trying to break the links to the three files... I can break the link to one of the files but the other two stay there when I try to break the links.. Any ideas?? I think this may have something to do with the data loss.. How can I break these other two links? Thanks! |
#4
|
|||
|
|||
Corruption, if indeed that is what it is, is extremely hard to nail down I'm
afraid. 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. You woulod need to take the NoSpam bit out of my email addy. Might help to have one that you know works and one that doesn't -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Anthony" wrote in message ... I tried Open/Repair, but since the file is not having problems on my side, I am not sure if it fixed anything. Wont know unless I e-mail to my partners and they tell me. If it is partially corrupted, why would it work OK on my end? I get no error at all. Just my partners get it. versions Home - 2002 - works ok work - 2000 - works ok customer site - Not sure which but they are pretty up to date. I believe it is the same version that worked before. I sent a 2-week old verion of the file to them yesterday as a test and that one still works OK for them. Leads me to believe that something crept into my latest update of the file itself that is causing this. In general, what kinds of things can cause this? snip |
#5
|
|||
|
|||
Ken, trying to send you the file but your firewall blocks any file with
active script. I sent without the 'NoSpam' thing included in the address. "Ken Wright" wrote: Corruption, if indeed that is what it is, is extremely hard to nail down I'm afraid. 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. You woulod need to take the NoSpam bit out of my email addy. Might help to have one that you know works and one that doesn't -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Anthony" wrote in message ... I tried Open/Repair, but since the file is not having problems on my side, I am not sure if it fixed anything. Wont know unless I e-mail to my partners and they tell me. If it is partially corrupted, why would it work OK on my end? I get no error at all. Just my partners get it. versions Home - 2002 - works ok work - 2000 - works ok customer site - Not sure which but they are pretty up to date. I believe it is the same version that worked before. I sent a 2-week old verion of the file to them yesterday as a test and that one still works OK for them. Leads me to believe that something crept into my latest update of the file itself that is causing this. In general, what kinds of things can cause this? snip |
#6
|
|||
|
|||
Must be the ISP's firewall doing that. Try zipping the file(s), or just
changing the extensions to .dat or something. I can then just change back this end -- Regards Ken....................... |
#7
|
|||
|
|||
|
#8
|
|||
|
|||
LOL - You missed off the world bit, but please don't post it as a real addy.
ken dot wright at ntlworld dot com ^^^^^^ -- Regards Ken....................... "Anthony" wrote in message ... Did not go through again. I sent to with a ".dat" suffix. Never mind. "Ken Wright" wrote: Must be the ISP's firewall doing that. Try zipping the file(s), or just changing the extensions to .dat or something. I can then just change back this end -- Regards Ken....................... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Upgrading Outlook XP to Outlook 2003 | Rosemary | Installation & Setup | 2 | March 1st, 2005 04:35 PM |
Office 2003 uninstall/reinstall problems | Jerryn3 | Setup, Installing & Configuration | 2 | August 2nd, 2004 03:39 PM |
Application must be installed to run Error | Keith | Setup, Installing & Configuration | 1 | June 29th, 2004 03:02 AM |
Unsafe Attachments | Ron | Installation & Setup | 2 | June 9th, 2004 01:55 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |