Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 05, 09:56 PM
Tbird2340
 
Posts: n/a
Default File Error: Data May Have Been Lost

A user setup an excel spreadsheet to use as a template in Excel XP (2002).
This file is opened successfully from a network drive from both Excel 2003
and 2002.. The user makes changes to this file and then saves it as a
different name to a network drive. When an Excel 2002 user makes changes to
this file and then saves it and an Excel 2003 user goes to open that file
they get:

"File Error: Data May Have Been Lost"

They click OK and get that message about 25 times before they can open the
file. When they do open the file there is indeed a bunch of data missing.

Is there some sort of incompatibility between Excel 2002 and 2003?

2002 to 2002 users do not have this problem.

Thanks for any input.



  #2   Report Post  
Old March 19th 05, 08:11 AM
Anthony
 
Posts: n/a
Default

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   Report Post  
Old March 19th 05, 04:57 PM
Ken Wright
 
Posts: n/a
Default

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   Report Post  
Old March 19th 05, 05:25 PM
Anthony
 
Posts: n/a
Default

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!








  #5   Report Post  
Old March 19th 05, 05:52 PM
Ken Wright
 
Posts: n/a
Default

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   Report Post  
Old March 19th 05, 10:31 PM
Anthony
 
Posts: n/a
Default

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




  #7   Report Post  
Old March 20th 05, 12:16 AM
Ken Wright
 
Posts: n/a
Default

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



  #9   Report Post  
Old March 20th 05, 05:31 PM
Ken Wright
 
Posts: n/a
Default

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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File error: data may have been lost. Michelle Excel Discussion (Misc queries) 2 January 28th 05 03:17 AM
Lost File Baby Church Excel Discussion (Misc queries) 2 January 28th 05 12:38 AM
How to recover worksheets lost when I opened an Excel file in Wor. Steviek1 Excel Worksheet Functions 0 January 23rd 05 10:53 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Why is pointer and keyboard control is lost in certain Excel file. MarkB3 Excel Discussion (Misc queries) 0 January 4th 05 07:15 PM


All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017