Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default File Error: Data May Have Been Lost (Excel 2000)

Excel 2000 (SP-3)
OS = XP Home Edition w/ latest updates (autoupdate)

The Situation/Problem:
Single tab Spreadsheet with 14 "Buttons" and associated VB programs.
Spreadsheet is modified (code edited, new data added to the sheet, etc.) and
saved. After several iterations (the number varies), when the spreadsheet is
reopened and "Enable Macros" selected, the following message is presented:
"File Error: Data May Have Been Lost ". The spreadsheet is presented BUT
all buttons and graphs which were present in all previous open/modity/save
operations are GONE! The VB code is still there BUT buttons can not be
recreated in the same spreadsheet.

More Detail: I used the following "recovery" method.
1. Open a new workbook.
2. Copy the data from the now-corrupt file to the new workbook.
Note: The VB programs are NOT copied to the new workbook.
3. Create new buttons on the new sheet and paste in the VB from the original
spreadsheet.

After completing the above steps, the "new" workbook is again whole and
continues to function (loads, opens, is modified, saved, etc.) - BUT ONLY FOR
A SHORT WHILE!! Eventually (time and frequency varies) the error message is
again presented and the buttons are lost. The "recovery" is painful.

Please, anyone who can shed any light on this issue, please respond.

Thanks, derabbit

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. gillmav Excel Discussion (Misc queries) 1 March 29th 07 08:02 AM
File Error:Data may be lost alantoni Excel Discussion (Misc queries) 3 May 13th 06 12:16 PM
File Error: Data May Have Been Lost Tbird2340 Excel Discussion (Misc queries) 8 March 20th 05 05:31 PM
File Error: Data May Have Been Lost Anthony Setting up and Configuration of Excel 7 March 20th 05 05:31 PM
File error: data may have been lost. Michelle Excel Discussion (Misc queries) 2 January 28th 05 03:17 AM


All times are GMT +1. The time now is 11:21 AM.

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

About Us

"It's about Microsoft Excel"