Disappearing Excel Data

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Very strange problem here, was wondering if anyone has
run into this.

After inserting a new worksheet into an existing
workbook and after cut/pasting data from existing
worksheet into this new worksheet; and saving... the next
time this new worksheet is opened the data is missing,
however the headings still remain. No error messages are
displayed and no unusual events are logged. This happens
intermittantly and the spreadsheet is only 1.7MB in size
and contains 18 worksheets. Also the worksheets contain
no VBA scripts or macros. We're running XP Professional
and Office XP; I've run anti-virus scans and this turns
up nothing, also the Excel files are located on a Windows
2003 Server share.

Late Development - my client called again today, same
problem reoccurred. However, this time he mentioned that
after inserting and building the new worksheet he
witnessed screen distortion while horizontally
scrolling.... and you guessed it... every cell he
scrolled past (upon review) was erased. Argh!!!
 
Hi Tom,
Right click on the worksheet tab, view code. If you have a
subroutine there -- you had better know what it is doing. If
that is the problem then check for a sheet.xlt template on
your system that contains such code.
 
Hi Dave,
I've checked each worksheet for code (righ-click view
code) and I have found none. But, when I open the
spreadsheet I receive the "contains macros" message. Can
macros be hidden?

Thanks,

Tom
 
Back
Top